Database: LABS GALLERY: Talend Open Studio Eases ETL Chores

LABS GALLERY: Talend Open Studio Eases ETL Chores

A Familiar Interface

Since Talend Open Studio is based on Eclipse, I found its interface familiar from the first time I fired it up.

File Metadata

With the product's New Delimited File wizard, I made short work of mydata-source-tweaking chores.

Job Design Canvas

I dragged my data source and target components onto the product's jobdesign canvas.

Job Statistics

While my jobs ran, I could watch as that product's rows, rows-per-second and elapsed-time indicators marked the flow of my test data.

Database Connections

I could choose from 31 different types of database connections, which included a full range of database products as well as generic ODBC and JDBC connections.

Database Settings

I modified a few settings for the database output element, indicating, for instance, that TOS should create a new table to receive the data.

Data in Place

After importing my campaign data from my CSV files to MySQL, I confirmed that the records had arrived safely.

SQL Builder

I used the product's SQL Builder to pick out subsets of my data for further processing or migration.

tMap Element

The product's tMap component allowed me to map particular columns from my database to a SugarCRM Web service, while transforming certain columns en route.

LABS GALLERY: Talend Open Studio Eases ETL Chores - Page 11