CODEWITHSUNDEEP
databasepentahobusiness-intelligencekettlepdi
Estrobelai
Estrobelai

Reputation: 309

Pentaho "kettle.properties" file - which one am I using?

When one runs a job from the server (by selecting server as below), does PDI pick up the "kettle.properties" file from the server or from the local computer they are running the job from? What about the Pentaho User Console portal - where is the file being picked up from when one runs the jobs from there? Is there anyway to tell PDI which "kettle.properties" file to use?

enter image description here

Upvotes: 1

Views: 10646

Answers (1)

naian
naian

Reputation: 136

AFAIK, there is no way to pick a kettle.properties file location from within the Spoon interface right before executing a job/transformation.

The kettle.properties file used is always linked to the instance of Kettle that executes the job/transformation.

  • When running a job locally with the PDI Client (Spoon), the kettle.properties file used is the one contained in the directory pointed to by the -DKETTLE_HOME JVM option (defined when running the spoon.sh or Spoon.bat launch scripts).
  • When running a job/transformation on the Pentaho Server (by either scheduling it explicitly on the Server from Spoon, or by running it from the PUC), the kettle.properties file used is the one located in the directory pointed to by the -DKETTLE_HOME JVM option defined when running the start-pentaho.sh or the start-pentaho.bat launch scripts.

Both the PDI Client and the Pentaho Server set the default location of KETTLE_HOME to ~/.kettle.

If you want to use a kettle.properties file located somewhere else, you will have to define the location of the Kettle Home directory yourself before starting the PDI Client or the Pentaho Server:

  • By setting an environment variable called KETTLE_HOME. It has to be set before running the Spoon launching scripts or the Pentaho Server launching scripts
  • For the Pentaho Server, you can also add the option -DKETTLE_HOME to CATALINA_OPTS (if the Pentaho Server uses Tomcat) by editing the launch script.

You can find this information on the Customize the Pentaho Server page.

Upvotes: 3

Related Questions