kettle访问Oracle18c

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, 展示以下提示则代表成功