本文简要整理一下Kettle学习过程中的相关文档
官网
https://community.hitachivantara.com/docs/DOC-1009855-data-integration-kettle
https://github.com/pentaho/pentaho-kettle
下载
https://sourceforge.net/projects/pentaho/files/Data%20Integration/
JDK10下启动报错，需切至低版本JDK
官方文档
https://wiki.pentaho.com/display/EAI/Pan+User+Documentation
中文教程
https://www.jianshu.com/p/4d8171150faf
https://juejin.im/entry/590c215ca22b9d0058e8e56b
https://ask.hellobi.com/blog/yuguiyang1990/category/1532
ktr执行
./pan.sh -file=”./scripts/APP_CODE.ktr”
./pan.sh -file=”./scripts/APP_ZHIJI_CORRESPONDING.ktr”
./pan.sh -file=”./scripts/USER_BASIC_INFO.ktr”
kjb执行
./kitchen.sh -file=”./scripts/heimdall.kjb”
命令行输出乱码
1 | export LANG=zh_CN.UTF-8 |
MySQL插表乱码
数据源选项中
Advanced，添加:set names utf8;
Options，添加：characterEncoding = utf8