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.
License: GNU General Public License (GPL)
Changes:
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.