You can create connections to your Salesforce instance from . This connector is designed as a wrapper around the Salesforce REST API.
The account used to login from must access Salesforce through a security token.
NOTE: Please contact your Salesforce administrator for the Host Name and the Security Token values. |
For more information, see Enable Relational Connections.
To create this connection:
This connection can also be created using the API.
Property | Description |
---|---|
Server Name | Enter the host name of your Salesforce implementation. |
Security Token generated in account | Paste the security token associated with the account to use for this connection. |
Connect String Options | Apply any connection string options that are part of your authentication to Salesforce. For more information, see below. |
User Name | (basic credential type only) Username to use to connect to the database. |
Password | (basic credential type only) Password associated with the above username. |
Test Connection | After you have defined the connection credentials type, credentials, and connection string, you can validate those credentials. |
Default Column Data Type Inference | Set to |
Connection Name | Display name of the connection |
Connection Description | Description of the connection, which appears in the application. |
You can apply the following options to your connection string.
By default, Salesforce does not include system columns generated by Salesforce in any response. To include them, add the following value to the Connect String Options textbox:
ConfigOptions=(auditcolumns=all;mapsystemcolumnnames=0) |
By default, Salesforce imposes a limit on the number of calls that can be made through the REST APIs by this connector.
You can make the number of calls unlimited by appending the following to the Connect String Options textbox:
StmtCallLimit=0 |