connecting from SQL 2008 to

Posted on 2009-02-11
Last Modified: 2013-11-24
I am trying to find out if I can extract the records from objects in to SQL2008 database server. Does anyone know if SQL 2008 has direct connection to  Could we use SSIS in sql2008 for that?

Question by:Pengchea
    LVL 3

    Accepted Solution

    The only truly integrated solution at the database level is dbAmp from It will see your Salesforce Org and database as an SQL Linked Server.

    I wrote quite a bit about it here:

    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.

    Author Comment

    Is there any security risk of installing this on the database server?
    LVL 3

    Expert Comment

    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.

    Author Comment

    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?
    LVL 3

    Expert Comment

    Installed on the SQL Server. It creates a Linked Server in SQL Management Studio. You can read about how it is installed here
    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
    Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    9 Experts available now in Live!

    Get 1:1 Help Now