1. Documentation
2. 2024.1 (Latest) 2024.0 10.3 10.2 10.1 10.0 9.10 9.9 9.8 9.7 9.6 9.5 9.4 9.3 9.2 9.1 9.0 8.2 8.1 8.0 7.6
3. Server
4. Installation
5. Using MySQL Connector/J

Using the MySQL Connector/J (JDBC driver)

RapidMiner Server comes bundled with three database drivers:

• MSSQL
• Oracle
• PostgreSQL

If you want to connect to MySQL databases, 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

Install the MySQL JDBC Connector/J

1. Download the MySQL Connector/J from the official MySQL website.

   Both the compressed TAR archive and the ZIP archive will work. Currently the recommended version is 5.1.31.

2. The connector itself is a single file named mysql-connector-java-X.X.XX-bin.jar. Extract this file from the downloaded archive to the data/jdbc folder in your RapidMiner Server Installer folder.

3. In the database configuration step select MySQL as database system and provide the file path of the connector extracted in the second step as Jar file.

   

4. Make sure that the JDBC driver class is set to com.mysql.jdbc.Driver.

5. Complete the installation.