Skip to main content
Version Pentaho
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 .KTRs in Spoon in order to use the SDR form.

  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. Right-click on the Set Local Variables step to edit, and enter the URL for your Pentaho Server. Click OK.
  1. In the same transformation, right-click on the Call_ML_SDR Job and select Open Referenced Object > Job to open the _ML_SDR.job. Right-click to edit the Create Table step to point to your staging database. Click OK.
  1. Next, right-click to edit the Publish Model step and, if requested, enter your user id and password for the Pentaho Server. Click Test Connection, then click OK.
  2. Open the _ML_SDR_REFINERY.ktr. Right-click to edit the Out to Staging DB step and select your staging database from the drop-down menu.
  1. Save all of these files and exit out of Spoon.
  2. Restart the Pentaho Server.