Introduction

Kettle is an acronym for "Kettle E.T.T.L. Environment." Kettle is designed to help you with your ETTL needs, which include the Extraction, Transformation, Transportation and Loading of data.Spoon is a graphical user interface that allows you to design transformations and jobs that can be run with the Kettle tools ---  Pan and Kitchen. Pan is a data transformation engine that performs a multitude of functions such as reading, manipulating, and writing data to and from various data sources. Kitchen is a program that  executes jobs designed by Spoon in XML or in a database repository. Jobs are usually scheduled in batch mode to be run automatically at regular intervals.

Note: For a complete description of Pan or Kitchen, see the Pan and Kitchen user guides.

Transformations and Jobs can describe themselves using an XML file or can be put in a Kettle database repository. Pan or Kitchen can then read the data to execute the steps described in the transformation or to run the job. In summary, Pentaho Data Integration makes data warehouses easier to build, update, and maintain.

Installing Spoon

Follow the instructions below to install Spoon:

1. Install the Sun Microsystems Java Runtime Environment version 1.4 or higher. You can download a JRE for free at http://www.javasoft.com/.
2. Unzip the zip-file: Kettle-3.0.zip in a directory of your choice.
3. Under Unix-like environments (Solaris, Linux, MacOS, for example), you must make the shell scripts executable. Execute these commands to make all shell scripts in the Kettle directory executable:

   cd Kettle
   chmod +x *.sh
   

Launching Spoon

The scripts below allow you to launch Spoon on different platforms:

spoon.bat: launches Spoon on the Windows platform.
spoon.sh: launches Spoon on a Unix-like platform such as Linux, Apple OSX, Solaris

A shortcut icon is provided in the Windows platform. Use "spoon.ico" to set the correct icon. Point the shortcut to the Spoon.bat file.