Database: LABS GALLERY: Talend Open Studio Eases ETL Chores

 
 
By Jason Brooks  |  Posted 2009-09-29
 
 
 

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.

A Familiar Interface

File Metadata

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

File Metadata

Job Design Canvas

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

Job Design 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.

Job Statistics

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 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.

Database Settings

Data in Place

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

Data in Place

SQL Builder

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

SQL Builder

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.

tMap Element

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

 

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

Rocket Fuel