1.Oracle18C JDBC驱动包:
官网下载地址:
https://www.oracle.com/database/technologies/appdev/jdbc-ucp-183-downloads.html
百度云盘下载地址:
链接:https://pan.baidu.com/s/173-hRwFCUf8o7fmELcsJ6A 提取码:n7ea
pdi-ce-8.0.0.0-28\data-integration\lib\ojdbc8.jar
2.复制jar包到Kettle安装目录/lib/
3.Kettle数据库配置
- Connection Type 选择 "Generic Database"
- Access 选择 "Native(JDBC)"
- URL 更新Host,端口及服务名
jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.31.25)(PORT=1521))(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME=dw)))
- Driver Class Name 填写 "oracle.jdbc.driver.OracleDriver"
- 填写对应的账号密码
4.test
点击test, 展示以下提示则代表成功