Page tree

Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version r0871

D toc

You can create connections to your Salesforce instance from

D s product
. This connector is designed as a wrapper around the Salesforce REST API.

Supported Environments:


D s product

AmazonMicrosoft Azure
WriteNot supportedNot supportedNot supported


D s conn req sql

  • This is a read-only connection. 
  • Single Sign-On (SSO) is not supported.
  • Custom domains are not supported.
  • You cannot ingest Salesforce tables that require mandatory filters.


  • The account used to login from

    D s product
     must access Salesforce through a security token. 


    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. 

  • If you haven't done so already, you must create and deploy an encryption key file for the 
    D s node
     to be shared by all relational connections. For more information, see Create Encryption Key File.


  • General relational connectivity must be enabled. For more information, see Relational Access.
  • This connection type utilizes OAuth 2.0 for authentication.


    NOTE: OAuth 2.0 authentication requires additional configuration specific to the connection type.

    For more information, see Enable OAuth 2.0 Authentication.


To create this connection, in the Connections page, select the Applications tab. Click the Salesforce card. See Connections Page.

Modify the following properties as needed:

Server Name

Enter the host name of your Salesforce implementation. Example value:

Code Block
Connect String OptionsApply any connection string options that are part of your authentication to Salesforce. For more information, see below.
Credential Type

Select the type of credentials to provide with the connection:

  • SecurityToken - apply the security token that has been generated within the account to authenticate to Salesforce.

OAuth 2.0 - use OAuth 2.0 client connect to Salesforce. Since the

D s webapp
supports a single global Salesforce connection, the OAuth 2.0 client is already defined in the
D s webapp


NOTE: After you have specified the connection to use OAuth 2.0, click Authenticate to validate the connection with the target datastore. If you have modified the connection, click Re-authenticate to validate the new connection definition. You must re-authenticate if you receive an expired tokens message. For more information, see Enable OAuth 2.0 Authentication.

OAuth 2.0 Client

(OAuth 2.0 credential type) Select the OAuth 2.0 client to use.

User Name(SecurityToken credential type) Username to use to connect to the database.
Password(SecurityToken credential type) Password associated with the above username.
Security Token generated in account(SecurityToken credential type) Paste the security token associated with the account to use for this connection.
Test Connection

(SecurityToken credential type) After you have defined the connection credentials type, credentials, and connection string, you can validate those credentials.

Default Column Data Type Inference

Set to disabled to prevent the platform from applying its own type inference to each column on import. The default value is enabled .

Connection NameDisplay name of the connection
Connection DescriptionDescription of the connection, which appears in the application.

Connect string options

Connection timeout

By default, the supported driver applies a connection timeout to Salesforce of 60 seconds. As needed, you can modify the connection timeout through connect string options:

Code Block


<value_in_seconds> corresponds to the number of seconds for the time. 


NOTE: Although it is not recommended, you can set this value to 0 to disable timeouts.

Schema caching

By default, the connection driver uses schema caching to speed up ingestion. To surface changes to Salesforce tables/schema immediately, you can use the following options to disable schema caching by the connection:

Code Block

Create via API

This connection can also be created using the API. 


NOTE: If you are using OAuth 2.0 authentication for this type, you cannot create connections via API.

  • Type: jdbc
  • Vendor: salesforce

For more information, see

D s api refdoclink


You can import datasets from Salesforce through the Import Data page. See Import Data Page.

Using Salesforce Connections

Uses of Salesforce

D s product
 can use Salesforce for the following tasks:

  1. Create datasets by reading from Salesforce tables.

Before you begin using Salesforce

Read Access:

  • Your Salesforce administrator must configure read permissions. 

  • You must acquire a Salesforce security token for use with the Salesforce connection.

Secure access

SSL is the default connection method.

Storing data in Salesforce

Your Salesforce administrator should provide database access for storing datasets. Users should know where shared data is located and where personal data can be saved without interfering with or confusing other users. 



D s product
does not modify source data in Salesforce. Datasets sourced from Salesforce are read without modification from their source locations.

Reading from Salesforce


D s product
 connects to your Salesforce instance, the application can read from all Salesforce objects that are accessible through the Salesforce account in use, including:

  • Salesforce objects and fields are mapped to tables and columns
  • Standard and custom objects


    NOTE: The names of custom objects are appended with the value _c.

  • Audit columns
  • System fields

NOTE: Unquoted identifiers are converted to uppercase during import.

You can create a 

D s item
 from a table stored in Salesforce.

Writing to Salesforce

Not supported.


Supported Versions: n/a

Supported Environments:


D s product

AmazonMicrosoft Azure
WriteNot supportedNot supportedNot supported