Talend Open Studio for Data Integration
Talend MDM studio
|License||GNU General Public License 2.0|
|Website||Download Talend Open Studio for Data Integration|
|This article reads like a news release, or is otherwise written in an overly promotional tone. (July 2011)|
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.
Talend Open Studio for Data Integration is distributed under LGPL 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.
Talend Open Studio for Data Integration operates as a code generator, producing data-transformation scripts and underlying programs in Java. Its GUI gives access to a metadata repository and to a graphical designer. The metadata repository contains the definitions and configuration for each job - but not the actual data being transformed or moved. All of the components of Talend Open Studio for Data Integration use the information in the metadata repository.
Users design individual jobs using graphical components, from a set of over 400, 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 exercises
- big data
Talend Open Studio for Data Integration primarily differs from Talend Enterprise Data Integration in that the Enterprise version has a Subversion plug-in built in, as well as support for joblets. Using Talend Enterprise Data Integration, ETL and ELT jobs can have a dynamic schema.