使用命令行来执行Pentaho Data integration job

cd "C:\Program Files (x86)\Kettle"
call kitchen.bat -file:"C:\Elekta Projects\CE_Activities\MAIN.kjb" -level:Minimal

亲测上面这句可行

如果不用call的话, 会报一个错:

ERROR [BlueprintContainerImpl] Unable to start blueprint container for bundle pdi-dataservice-server-plugin due to unresolved dependencies [(objectClass=org.pentaho.metaverse.api.ILineageClient)]

 

kitchen使用来运行job的

pan是用来运行transform的

 

Linux 下给一个例子:

tname=`date +%Y-%m-%dT%H%M%S.log`
bizdate=`date +%Y%m%d`
/opt/data-integration/kitchen.sh -file '/home/user/Weather Daily Transform.kjb' -level:Minimal -param:enddate='${bizdate}' -param:startdate='${bizdate}' -param:csvpath='/data/store/shell/dw_03_daily_city_weather/tmp/' -param:csvhdfspath='/user/data/' > /home/user/${tname} 2>&1