Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 4 Next »

Unknown macro: {scrollbar}

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.

Supported Platforms

The Spoon GUI is supported on the following platforms:

  • Microsoft Windows: all platforms since Windows 95, including Vista
  • Linux GTK: on i386 and x86_64 processors, works best on Gnome
  • Apple's OSX: works both on PowerPC and Intel machines
  • Solaris: using a Motif interface (GTK optional)
  • AIX: using a Motif interface
  • HP-UX: using a Motif interface (GTK optional)
  • FreeBSD: preliminary support on i386, not yet on x86_64
  • No labels