Ubuntu 部署Kettle作业、转换
描述:
我的文件是从windows编辑好,放在Ubuntu上运行。这里需要在Ubuntu上修改部分文件信息。(建议使用windows编辑作业、转换时尽量全使用英文,以防服务器不支持中文)
提前准备好所需作业、转换
0428_157-v1.kjb
db_change_v2-0427.ktr
部署Kettle至Ubuntu服务器上比较简单
- 拷贝pdi-ce-8.3.0.0-371.zip至服务器上解压,或者直接复制data-integration文件夹
- 将所需作业、转换放置服务器指定目录(自定义)
修改kjb部分文件
-
0428_157-v1.kjb 修改引用转换路径为Ubuntu下地址(如下:截取部分)
自定义目录
<name>转换</name> <description/> <type>TRANS</type> <attributes/> <specification_method>filename</specification_method> <trans_object_id/> <filename>/kettle/jobkk/db_change_v2-0427.ktr</filename> <transname/> <arg_from_previous>N</arg_from_previous>
-
编写启动Shell脚本
新建test.sh脚本
chmod +x ./test.sh #使脚本具有执行权限
./test.sh #执行脚本内容如下
#!bin/bash export JAVA_HOME=//usr/lib/jvm/java-8-openjdk-amd64 export JRE_HOME=${JAVA_HOME}/jre export CLASSPATH=.:${JAVA_HOME}/lib:${JRE_HOME}/lib export PATH=${JAVA_HOME}/bin:$PATH //home/cy2c/new_dms/kettle/data-integration/kitchen.sh -file=/home/cy2c/new_dms/kettle/jobkk/0428_157-v1.kjb
- 启动ktr
#!bin/bash export JAVA_HOME=//usr/lib/jvm/java-8-openjdk-amd64 export JRE_HOME=${JAVA_HOME}/jre export CLASSPATH=.:${JAVA_HOME}/lib:${JRE_HOME}/lib export PATH=${JAVA_HOME}/bin:$PATH //home/cy2c/new_dms/kettle/data-integration/pan.sh -file=/home/cy2c/new_dms/kettle/jobkk/db_change_v2-0427.ktr
-
启动Shell脚本
使用nohup后台启动
nohup ./test.sh &
nohup.log日志记录部分
#######################################################################
WARNING: no libwebkitgtk-1.0 detected, some features will be unavailable
Consider installing the package with apt-get or yum.
e.g. 'sudo apt-get install libwebkitgtk-1.0-0'
#######################################################################
OpenJDK 64-Bit Server VM warning: ignoring option MaxPermSize=256m; support was removed in 8.0
09:27:19,043 INFO [KarafBoot] Checking to see if org.pentaho.clean.karaf.cache is enabled
09:27:19,165 INFO [KarafInstance]
***Karaf Instance Number: 1 at /home/kettle/data-integration/ ***
*** ./system/karaf/caches/kitchen/data-1 ***
*** FastBin Provider Port:52901 ***
*** Karaf Port:8802 ***
*** OSGI Service Port:9051 ***
2020/04/28 09:27:35 - cy2c_0428_157-v1 - Start of job execution
2020/04/28 09:27:35 - Carte - Installing timer to purge stale objects after 1440 minutes.
2020/04/28 09:27:35 - 0428_157-v1 - 0428_157-v1
Killed
#######################################################################
WARNING: no libwebkitgtk-1.0 detected, some features will be unavailable
Consider installing the package with apt-get or yum.
e.g. 'sudo apt-get install libwebkitgtk-1.0-0'
#######################################################################
参考连接
https://www.cnblogs.com/kxm87/p/9493121.html