Kettle安装使用教程（未完待续）

快来打我* 2022-06-15 01:09 421阅读 0赞

Kettle是一款使用Java编写的开源ETL工具，运行Kettle需要JVM环境，因此安装Kettle之前需要首先配置好JDK环境变量。JDK及Kettle下载地址：[百度网盘提取码e5vj][e5vj] [Kettle7.0官网][Kettle7.0] [甲骨文][Link 1]

解压pdi-ce-7.0.0.0-25.zip之后，双击spoon.bat运行Kettle。

![这里写图片描述][20170519104819925]

![这里写图片描述][20170519110356787]

新建一个转换，选择DB连接，本文使用MySQL数据库实例。填写必要选项之后点击测试，弹出正确连接则连接成功，如下图所示，如果弹出错误连接数据库提示，是因为Kettle找不到数据库驱动，将mysql connector jar包放到lib文件夹下重启Kettle即可解决。驱动下载地址 [csdn][]。

错误连接数据库 [DBTest] : org.pentaho.di.core.exception.KettleDatabaseException: 
    Error occurred while trying to connect to the database
    
    Driver class 'org.gjt.mm.mysql.Driver' could not be found, make sure the 'MySQL' driver (jar file) is installed.
    org.gjt.mm.mysql.Driver
    
    
    org.pentaho.di.core.exception.KettleDatabaseException: 
    Error occurred while trying to connect to the database
    
    Driver class 'org.gjt.mm.mysql.Driver' could not be found, make sure the 'MySQL' driver (jar file) is installed.
    org.gjt.mm.mysql.Driver

![这里写图片描述][20170519105327812]

![这里写图片描述][20170519110914407]

[e5vj]: http://pan.baidu.com/s/1jHS59qe
[Kettle7.0]: http://community.pentaho.com/projects/data-integration/
[Link 1]: http://www.oracle.com/technetwork/cn/java/javase/downloads/jdk8-downloads-2133151-zhs.html
[20170519104819925]: /images/20220615/12724214345e484eac2d6b8ce553824e.png
[20170519110356787]: /images/20220615/7b90fd5e71224c3590ee6f7be19690aa.png
[csdn]: http://download.csdn.net/download/z45689/9730433
[20170519105327812]: /images/20220615/12d4767b427b43a2aaa649be627fdfb0.png
[20170519110914407]: /images/20220615/8f5961cb87674cdf93a22e5b471722dd.png