1.Getting Started-Installation and Configuration of Talend Open Studio for Data Integrator

Introduction to Talend Open Studio

Talend Open studio for Data Integration is one of the open source ETL tools offered by Talend.

In this post, I will be covering the pre-requisites that are required to start learning the fundamental concepts of Talend Data Integrator and also how to install the necessary software to continue with exercises.As Oracle 12c Database is used as source system or target system in the upcoming handson sessions, I have also covered the installation and configuration of this as well.

Basic SQL concepts are required to understand Data Integration. Also, an oracle account is needed to install the required oracle software.

I have listed below the pre-requisite software that are used in the demos to explain the concepts on Windows 64 bit machine. So all the installation that I will mention below refers to only to this configuration.

Pre-requisite Software Installation

1.Java Run time Environment

This can be downloaded from Oracle. Download the below file, extract the content, and run the setup file. If you already have the Java run time Environment, then you can ignore this step.

Pre-requisite Software Installation for Talend Open Studio
Pre-requisite Software Installation for Talend Open Studio

2.Oracle 12c Database

Oracle 12c database can be installed directly from here. Follow the instructions from here and set up the database

3.Oracle SQL Developer

Oracle SQL Developer can be installed from here.Extract the file and run the setup file.

Pre-requisite Software Installation for Talend Open Studio - Oracle SQL Installation
Pre-requisite Software Installation for Talend Open Studio - Oracle SQL Installation

4.Talend Data Integrator

Go to the link here,check the Free Products and download the Open studio for Data Integration.

Software Installation of Talend Open Studio

Extract the file and click on the set up file and install the tool. There is no need to login to the Talend website also.

Software Installation of Talend Open Studio

This completes the installations of all the software required to learn the Talend Data Integrator.

Describe the various products offered by Talend and also describe the purpose of Talend data integrator. Installation of Talend Data integrator

Post Installation – Configuration of Training DB in Oracle 12c Database:

Oracle 12c

We need to set up the connections for Container and Pluggable Databases as shown below.

Container Database:

Post Installation - Configuration of Training DB in Oracle 12c Database:

Pluggable Database:

Post Installation - Configuration of Training DB in Oracle 12c Database:

Login to SQL developer , and create a database that can be used for learning Talend Data Studio Integration.

create user DBTRAINING identified by password;

grant create session,alter session,alter user,create database link,create materialized view,create procedure,create public synonym,create table,create view,create type, create any index,unlimited tablespace to DBTRAINING;
Post Installation - Configuration of Training DB in Oracle 12c Database:

This ends the complete setup and configuration of the software. Let’s get started in the upcoming fundas section to learn Talend Data Integration.

Leave a Comment