Talend Open Studio for Data Integration

2011_Talend_MDM_studio.png

Talend Open Studio for Data Integration is an Open Source Data Integration product developed by Talend and designed to combine, convert and update data in various locations across a business.

History

Talend Open Studio for Data Integration is distributed under GPLv2 and was launched in October 2006, under Talend Open Studio, its previous name. In January 2008, it had been downloaded over 1 million times. In January 2012, the product totaled 20 million downloads and over 3500 clients.

Talend also provides Talend Enterprise Data Integration, a commercial extension to Talend Open Studio for Data Integration with additional features, technical support and IP indemnification.

Product Description

Talend Open Studio for Data Integration operates as a code generator allowing data transformation scripts and underlying programs to be generated in Java. Its GUI is made of a metadata repository and a graphical designer. The metadata repository contains the definitions and configuration for each job - but not the actual data being transformed or moved. The information in the metadata repository is used by all of the components of Talend Open Studio for Data Integration.

The product is based on Eclipse RCP. Most of its contributors work for commercial open source vendor Talend.

Individual jobs are designed using graphical components, of which over 400 are available, for transformation, connectivity, or other operations. The jobs created can be executed from within the studio or as standalone scripts.

An organization might typically use Talend Open Studio for Data Integration for:

  • Synchronization or replication of databases
  • Right-time or batch exchanges of data
  • ETL (Extract Transform Load) for analytics
  • Data migration
  • Complex data transformation and loading
  • Data quality
  • Big Data

The Primary difference between Talend Open Studio for Data Integration and Talend Enterprise Data Integration is the later one has SVN build in Plug-in and Joblets. Using Talend Enterprise Data Integration, ETL/ELT jobs can have dynamic schema.

See also