run pentaho kettle from cmd. how to send the source files as a param?

Question

I'm using Pentaho Kettle 4.0.1. Now I run a transformation from Java by providing a transformation file (XML type not KTR) and give some other XML files (in a src folder) that are meant to be inserted or updated in DB.

What I want is to do these things from a bat or shell file and not from Java. I'm not completely familiarized with kettle... I've seen some example regarding running a kettle transformation from a .bat file but there only is a file parameter that receives the transformation file (ktr). How do I pass as a param to pan.bat/pan.sh the src dir where my xml data files are (the data that is about to be inserted in DB)?

score 1 · Answer 1 · answered Jun 14 '12 at 14:59

1

I think you need to read this: http://wiki.pentaho.com/display/EAI/Pan+User+Documentation

answered Jun 14 '12 at 14:59

Codek

5,114
3
24
38

score 1 · Answer 2 · answered Jan 08 '13 at 12:15

1

You can use the following syntax for sh file

sh pan.sh -file:Transformation1.ktr -param:parameter1=myname -param:parameter2=30

answered Jan 08 '13 at 12:15

Avinash

93
2
10

score 0 · Answer 3 · answered Jun 14 '12 at 14:23

0

You can use transformations named parameters to capture the xml files path

Here you can see an example,

This is other way

answered Jun 14 '12 at 14:23

Carlos Castellanos

2,358
4
25
43

I don't understand ... I don't see anywhere a dir/files param. – spauny Jun 14 '12 at 14:51
How you think you could use (or are you using) this paramater in your transformation or steps?? – Carlos Castellanos Jun 14 '12 at 15:05

run pentaho kettle from cmd. how to send the source files as a param?

3 Answers3