You can create connections to your Salesforce instance from the . This connector is designed as a wrapper around the Salesforce REST API.

Limitations

Pre-requisites

Enable

Configure

To create this connection:

This connection can also be created using the API. 

NOTE: This connection cannot be created through the CLI.

Modify the following properties as needed:

PropertyDescription
Server Name
Enter the host name of your Salesforce implementation.
Security Token generated in accountPaste the security token associated with the account to use for this connection.
Default Column Data Type Inference

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

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 ConnectionAfter you have defined the connection credentials type, credentials, and connection string, you can validate those credentials.
Connection NameDisplay name of the connection
Connection DescriptionDescription of the connection, which appears in the application.

Configuration modifications

You can make the following modifications to the Salesforce connection by performing the following steps.

Steps:

  1. Login to the  as an administrator.
  2. Navigate to the following directory:

    /opt/trifacta/services/data-service/build/conf/vendor/salesforce/


  3. Edit the file: salesforce/connection-metadata.json.
  4. Add configuration parameters to the connectUrl value.

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 connectURL value:

ConfigOptions=(auditcolumns=all;mapsystemcolumnnames=0)

Save the file.

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 connectURL string:

StmtCallLimit=0