Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2059
  • Last Modified:

connecting from SQL 2008 to Salesforce.com

Hi,
I am trying to find out if I can extract the records from objects in salesforce.com to SQL2008 database server. Does anyone know if SQL 2008 has direct connection to salesforce.com?  Could we use SSIS in sql2008 for that?

Thanks,
Chea
0
Pengchea
Asked:
Pengchea
  • 3
  • 2
1 Solution
 
pauldesatadvologixdotcomCommented:
The only truly integrated solution at the database level is dbAmp from www.forceamp.com. It will see your Salesforce Org and database as an SQL Linked Server.

I wrote quite a bit about it here:
http://www.experts-exchange.com/Database/Software/CRM/Salesforce.com/Q_24110988.html?sfQueryTermInfo=1+dbamp

I use it every day.... schedule sync jobs, do direct insert, update and selects to the salesforce dbs, run SQL Server Reporting services off a synchronized Salesforce db copy. It's great.
0
 
PengcheaAuthor Commented:
Is there any security risk of installing this on the database server?
0
 
pauldesatadvologixdotcomCommented:
No, security is completely controlled by your salesforce userid, pwd and security token. The only other thing I could think of is the database access you give your domain or SQL Server userids to the database that you replicate data to from Salesforce. Anyone who accesses replicated data to the SQL server from Salesforce is not bound by any of the roles and sharing rules that their salesforce id would have in the salesforce system.

Basically, it's going to be as secure as the SQL Server security model you have implemented on your server.
0
 
PengcheaAuthor Commented:
Do we need to install this on the SQL server or it can be installed in any application server and SQL server can use it?
0
 
pauldesatadvologixdotcomCommented:
Installed on the SQL Server. It creates a Linked Server in SQL Management Studio. You can read about how it is installed here
http://forceamp.com/doc.htm
by reading the DBAmp Help Documentation. Basically it acts as a "plug in" to SQL Studio, so that in your management tree, you would be able to drill down into your server and databases as well as your salesforce server/database. Then use the provided stored procedures from dbamp to manipulate, move, sync data between the 2, or interact with the salesforce data directly, using SQL syntax.
0

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now