Data Integration - Talend ETL Tool Basics

Introduction

Talend provides many tools for a software solution. They are application integration, data management, data preparation, data quality, data integration, and big data. In which data integration and Big Data is most widely using the tool. Talend is the ETL tool with all the plugins to integrate with Big Data ecosystem. Talend offers Open Studio, which is an open-source free tool. This article helps you to learn about data integration and Big Data.

Talend Open Studio (ETL Tool)

Requirements

Operating System

Talend is available for the below operating systems

Microsoft Windows
Ubuntu
MacOS

Memory Requirement

RAM - Minimum 4 GB. Recommended 8 GB
Disk - 20 GB+ (Based on the number of projects created we need more space)

Talend is an Eclipse based developer tool, so java setup(JRE/JDK) is needed for studio.

Benefits

It is used to combine data into a single system.
It improves the collaboration between teams to access the data.
If integrate the data properly, then it cuts down significantly on the time it takes to prepare and analyze that data.
Data Integration automation is used to synchronize the data and generate the report easily, effectively with less consuming time.
Integrate the data from several sources (integrated into a centralized system) are helping to identify the quality issues accurately, So improves the better data quality.

How to download the Talend Open Studio

Follow the below steps to download the Talend Open Studio.

Step 1

Go to https://www.talend.com/products/talend-open-studio/.

Step 2

Click the Download button.

Step 3

Give necessary details in "Get Started for Free" section and press the download now button.

Step 4

You will get the download link in your mail and download the Talend Open Studio from the link.

Why Talend Open Studio

In Talend we are extracting the data from the data sources such as RDBMS, Files, Saas Big Data, Amazon, Salesforce, and Apps like SAP, CRM Dropbox and more, etc., then transforming the data as we required and can analyze to get a result, load the data in the data source as a form we needed, this process is called Data Integration.
In Talend we can build the data processing job by dragging and dropping the components and connect them for processing the data as we required. There are more than 1000 components and multiple build-in connectors.
Talend Open Studio provides 2 types of view mode.
- Design tab - All the components and connectors are shown like graphical view of the job.
- Code view tab - Jobs are shown in java code.

Design Tab

Data Integration - Talend ETL Tool Basics

Code Tab

Data Integration - Talend ETL Tool Basics

Projects

In this section let us understand how to create, delete, export, and develop the project in Talend.

Creating a Projects

Open Talend Open Studio. Enter the new project name in create a new project and click the create button.

Import a Demo Project

Open Talend Open Studio. Select Import a demo project option and click Select.

Select Data Integration Demos and click Finish button.

Enter the Project name and description. Click Finish.

You can see the imported project under existing projects list.

Import an existing Talend project

Open the Talend Studio. Select Import an existing project option and click on Select.

Enter Project Name and select the “Select root directory” option.

Browse your existing Talend project location directory and click Finish.

The imported existing project is shown under existing project.

Delete the Project

For deleting the project, select which project we plan to delete. In the below example, we going to delete Sathya_ExistingDemo project from Talend Open Studio.