Projects / Kettle

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
Licenses
Operating Systems
Implementation

Recent releases

  •  30 Sep 2008 20:37

    Release Notes: A number of changes around ease of use and a serious expansion of the possibilities in general.

    •  12 Dec 2007 22:21

      Release Notes: Around 80 bugfixes and other small improvements. An Italian translation has been added. A few samples have been added.

      •  16 Nov 2007 07:09

        Release Notes: 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 13:53

          Release Notes: 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 17:59

            Release Notes: 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.

            Recent comments

            19 Dec 2005 06:59 MattCasters

            Supported 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

            Screenshot

            Project Spotlight

            OpenStack4j

            A Fluent OpenStack client API for Java.

            Screenshot

            Project Spotlight

            TurnKey TWiki Appliance

            A TWiki appliance that is easy to use and lightweight.