Connect, Access and Transform any data across on-premise or on Cloud
Talend is mainly used for integration between operational systems, as well as for ETL (Extract, Transform, Load) for Business Intelligence and Data Warehousing, and migration. It is one of the best tools available in the market, mainly used for Data Integration. In Talend, most of the work is done by just dragging and dropping the components which are already coded to perform a specific job. Talend is an open-source tool that makes it easily accessible.
Click here to download Talend Open Studio.
Main Window of Talend Studio
The Talend Studio multi-panel window contains the following section:
- Menu Bar
- Repository View
- Code Viewer
- Outline Viewer
- Detailed View
- Tab Panel
1.) Repository View
The Repository tree view is a collection of technical items that can be used to describe business models or to design jobs and for documentation.
The below figure describes the elements in the Repository.
There are different items that can be used to make different connections like Salesforce.
The workspace is the place where you can create Jobs and different Business Models. The Designer Tab is where jobs are created. The Code Tab helps visualize code and language errors.
Palette is where different types of components are available for creating jobs according to business needs. It is placed on the right side of the workspace.
4.) Configuration Tab
Configuration Tab is where components are configured according to business needs. Different types of component settings are available here.
The below section describes the view of each configuration tab.
a) Component: This view provides a detailed view of each component of the palette. While creating a job, we need to configure each component by filling its required fields.
b) Run Job: This view will show the current job execution and then log the details after the end of execution.
There is an example of inserting data from the CSV file to Salesforce org.
Insertion of Account records From CSV to Salesforce Org using Talend.
- Drop the following components: tFileInputDelimited, tSalesforceOutput, tMap.
- From the tSalesforceOutput Basic Setting, create a connection by providing Salesforce Org’s credentials and from Module Name select Account.
- From the tFileInputDelimited component, Basic Setting provides File name/Stream with the file location which you want to insert.
- From tMap, Do the mapping of the fields with Salesforce fields.
- Now, Run the Job.
- After completing the Job all Account records will be transferred to Salesforce Org.
To summarize, it is quite important to say that in today’s era, Talend is a potential standalone product that is continuously evolving and giving its competitors to some serious long-term goals to achieve.
Facing Challenges in Data Migration from one Salesforce Org to another? Worry not.
Find out how easy integration can be. Watch the video below to get started.
Watch Talend in action!