Salesforce to Database

Create a Data Interface to extract Accounts data from Salesforce and load it into a Database.

Refer to the attached video on the steps involved in setting up a data interface between a source and target application.

The JDBC URL in the DB Info activity to configure the Salesforce connection uses the following format:

jdbc:salesforce:User=myUser;Password=myPassword;Security Token=myToken;

Salesforce Driver is already bundled with the product and select this driver from the Database Driver drop-down list as shown in the video.