Using the Kettle ETL Tool

Check which version of Kettle you require from either the Deployment Guide or your Genesys consultant. Kettle ETL logic is defined by two types of scripts:

• Jobs
• Transformations

All the customizations supported in iWD Datamart are done in transformations.

The main idea of transformation is as the name implies - transformation of data. Data in this case is considered any type of two dimensional recordset. Each step in transformation either somehow modifies the existing recordset, replaces it with another recordset (usually using current recordset as parameters) or output current recordset to a database table or other kind of data storages (such as .CSV files).

1. Download the Kettle ETL Tool from the Sourceforge website at sourceforge.net/projects/pentaho/files/Data Integration/<version>/download.
2. Unzip the package to C:\iwd\kettle<version> folder.
3. Start Kettle ETL visual designer. The Kettle designer is called Spoon. Go to C:\iwd\kettle<version> folder and start the spoon.bat batch file.
4. Select No repository to continue.
5. Open a transformation. The Kettle transformations script have .ktr extension.

For more information see Customizing iWD.