Salesforce Connection

Overview

Salesforce Connection Manager is SSIS Connection Manager for establishing Salesforce connections. Use the API to build components based on Salesforce Connection Manager.

Setup

Use the Salesforce Connection Manager dialog to specify properties for connecting to Salesforce service.

Server Options

User name

Specify user name in email-like format.

Password

Specify password to access Salesforce service.

Time-out (secs)

Specify the number of seconds before timing out session connect. The default value of this property is 60 seconds.

RetainSameConnection

Specify if all clients should use the same connection. This property has the options listed in the following table.

Value	Description
True	All clients use same connection (default).
False	Every client use different connection.

Test Connection

Confirm connection manager configuration by clicking Test Connection.

Advanced Options (1.4 SR-1)

Server URL (1.4 SR-1)

Specify Salesforce service URL. This property should be explicitly specified when doing sandbox testing. Sample URLs:

• https://test.salesforce.com/services/Soap/u/9.0
• https://test.salesforce.com/services/Soap/c/17.0

Proxy Options (1.4 SR-3)

Host (1.4 SR-3)

Specify the name or IP address of the proxy server. If not specified, proxy server is not used.

Port (1.4 SR-3)

Specify the port number on the proxy server to use for the connection.

User name (1.4 SR-3)

Specify user name to access the proxy server.

Password (1.4 SR-3)

Specify password to access the proxy server.