What's New in v2.0

Java Language Generation

Java Language Generation is the new core feature added to Milestone 2 of Talend Open Studio v2.0 release. A number of Perl connectors now have their Java counterparts. Try them out and give us your feedback! More...

 

ELT components

The introduction of the ELT (Extract, Load & Transform) architecture in Talend Open Studio allows all data transformations to take place where they can run the fastest, and use the lowest amounts of resources. ELT mappings and transformations are executed inside the database engine, through the generation of native SQL code, optimized for each database technology. For each job and part thereof, it is possible to specify whether to use an ETL or ELT approach. Talend Open Studio allows combining both approaches, thus optimizing data integration processes.

 

New components and connectors

New specific MySql and Oracle components

In Talend Open Studio 2.0.0, tDBInput, tDBOutput, tDBSQLRow are complemented with tMysqlInput; tMysqlOutput, tMysqlRow, tOracleInput, tOracleOutput, tOracleRow, tDB2Input, tDB2Output, tDB2Row, tPostgresqlInput, tPostgresqlOutput, tPostgresqlRow, tSybaseInput, tSybaseOutput, tSybaseRow.

The aim being to broaden the offering in order to cover all types of specific connections and maintain the tDBInput component as the generic one.

In the  tMysqlOutput and on tOracleRow properties, you will be able to use database "intrinsic" features including the "additional columns" function, see [Bugtracker] feature 516 for details.

 

Mysql "Bulk" components

tMysqlOutputBulkExec executes the MySQL "LOAD DATA INFILE" command. tMysqlOutputBulk writes the input flow rows in a temporary file and then runs tMysqlOutputBulkExec.

Warning: In TOS 2.0, tMysqlOutputBulk is renamed to tMysqlOutputBulkExec and tMysqlOutputBulkExec is renamed to tMysqlBulkExec.

 

tFileFetch component

Fetch any file pointed to by an ftp, http, filepath, or rsync uri, using various means.

 

tRowGenerator2 component

Thanks to its convenient graphical interface, the tRowGeneratorAdvanced component makes it easy to set up numerous sets of data for testing purpose. This component is likely to be further enhanced in the next few months with the aim to eventually replace the current tRowGenerator component.

 

Technical components: tFor & tSleep

tFor : to implement a loop		tSleep: to set the break timer

 

tAggregateRow component enhancements

Based on a Group By condition, this component now carries out the operations first and last.

 

External components

You will be able to specify a folder to store your own components (user defined or downloaded from our site).

 

SQL Builder's convenient graphical editor helps building up queries

The SQL builder provides a graphical interface for creating and running SQL statements. Statements that are generated by the SQL builder can be stored in the Repository or in a file. The graphical editor helps you designing your SQL Query: add or remove a table, assign an alias to a table, select or opt out columns of the table. define joins between tables. The left pane provides a tool comparing your metadata-stored schema with the database structure. The Diff icons point out that the table contains differences or gaps. The red highlight shows that the content of the column contains differences or that the column is missing from the actual database table. The blue highlight shows that the column is missing from the table stored in the repository metadata.

 

Other added features

Double click on the tRunJob to open the child job

When you double click on a tRunJob component, the child job is automatically opened.

The Generate Code button will generate the child job associated perl code without you being required to run the child job.

 

Export job

You can now export all the jobs of one project to an archive file in one go. The Perl code is now automatically generated, no need to run the job prior to the export. This Export job feature gathers all necessary resources along with the job exported. For instance, it preserves all bound jobs used through a tRunJob. In Window/Preferences/Talend, you can define a secondary perl interpreter in case you want to run your exported job on different OS. You can export the Sources Files with your generated Perl code.

 

Other new features

• [Bugtracker] feature 428: Create schemas using SYNONYMS and VIEW in Oracle.

For more information, please visit [Bugtracker] Change Log