Skip to main content
Version Data Integration and Analytics
Hitachi Vantara Lumada and Pentaho Documentation

Configure KTR files for your environment

  1. Last updated
  2. Save as PDF
If you are not using Postgres and a default installation, you will need to configure a few of the sample KTR files in Spoon to use the SDR form.

Procedure

  1. Click File Open and navigate to find the SDR_data.ktr in this directory: pentaho/server/pentaho-server/pentaho-solutions/system/SDR/endpoints/kettle.

    1. Right-click on the Set Local Variables step to edit, and enter the URL for your Pentaho Server.

    2. Click OK.

  2. In the same transformation, right-click on the Call_ML_SDR job and select Open Referenced Object Job to open the _ML_SDR.job.

    1. Right-click to edit the Create Table step to point to your staging database.

    2. Click OK.

  3. Right-click to edit the Publish Model step and, if requested, enter your user id and password for the Pentaho Server.

    1. Click Test Connection.

    2. Click OK.

  4. Open the _ML_SDR_REFINERY.ktr.

    1. Right-click to edit the Out to Staging DB step.

    2. Select your staging database from the drop-down menu.

  5. Save all of these files and exit out of the PDI client.

  6. Restart the Pentaho Server.

Parent Topic
  • Work with data

    You can refine your Pentaho relational metadata and multidimensional Mondrian data models. You can also learn how to work with big data.