1.进入kettle安装目录下:data-integration/simple-jndi,在jdbc.properties文件中添加:
Myslq8_DB/type=javax.sql.DataSource
Myslq8_DB/driver=com.mysql.cj.jdbc.Driver
Myslq8_DB/url=jdbc:mysql://SZMYSQLDB010.rigoltech.com:3306/ls_eshop?useUnicode=true&characterEncoding=UTF-8&allowMultiQueries=true&serverTimezone=Asia/Shanghai
Myslq8_DB/user=dba
Myslq8_DB/password=logiR@2021
2.kettle连接方式选择JNDI模式:Myslq8_DB