• Installing the CData DBAmp Windows Service
  • 1. Create and set up the DBAmp linked server
  • 2. Set up the New Linked Server
  • 3. Check your Server Options
  • 4. Create the DBAmp Linked Server

Installing the CData DBAmp Windows Service

To install the CData DBAmp Windows Service on the SQL Server Instance, open the CData DBAmp setup application:

Then follow these steps:

1. Create and set up the DBAmp linked server

Create and set up the DBAmp linked server where the server DBAmp is installed. In MS SQL Server Management Studio, create a new linked server by navigating to the Server Objects > Linked Servers tree in the Object Explorer. Right-click Linked Servers > New Linked Server:

2. Set up the New Linked Server

Enter the following information on the General page of the Linked Server:

• Linked Server: The name of your DBAmp linked server.
• Provider: Choose Microsoft OLE DB Driver for SQL Server.
• Data Source: localhost,1435
• Provider String (sandbox connections only): App=https://test.salesforce.com. For non-sandbox connections, leave blank.

Select Be made using this security context on the Security page of the Linked Server and enter your Salesforce credentials:

• Remote Login: Salesforce username.
• With Password: Your Salesforce password with your Security Token appended.

3. Check your Server Options

Check that only the following options are set to True on the Server Options page of the Linked Server:

• Collation Compatible
• Data Access
• RPC
• RPC Out
• Use Remote Collation

Check that Enable Promotion of Distributed Transactions for RPC is False.

4. Create the DBAmp Linked Server

Click OK to create the DBAmp Linked Server.