1. Documentation
2. 10.3 (Latest) 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. Studio
4. Connect
5. Database
6. Jdbc
7. Using the MySQL Connector/J

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:

• Download the MySQL JDBC Connector/J
• Create the JDBC Connection
• Use the JDBC Connection

Download and extract the MySQL JDBC Connector/J

Download the latest Platform Independent release of 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.jar. Extract this file from the downloaded archive to a location on your hard drive that is accessible from RapidMiner Studio.

Create a new JDBC Connection

1. In RapidMiner Studio, right-click on the repository you want to store your Database Connection in and choose Create Connection.

   

   You can also click on Connections > Create Connection and select the repository from the dropdown of the following dialog.

2. Give a name to the new Connection, and set Connection Type to Database:

   

3. Choose MySQL as the database system.

   

   Fill out or adapt other necessary fields like User, Password, and Host.

4. Go to the Driver tab and remove the existing JAR file from the list. Then select the previous downloaded mysql-connector-java-X.X.XX.jar as the JDBC driver Jar file. Note that the JAR file will be bundled inside the connection itself, so you can move or delete the downloaded file.

   

5. Use Test connection to check your settings by connecting to the database. After a successful test, you can close the dialog by clicking on Save.

Use the JDBC connection

Use the newly created JDBC Connection with the Read Database, Write Database or Update Database operator.

In the following example the first Read Database operator uses the repository setting of define connection to select the connection entry by its path. While the second Read Database operator is directly connected to the connection with its connection input port.