Connecting DBAmp to SQL Server

by Unknown November 16, 2015 0 comments

DBAmp is designed to be used as a linked server. To install DBAmp as a linked server, use the SQL Management Studio and perform the following steps:
1. Using the SQL Server Management Studio, use the Object Explorer window and expand the Server Objects branch to display Linked Servers.
2. Right click on Linked Servers and choose New Linked Server... Enter the following information for the new Linked Server:

General Page

Linked Server: Enter SALESFORCE
Provider: Choose DBAmp OLE DB Provider
Product Name: Enter DBAmp
Location: If you are connecting to a sandbox, enter https://test.salesforce.com. Otherwise, leave blank.

Security Page

Click Be made using this security context:
For Remote Login: enter your salesforce.com UserId.
For With password: enter your salesforce password. If needed by your salesforce organization, append the salesforce security token to the end of the password. For more details on salesforce security tokens, see the Security Tokens section in the online salesforce help.

Server Options

Check the following are true (leaving all other options false):
Collation Compatible
Data Access
Use Remote Collation
RPC Out
Enable Promotion of Distributed Transactions
3. Press OK to create the SALESFORCE linked server