Description

Executes a Pentaho Data Integration Job. Please read the Kettle section within the Actions and Components Reference for additional information on configuring Kettle Jobs and Transforms.

Image Added

Inputs and Outputs

Database Connection Type - Specifies the type of connection to be used to connect to the database.

• JDBC - Connect using a standard JDBC connection. The following inputs must also be provided.
  • JDBC Drive - Name of the JDBC driver class to use when connecting to the database.
  • Database URL - The database connection URL.
  • User Name - The username to use when connecting to the database.
  • Password - The password to use when connecting to the database.
  • Role - The Mondrian role to use with the connection.
• JNDI - Connect using the specified JNDI name. The following inputs must be provided:
  • JNDI Name - The JNDI data source name.
  • Role - The Mondrian role to use with the connection.

Mondrian Schema File - The location of the Mondrian schema file. This is only needed when using a JDBC or JNDI connection.

Connection Name - The name of the resulting output database connection. Following OLAP Query actions can use this shared connectionName - The name of the component
Use Kettle Repository - If selected, use the configured Kettle Repository. For documentation on configuring the Kettle Repository, see the Kettle section within the Actions and Components Reference

• Directory - If using the Kettle Repository, the directory within the repository containing the job.

Job File - The location of the PDI Job File to execute
Job Inputs - Define inputs that get passed into the PDI Job.