本文介绍了如何解决Kettle连接Oracle和SQLServer数据库的问题。在尝试连接Oracle时，遇到驱动类找不到的错误，需确保Oracle JDBC驱动已安装在正确路径。参照教程，将驱动库放在'E: 2ETLpdi-ce-8.0.0.0-28data-integrationlib'下。对于SQLServer，由于缺少相应驱动，需要下载jtds.jar并放置于libswt或lib目录，重启Kettle后即可正常连接。
1.连接oracle数据库
错误连接数据库 [sql1] :
org.pentaho.di.core.exception.KettleDatabaseException:
Error occurred while trying to connect to the database
Driver class 'oracle.jdbc.driver.OracleDriver' could not be found, make sure the 'Oracle' driver (jar file) is installed.
oracle.jdbc.driver.OracleDriver
org.pentaho.di.core.exception.KettleDatabaseException:
Error occurred while trying to connect to the database
Driver class 'oracle.jdb
最低0.47元/天 解锁文章
871
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
