LABS GALLERY: Talend Open Studio Eases ETL Chores

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

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

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

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.

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.

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

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

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

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.