K.E.T.T.L.E (Kettle ETTL Environment) is a meta-data driven ETTL tool. (ETTL: Extraction, Transformation, Transportation & Loading)
This means that no code has to be written to perform complex data transformations.
Environment means that it is possible to create plugins to do custom
... [More] transformations or access proprietary data sources.
Kettle is released under the Apache License v2.0 since version 4.3.0.
Kettle moved to GitHub at the beginning of 2014: http://github.com/pentaho/pentaho-kettle
This move could lead to strange results in the Ohloh metrics. [Less]
Apatar is an open source data integration application to help join your desktop data with the web. Apatar effectively integrates data and applications, and provides visual job designer and mapping, joins, filtering, data cleansing and validation capabilities. Connectors include MySQL, PostgreSQL
... [More], Oracle, MS SQL, Sybase, FTP, HTTP (POST and GET), SalesForce.Com, SugarCRM, Compiere ERP, Goldmine CRM, XML (local and web-based), flat files (CSV, TXT), Webdav, Buzzsaw, LDAP, Amazon, RSS and even Flickr; more connectors are under way. [Less]
Jitterbit is an open source client and server designed to give end users a quick and easy way to design, configure, test, and deploy integration solutions. Organizations can use Jitterbit to connect data from ERP and CRM applications, data warehouses, online marketplaces, and much more. Jitterbit
... [More] supports Web Services, XML Files, HTTP/S, FTP, ODBC, Flat and Hierarchic file structures and file shares. To see a full list of protocol and document support please read our datasheet. [Less]
An extension package to Pentaho Data Integration (a.k.a. Kettle), providing plug-ins.
Steps/job entries can be downloaded independently and each comes with source code in the .zip file. All are licensed as LGPL or GPL.
Steps currently available: Asciify, TrimCut, Date Generator
ETL Framework is a standalone Extract Transform Load engine written in Java. It includes executables for all major platforms and can be easily integrated into other applications.
* embeddable, open source and free
* fast and scalable
* uses target database features to
... [More] do transformations and loads
* manual and automatic data mapping
* data streaming
* bulk data loads
* data transformations
* Java 1.6 and up
* At least 4 MB of RAM [Less]