| Free LGPL ETL tool [message #5775] |
Sat, 03 December 2005 19:07 |
Eclipse User |
|
|
|
Originally posted by: matt.ibridge.be
A free Kettle for everyone!
Up to now, the options for creating Managment Information Systems (MIS)
using open source tools where limited. Although there are numerous
possibilities apearing on the reporting side, the absence of a complete
open-source ETL tool (Extraction, Transformation & Loading) has been causing
problems for those organisations with little money. That is because
traditionally, full-featured ETL tools from the Big vendors also cost Big
money.
Today 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.
Kettle has been more then 4 years in the making and in that period has grown
to a very usable and complete ETL tool.
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 uses 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
|
|
|
Powered by
FUDForum. Page generated in 0.02498 seconds
] 
Search
Help
Register
Login
Home
