Another tip is to install the PDI MySql Plugin from the Pentaho Marketplace in Pentaho Data Integration. 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. Download MySQL Installer If you are connecting to the internet while installing MySQL, you can choose the online installation version mysql-installer-web. 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. These drivers are developed and maintained by the MySQL Community. In addition, a native C library allows developers to embed MySQL directly into their applications. Net enabling developers to build database applications in their language of choice.
#Mysql driver for windows 10 how to#
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. MySQL provides standards-based drivers for JDBC, ODBC, and. You will find a line stating extensionphpmysqli.dll. Then go to php folder and open the file named php.ini with any text editor. To do that: At first close all running services of xampp. 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). I guess you haven't enabled mysql in your XAMPP server yet. The Pentaho Data Integration and BA Server tools comes with many different database drivers.