Unveil Kettle

    Kettle is an open source ETL tools, it is a part of Pentaho BI Suite.
1. Kettle jar main package:
    be/ibridge/kettle/chef            Contains the classes for the Chef Job editor
    be/ibridge/kettle/core            contains all the base classes that are used in the complete project
                                                            such as Value, Row, Database and many, many more
    be/ibridge/kettle/job            contains the different elements that make up a Job
    be/ibridge/kettle/kitchen        contains the Kitchen job batch executor
    be/ibridge/kettle/pan            contains Pan, the batch transformation executor
    be/ibridge/kettle/plate            contains Plate, the Kettle reporting editor
    be/ibridge/kettle/repository    contains the required classes to handle the Kettle repository
    be/ibridge/kettle/spoon            contains the classes needed by Spoon
    be/ibridge/kettle/test                contains test-classes and programs
    be/ibridge/kettle/trans            contains the classes needed to define and execute transformations
2. Kettle components:
    Kettle include four components:
    a) spoon:   transformation designer      GUI
    b) pan:         transformation executor      Command line
    c) chef:      job designer                              GUI
    d) kitchen:   job executor                           Command line
3. All jobs and tranformations are stored in XML files or database repository. Actually, Kettle is very similar to MS ETL tools----DTS