Configure KTR files for your environment
Procedure
Click SDR_data.ktr in this directory: pentaho/server/pentaho-server/pentaho-solutions/system/SDR/endpoints/kettle.
and navigate to find theRight-click on the Set Local Variables step to edit, and enter the URL for your Pentaho Server.
Click OK.
In the same transformation, right-click on the Call_ML_SDR job and select to open the _ML_SDR.job.
Right-click to edit the Create Table step to point to your staging database.
Click OK.
Right-click to edit the Publish Model step and, if requested, enter your user id and password for the Pentaho Server.
Click Test Connection.
Click OK.
Open the _ML_SDR_REFINERY.ktr.
Right-click to edit the Out to Staging DB step.
Select your staging database from the drop-down menu.
Save all of these files and exit out of the PDI client.
Restart the Pentaho Server.