Kettle

The Kettle actions allow for the execution ETL operations within your action sequence using the Kettle open source ETL tool. Supported operations include the execution of Kettle ETL transformation and Kettle jobs. For further information on Kettle refer to http://kettle.pentaho.org.

Kettle Transformation

Executes a Kettle transformation and saves the resulting data into an output result set.

Component Name: KettleComponent

Inputs:

REQUIRED
Transformation Step - The step in the transformation from which to retrieve data.

OPTIONAL
Transformation Inputs __-- Allows for the inclusion of miscellaneous inputs to the Kettle transformation.
directory -- specified if loading from the kettle repository, used in conjunction with the input "transformation"

Outputs:

Output Name - The name of the result set containing the data from executing the Kettle transformation.

Resources:

REQUIRED
Transformation File -- The kettle transformation file that is be executed.

Kettle Job

Executes a Kettle Job.

Component Name: KettleComponent

Inputs:

OPTIONAL
Job Inputs -- Allows for the inclusion of miscellaneous inputs miscellaneous inputs to the Kettle job.
directory -- specified if loading from the kettle repository, used in conjunction with the input "job"

Resources:
REQUIRED
Job File - The Kettle job file to be executed.

Kettle Repository Configuration

To configure the kettle repository, modify the pentaho-solutions/system/kettle/settings.xml file:

repository.type -- files or rdbms
repository.name -- the name of the repository
repository.userid --the username to access the repository
repository.password -- the password to access the repository