Kettle
K.E.T.T.L.E (Kettle ETTL Environment) is a meta- data driven ETL (Extraction, Transformation, Transportation, and Loading) tool. This means that no code has to be written to perform complex data transformations. It is possible to create plugins to do custom transformations or access proprietary data sources. Kettle supports most databases on the market, and has native support for slowly changing dimensions on most database platforms.
| Tags | Database API Front-Ends Information Management Metadata/Semantic Models Software Development Libraries Java Libraries |
|---|---|
| Licenses | LGPL |
| Operating Systems | Mac OS X Windows Windows Unix |
| Implementation | Java |
Recent releases
- 30 Sep 2008 20:37
Changes: A number of changes around ease of use and a serious expansion of the possibilities in general.
- 12 Dec 2007 14:21
Changes: Around 80 bugfixes and other small improvements. An Italian translation has been added. A few samples have been added.
- 15 Nov 2007 23:09
Changes: Data and metadata were separated to reduce object creation and improve performance. Faster flat file support was added, including parallel reading and lazy conversion. A new look and feel was added and usability was improved. Seven new Transformation Step types were added. Seven new Job Entry types were added.
- 24 Oct 2007 06:53
Changes: This release mostly contains bugfixes to 2.5.1, bugfixes backported from the unstable 3.0 tree, and a few new things. A new "Get files rows count" step was added. New job entries were added: "Unzip files", "Delete files", "Copy files", "FTP put file", "Validate "DTD", and "Validate XSD".
- 04 May 2007 10:59
Changes: Support for advanced error handling. Support for Apache commons VFS file handling. Support for the Apache Derby database. Dimension key caching. Greatly improved job handling, with 14 new job entries to choose from: Create file, Delete file, Wait for file, Put file with SFTP, File compare, MySQL Bulk load and export, Wait, Zip files, XSLT, Abort job, Get mail from POP server, and Ping a host. Hundreds of bugs were fixed. A 24-page changelog is available.
- All comments
Recent commentsSupported databases
This is the list of supported database on Kettle:
MySQL
Oracle
AS/400
MS Access
MS SQL Server
IBM DB2
PostgreSQL
Intersystems Caché
Informix
Sybase
Gupta SQL Base
dBase III, IV or 5
Firebird SQL
MaxDB (SAP DB)
Hypersonic
Generic (using ODBC on Windows)
CA Ingress
SAP R/3 System (ProSAPCONN plugin)
Regards,
Matt