Some discussion can be found at this link. A work-around is to use the MySQL version 8.x Drivers but use a Generic Connection. The easiest solution is to use the MySQL 5.x Connector drivers.

Note that as of November, 2019 the Pentaho version 8.x tools will not work directly with the newer MySQL Connector version 8.x drivers. Instructions for copying the JDBC drivers to the appropriate folders in the Pentaho tools are described on the next page. Or click on the Just start my download link. Log in with your Oracle Web site account (or create one for free). Make sure “Platform Independent” is selectedįor Windows operating system download the ZIP Archive Scroll down to the section with the download options. The JDBC Drivers for MySQL are called “Connector/J” After installing the Pentaho tools, shut down the BA server and Data Integration software. The following steps outline how to add the MySQL JDBC drivers to Pentaho.įollow these instructions on Installing Pentaho BA Server and Data Integration Tools if the tools have not yet been installed. However as of version 7 of the Community Edition, they do not come with JDBC drivers for Oracle, SQL Server or MySQL (in Data Integration tools).

The Pentaho Data Integration and BA Server tools comes with many different database drivers.

Mysql driver for windows 10