Using the MySQL Connector/J (JDBC driver)
RapidMiner Studio comes bundled with the MariaDB Connector/J – a driver that allows to connect to both MariaDB and MySQL databases. If you want to connect to MySQL databases using the official driver, you need to manually download and configure the MySQL Connector/J.
This article will walk you through how to:
Install the MySQL JDBC Connector/J
Download the latest MySQL Connector/J from the official MySQL website.
Both the compressed TAR archive and the ZIP archive will work.
The connector itself is a single file named
mysql-connector-java-X.X.XX-bin.jar. Extract this file from the downloaded archive to a location on your hard drive that is accessible from RapidMiner Studio.
In RapidMiner Studio, open the Manage Database Drivers dialog from the Connections menu.
Click on Add to create a new entry with the following properties:
Select the connector extracted in the second step as
Please pay special attention to the correct
Driver class(an incorrect class might be selected by default).
Close the dialog by clicking on Save.
Check which connector is used
To check whether the MariaDB Connector/J or the MySQL Connector/J is used, open the Show Database Drivers… dialog from the Connections menu:
If the driver classes for both the bundled and the newly created connectors is
com.mysql.jdbc.Driver the MySQL Connector/J is being used.
If it is
org.mariadb.jdbc.Driver, the bundled MariaDB Connector/J is used.