Using a JDBC driver
This guide targets the new Connection Management introduced with RapidMiner Studio 9.3.
For the old Legacy JDBC Connections see the9.2 documentation
RapidMiner Studio comes bundled with a few JDBC drivers that allow you to connect to various databases (MySQL, MSSQL, Oracle, Postgres, ...). If you want to connect to other databases, you need to manually download and configure their respectiveJDBC driver.
This article will walk you through how to:
Download a JDBC driver
Go to your favorite search engine, and enter the name of the database together with the wordJDBC. This should lead you to a download page for most databases. The driver itself is usually a file namedxyz.jar. Extract this file from the downloaded archive to a location on your hard drive that is accessible from RapidMiner Studio. Note that for some databases, you need more than onejarfile.
Create a new JDBC Connection
In RapidMiner Studio, right-click on the repository you want to store your Database Connection in and choose
Create Connection.
You can also click onConnections > Create Connection
and select therepositoryfrom the dropdown of the following dialog.Give a name to the new Connection, and setConnection Typeto
Database:
Select the Database system from the list of predefined DBs, or choose a custom system.
Fill out or adapt other necessary fields likeUser,Password, andHost.
(This step is only necessary if you have selected aCustomDatabase system). Go to the Driver tab and select the previous downloaded
xyz.jaras theJDBC driver Jar file. Note that the JAR file will be bundled inside the connection itself, so you can move or delete the downloaded file. If there are multiple JAR files, you may need to add them all. The documentation of the respective database should tell you what you need.
Use
Test connectionto check your settings by connecting to the database. After a successful test, you can close the dialog by clicking on
Save.
Create Connection.
Database:
Test connectionto 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 theRead Database,Write DatabaseorUpdate Databaseoperator.
In the following example the firstRead Databaseoperator uses the repository setting ofdefine connectionto select theconnection entryby its path. While the secondRead Databaseoperator is directly connected to the connection with its connection input port.
Specific databases
The following pages describe some specific information for certain databases:
