kettle8.2 对应mysql_kettle pdi8.2 连接mysql8

mysql-connector-java-5.1.41-bin.jar  只支持到5.1的，mysql8 的连接只能在pdi8/simple-jndi/jdbc.properties文件中增加如下代码：

MYSQL8_DB/type=javax.sql.DataSource

MYSQL8_DB/driver=com.mysql.cj.jdbc.Driver

MYSQL8_DB/url=jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf8&useSSL=false&serverTimezone=GMT

MYSQL8_DB/user=root

MYSQL8_DB/password=123456

jdbc.properties文件如下所示：

SampleData/type=javax.sql.DataSource

SampleData/driver=org.h2.Driver

SampleData/url=jdbc:h2:file:samples/db/sampledb;IFEXISTS=TRUE

SampleData/user=PENTAHO_USER

SampleData/password=PASSWORD

Quartz/type=javax.sql.DataSource

Quartz/driver=org.hsqldb.jdbcDriver

Quartz/url=jdbc:hsqldb:hsql://localhost/quartz

Quartz/user=pentaho_user

Quartz/password=password

Hibernate/type=javax.sql.DataSource

Hibernate/driver=org.hsqldb.jdbcDriver

Hibernate/url=jdbc:hsqldb:hsql://localhost/hibernate

Hibernate/user=hibuser

Hibernate/password=password

Shark/type=javax.sql.DataSource

Shark/driver=org.hsqldb.jdbcDriver

Shark/url=jdbc:hsqldb:hsql://localhost/shark

Shark/user=sa

Shark/password=

PDI_Operations_Mart/type=javax.sql.DataSource

PDI_Operations_Mart/driver=org.postgresql.Driver

PDI_Operations_Mart/url=jdbc:postgresql://localhost:5432/hibernate?searchpath=pentaho_operations_mart

PDI_Operations_Mart/user=hibuser

PDI_Operations_Mart/password=password

live_logging_info/type=javax.sql.DataSource

live_logging_info/driver=org.postgresql.Driver

live_logging_info/url=jdbc:postgresql://localhost:5432/hibernate?searchpath=pentaho_dilogs

live_logging_info/user=hibuser

live_logging_info/password=password

MYSQL8_DB/type=javax.sql.DataSource

MYSQL8_DB/driver=com.mysql.cj.jdbc.Driver

MYSQL8_DB/url=jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf8&useSSL=false&serverTimezone=GMT

MYSQL8_DB/user=root

MYSQL8_DB/password=123456

考贝mysql-connector-java-8.0.15.jar到libswt/win64目录：

重启pdi，通过如下方式连接：

点击测试按钮，如下图所示成功连接：