Pentaho连接mysql

时间:2022-11-10 20:00:22

Pentaho下载好后,初次连接mysql DB提示driver错误,具体如下:

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

Pentaho连接mysql

需要mysql connector, 去Oracle网站下载的新版mysql-connector-j-8 不工作,找到原来自己保存的mysql-connector-java-5.1.41-bin.jar 也不行,不断提示parameter错误,后来到Pentaho market place下载了plug后可以。

在此下载:​​https://marketplace.hitachivantara.com/pentaho/​

搜索最新版本只有Pentaho 8.2

Pentaho连接mysql

下载后将mysql-connector-java-5.1.23-bin.jar放到\data-integration\lib 中,plug in放到:\data-integration\plugins\pdi-mysql-plugin\

Pentaho连接mysql