Salesforce to Oracle using Talend Open Studio

Salesforce to Oracle using Talend Open Studio:

Talend Open Studio for Data Integration Version: 6.3.1
Java Compiler: 1.7
OS: Windows 8

This article will walk through the following steps to load data from Salesforce to Oracle table :

1. Get secret key from salesforce
2. Add Talend components to Designer
3. Create connection to Salesforce and reverse engineer the required tables
4. Update the component properties for salesforce and connect to it to target
5. Complete the mapping and execute the job

This article will not cover the installation and setup of Talend Open Studio. The assumption is talend already installed and is working correctly. For details on how to install and configure Talend Open Studio see this post.

In the previous post we saw how to consume public web service followed by a parsing mechanism and present it as a table structure using tlogRow component. Today we will create a job that will connect to Salesforce using username, password and secret key. Before that I am assuming you have already registered with Salesforce if not this is the link for signup. Once done go to setup and click on reset my security key. Remember if you have some other application using the old credentials then that needs to be updated with the new secret key.


Now lets create a new job “job_Salesforce_to_tLogRow” under Job Designs in repository explorer. Go to metadata and right click on Salesforce > Create Salesforce. Fill the user id, password ( login email id and password) and security key that you had received in your mail box.

Upon connection successful, select the tables that you want to reverse engineer. We will go ahead with two tables account and case.

Click finish and notice the table schema information under the Salesforce connection.

Next drag tSalesforceInput, tMap, tOracleOutput, tLogRow in to the design canvas. Either you search them in the palette or start typing directly in the design workspace, a drop down will be popped up immediately. This is how it looks like in my studio.

Configure the property for Salesforce component as shown below and then the mapping information inside tMap component.

Now press F6 to build and execute the job. As you can see 16 rows has been loaded to target table.

Thats it for today. Let me know if you are stuck at some point.

Thank you!!!

About Bhabani 86 Articles
Bhabani has 12 plus years of experience in Data warehousing and Analytics projects that has span across multiple domains like Travel, Banking and Financial, Betting and Gaming Industries. Solution areas he focuses on designing the data warehouse and integrating it with cloud platforms like AWS or GCP. He is also a Elite level contributor at OTN forum more than 9 years. He loves to do experiment and POC on different integration tools and services. Some of his favorite skills are Redshift, Big Query, Python, Apache Airflow, Kafka, HDFS, Map Reduce ,HIVE, Habse, Sqoop, Drill, Impala.

1 Comment

Comments are closed.