Salesforce Integration and Migration using Talend ETL

Salesforce Integration and Migration using Talend ETL
On November 29, 2016, Posted by , In Integration,Migration

What is Talend?

Talend is a software vendor specializing in Big Data Integration. The company provides big data, Cloud, data integration, data management, Master Data Management, data quality, data preparation and enterprise application integration software and services. It is one of the best open-source tools for data integration and migration.

Why Talend?

Reasons to go for the Talend tool:

  • Easy interface and placement of components.
  • Code creation by drag and drop.
  • Better processing speed.
  • Open source ETL.
  • A large community of supporters.
  • Around 800 inbuilt connectors.
  • Export JARs, WARs and run them separately.
  • Easy to schedule using Windows Task Scheduler.
  • Cloud version also available.

How to use Talend for Data Migration in Salesforce?

Exporting data from salesforce account object into CSV file(s), Below are the steps:

  • Launch Talend ETL in your Operating system (Window etc.).
  • Right-click on Job Designs which is on the left side of the Talend window > create a job.
  • A new job pop-up will appear where you have to give a name whatever you want > Finish.
  • Click on drop down arrow of Metadata > Choose Salesforce > Create Salesforce Connection > write a connection name as you want > Next > give credentials for valid Salesforce Org > check login > Finish.
  • Select a Salesforce Object (In our example it is an Account object).
  • From the palette sidebar (which is showing on the right side) select tMap.
  • Drag and drop a connection in between Account, tMap and tFileOutputDelimited.
  • Now double click on the map and do field mapping.
  • Run the job, it successfully exported the data into a CSV file.

Importing data from CSV file(s) into salesforce account object, Below are the steps:

  • Again need to launch Talend ETL in your Operating system (Window etc.).
  • Right-click on Job Designs which is on the Left side of the Talend window > create a job.
  • A new job pop-up will appear where you have to give a name whatever you want > Finish.
  • Click on drop down arrow of Metadata > Choose Salesforce > Create Salesforce Connection > write a connection name as you want > Next > give credentials for valid Salesforce Org > check login > Finish.
  • Select a Salesforce Object (In our example it is an Account object).
  • From the palette sidebar (which is showing in the right side) select tMap.
  • Drag and drop a connection in between tFileOutputDelimited, tMap and Account.
  • Now double click on the tMap and do field mapping.
  • Run the job, it successfully imported data into the Account object. of the Salesforce.

Above are the few steps to create a simple Job to migrate an Account from CSV and vice versa, this is all about “Salesforce Integration and Migration using Talend ETL“.


AwsQuality helps businesses gain competitive edge with solutions on Salesforce cloud and mobile technologies with Offices Noida India, Louisiana focused customers are in the UK, US, Asia, South America and Australia.

Comments are closed.