In pentaho..How to pass a text file which contains all the definition of the connection parameters in the job?

Question

I am using jdbc connection and i am passing parameters with example ${sample_db_connection} and that parameters has been defined in server in a text file as sample_db_connection=localhost and i want to pass the text file in the job step so that whenever the job ran and it found this parameter ,automatically it will take the value defined in text file.

Please provide more details. Where you have created the program? How is it running? Sample code. etc etc. — Vishnu Prasad Kallummel, Dec 17 '14 at 09:30

score 3 · Accepted Answer · answered Dec 17 '14 at 13:15

You need to create a KTR file using "Property Input" as the input step and "Modified Java Script" Step to define the key value mapping. Check the image below:

enter image description here

Define your filename in the input step. In the JS step, you can use "setVariable" function to define the key-value mapping.

enter image description here

Once this job is executed at the start, pentaho will set the variables for all the connection.

Hope i have understood the question correctly and this is what you are looking for !! :)

Thank You Rishu for the help – Coding_line Dec 18 '14 at 06:48 — Coding_line, Dec 18 '14 at 06:48

In pentaho..How to pass a text file which contains all the definition of the connection parameters in the job?

1 Answers1

Linked