Creating transforms and database connections

You can create transforms and database connections for use between Pentaho Spoon and TRIRIGA®

Procedure

  1. Open the Spoon tool by running the Spoon.bat file in the pdi-ce-5.4.0.1-130/data-integration/ directory. Choose to run without a repository.
  2. To create a new transform, right-click Transformations and select New.
  3. In View mode, create your database connection. Right-click database connections within Transformations and select New.
  4. The Custom workflow task replaces the TRIRIGA connection with the application server JNDI settings. Configure the database connection as follows:
    • Connection Name:TRIRIGA
    • Connection Type:Oracle
    • Access:JNDI
    • Settings:JNDI Name:LocalJNDI
  5. Select Test to make sure that the connection is set up correctly.
  6. Save the database connection details.
  7. Be sure to save the transform as an XML file not in the repository. The extension for the Kettle transformation is .ktr. The default for Kettle transformation saves the file as .ktr.