Kettle is a very popular ETL (Extract, Transformation and Load) tool which is open source and considered one of the best ETL in BI
with a very careful, good architecture and with a great number of popular database support,
it is our favorite choice to deploy various data integration and data treatment solutions.
itself is part of Pentaho BI applications suite. It is an independent open source ETL project initiated by Matt Casters
until acquired by Pentaho
Ever since, Kettle is also known as Pentaho Data Integration
). Matt himself continues to lead Kettle project development in Pentaho.
Kettle comprises of 4 applications :
- Spoon, graphical designer for designing job and transformation schemes. It is based on swing.
- Pan, script that is used to execute transformation scheme in .ktr xml file form or from a repository.
- Kitchen, script that is used to execute job scheme in .kjb xml file form or from a repository.
- Carte, atemporary web server which is used to execute job/transformation in cluster / parallel.
All the applications run from a particular batch / shell script.