Talend Open Studio is an ETL (Extract, Transform,and Load) tool. Talend Open Studio can performjobs that range from datawarehouse feeding todatabase synchronization, as well as file formattransformations. Its graphical interface is madewith Eclipse RCP, and data related scripts aregenerated in Perl or Java. The application wasdesigned to be extended with components written byusers.License: GNU General Public License (GPL)Changes:
Dynamic replacement list, pivot transformation,system command output as data flow input, a joincomponent, bulk updates with MySQL/PostgreSQL,socket reader/writer, and MySQL-specific extendedinserts were added for Java and Perl codegeneration. PostgreSQL bulk load was added forPerl code generation. AS400/MSSQL connectionsharing, a "wait for SQL data" trigger, appendmode and multi-sheets for Excel, Groovy script,SFTP, SCD for PostgreSQL were added for Java codegeneration. Context management was improved. A"Stats & Logs" dedicated view was added. A wizardfor Web services was added.

More...