| D toc |
|---|
You can create connections to your Salesforce instance from
| D s product | ||
|---|---|---|
|
Limitations
- This is a read-only connection.
- Single Sign-On (SSO) is not supported.
- Custom domains are not supported.
Pre-requisites
The account used to login from
must access Salesforce through a security token.D s product Info NOTE: Please contact your Salesforce administrator for the Server Name and the Security Token values.
- The logged-in user must have required access to the tables and schema. For more information, see Using Salesforce.
- If you haven't done so already, you must create and deploy an encryption key file for the
to be shared by all relational connections. For more information, see Create Encryption Key File.D s node
Enable
For more information, see Enable Relational Connections.
Configure
To create this connection:
- In the Connections page, select the Applications tab. Click the Salesforce card.
- See Connections Page.
This connection can also be created using the API.
- For details on values to use when creating via API, see Connection Types.
- See API Reference.
| Property | Description | ||
|---|---|---|---|
| Server Name | Enter the host name of your Salesforce implementation. Example value:
| ||
| Connect String Options | Apply any connection string options that are part of your authentication to Salesforce. For more information, see below. | ||
| User Name | Username to use to connect to the database. | ||
| Password | Password associated with the above username. | ||
| Security Token generated in account | Paste the security token associated with the account to use for this connection. | ||
| 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. |
Connect string options
You can apply the following options to your connection string.
Include system columns
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:
| Code Block |
|---|
ConfigOptions=(auditcolumns=all;mapsystemcolumnnames=0) |
Unlimited number of calls
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:
| Code Block |
|---|
StmtCallLimit=0 |
Use
You can import datasets from Salesforce through the Import Data page. See Import Data Page.
- See Salesforce Browser.
- For more information on interacting with Salesforce, see Using Salesforce.
