kettle使用记录

1.linux系统抽取数据

export KETTLE_HOME=/home/oracle/Kettle/pdi-ce-6.1.0.1-196/data-integration
export JAVA_HOME=/home/oracle/Kettle/jdk1.8.0_201
export PATH=$JAVA_HOME/bin:$PATH
export CLASSPATH=.:$JAVA_HOME/lib/dt.jar:$JAVA_HOME/lib/tools.jar:$CLASSPATH
/home/oracle/Kettle/pdi-ce-6.1.0.1-196/data-integration/pan.sh -file=/home/oracle/Kettle/kettle_rep/XX/XX.ktr >/home/oracle/Kettle/kettle_rep/XX/XX_`date +%Y%m%d_%H%S`.LOG