Page tree

Trifacta Dataprep


On January 27, 2021, Google is changing the required permissions for attaching IAM roles to service accounts. If you are using IAM roles for your Google service accounts, please see Changes to User Management.


Feature Availability: This feature is available in Cloud Dataprep Premium by TRIFACTA® INC.


This section describes how you interact through Cloud Dataprep by TRIFACTA® INC. with your Salesforce data warehouse.

  • Salesforce is a SaaS-based customer relationship management platform for managing the customer lifecycle. For more information, see


  • This connection is read-only.

Uses of Salesforce

Cloud Dataprep by TRIFACTA INC. 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.

  • See Create Salesforce Connections.

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. 

NOTE: Cloud Dataprep by TRIFACTA INC. does not modify source data in Salesforce. Datasets sourced from Salesforce are read without modification from their source locations.

Reading from Salesforce

When  Cloud Dataprep by TRIFACTA INC. 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 Trifacta dataset from a table stored in Salesforce.

For more information, see Salesforce Browser.

Writing to Salesforce

Not supported.

This page has no comments.