Get started with Salesforce

Overview

Etlworks Salesforce connector allows fast real-time access to Salesforce data. The connector supports all objects and metadata (fields) available through the Salesforce API and works just like any other database connector. 

Connect to Salesforce

Create a Salesforce Connection to work with data in Salesforce.

Extract data from Salesforce

Extracting data from Salesforce is similar to extracting data from the relational database.

Step 1. Create a Salesforce Connection which will be used as a source (FROM).

Step 2. Create a destination Connection, for example, a Connection to the relational database, and if needed, create a Format (Format is not needed if the destination is a database or well-known API).

Step 3. Create a Flow where the source is a database and the destination is a Connection created in step 2, for example relational database.

Step 4. Add a new source-to-destination transformation.

Step 5. Select the Salesforce Connection created in step 1 as a source Connection and select the Salesforce object you are extracting data from:

Step 6. Select a TO Connection, Format (if needed), and object (for example database table) to load data into.

Step 7. Click MAPPING and optionally enter Source query (you don't need a query if you are extracting data from the Salesforce object unconditionally):

Step 8. Optionally define the per-field mapping.

Step 9. Add more transformations if needed.

Load data in Salesforce

Loading data in Salesforce is similar to loading data into relational database.

Step 1. Create a source Connection and a Format (if needed).

Step 2. Create a destination Salesforce Connection.

Step 3. Create a Flow where the destination is a database.

Step 4. Add a new source-to-destination transformation.

Step 5. Select FROM and TO Connections and objects (also a FROM Format if needed).

Step 6. Optionally define the per-field mapping.

Step 7. Add more transformations if needed.

Browse data in Salesforce

You must have a Salesforce Connection to browse objects and run SQL queries.

Use Etlworks Explorer to browse data and metadata in Salesforce as well as execute DML and SELECT queries against Salesforce Connection.