Pentaho

 View Only

 How to pass parameters to kjb file when running using Kitchen.bat

  • Pentaho
  • Pentaho
maneesh m's profile image
maneesh m posted 04-04-2019 21:22

Hi,

I am running a job using kitchen.bat from powershell. I am using PDI 8.2.

I have a few parameters in my job properties.

What is the syntax to pass the parameters to the job. Here is what I have:

C:\pdi-ce-8.2.0.0-342\data-integration\kitchen.bat

/file="C:\ER\VToOETL\vToD.kjb"

"/param=VDataFilePath=C:\data\pentaho\import\VData.csv"

"/param=db_hostname=xx.xxx.xx.xx"

"/param=db_port=1234"

/log="C:\ER\VToDETL\Logs\vToD.log"

/level=basic

Please suggest the correct syntax.


#Pentaho
Ravikumar Kamma's profile image
Ravikumar Kamma

define your parameters in kettle.properties file and read that in your job.

M Lentink's profile image
M Lentink

Have you tried the following syntax: -param:"db_port=1234"?

maneesh m's profile image
maneesh m

I am using forward slash for other properties like file, log. I assumed I would have to use the same forward slash for param also.

maneesh m's profile image
maneesh m

This syntax worked for me with running the bat file from Powershell script, running on a windows machine.

'/param="VDFilePath=C:\data\pentaho\import\VData.csv"'