Talend Open Studio is an ETL (Extract, Transform, and Load) tool. Talend Open Studio can perform jobs that range from datawarehouse feeding to database synchronization, as well as file format transformations. Its graphical interface is made with Eclipse RCP, and data related scripts are generated in Perl or Java. The application was designed to be extended with components written by users.


Features added for Perl include parsing XML data in a data flow, an Interbase connector, Oracle SCD in ELT mode, a creation table dedicated component, MySQL stored procedures, and denormalization on sorted rows. Features added for Java include country lookup from IP, a PostgresPlus connector, chronometers, and access to the ID that was last inserted by MySQL.

URL: Talend - first provider of open source data integration software