KDnuggets : News : 2005 : n24 : item9 < PREVIOUS | NEXT >

Software

From: Matt Casters
Date: 14 Dec 2005
Subject: ETL: Kettle 2.2 open source

I'm pleased to be able to place 158.000 lines of Java code under the LGPL license in the form of a complete ETL environment called Kettle http://www.kettle.be/. Kettle has been more then 4 years in the making and in that period has grown to a very usable and complete ETL tool. It is available for download from the Kettle project homepage http://kettle.javaforge.com at Javaforge.

Kettle comes with 4 tools:

  • Spoon: GUI allowing you to design complex transformations
  • Pan: Batch executor of transformations (XML or in repository)
  • Chef: GUI allowing you to design complex jobs
  • Kitchen: Batch executor of jobs (XML or in repository)
Note: Spoon & Chef use SWT from Eclipse to provide a native GUI on Windows, Linux, OSX and Motif. However, no dependencies exist between the GUIs and the runtime code.

Interesting things to know about Kettle:

  • Transformations and jobs are made up of 100% meta data. This meta-data is parsed by Kettle and executed. No code-generation is involved.
  • At the moment there are around 35 different step types available to create transformations and about 10 job entry types.
  • Almost every popular database is supported including MySQL, PostgreSQL, MS Access, SQL Server, Oracle, DB2, Sybase, Informix, MaxDB, Firebird, AS/400, Ingres, Caché, ...
For additional information and screen shots, visit http://www.kettle.be/en/screenshots.htm

This message serves as an invitation to all Java and Data Warehouse developers to come and help make Kettle even better. Let me know what you all think and please join the Kettle development team!

I hope you all have as much fun using Kettle as I had writing it.

Matt Casters
Brussels/Belgium, december 2005
matt.casters@kettle.be


KDnuggets : News : 2005 : n24 : item9 < PREVIOUS | NEXT >

Copyright © 2005 KDnuggets.   Subscribe to KDnuggets News!