dotConnect for Salesforce Documentation
Creating a Salesforce Connection

Prior to configuring a Salesforce connection, make sure you are a registered user at salesforce.com.

To create a connection for Salesforce, do the following:

  1. Right-click in the Connection Managers pane and select New Connection from the context menu. The Add SSIS Connection Manager dialog box is displayed:

  2. In the Connection manager type list select DevartSalesforce and click Add. The General tab of the Salesforce Connection Manager Editor dialog box is displayed:

  3. In the Login Information area, specify the User name (email address) and Password you have specified, and Security Token you have received when registering at the Salesforce website; in the Proxy Information area, specify the required Host and Port; in the Authorization area, specify the User name and Password and click OK.

The connection is now created.