How do I add database drivers for new databases in RapidMiner Studio
To add a driver for a database not supported out of the box, follow these steps:
Download the JDBC driver .jar file for it first. Google should help in that regard.
Place the file inside the RapidMiner Studio installation folder in the lib/jdbc subfolder.
Start RapidMiner Studio, and go to “Tools” -> “Manage Database Drivers”.
Click “Add” and enter the properties of that specific database (again, Google will help there). Point it to the driver .jar file you copied into the aforementioned folder and select the correct Driver class (most of the time, the automatically selected one should be correct).
Restart RapidMiner Studio.
You should now see the driver as available in the “Tools” -> “Show Database Drivers” dialog.
If that is not the case, you can also manually add a driver. To do so, locate the jdbc_properties.xml file (see
“Where does RapidMiner Studio store its settings?”
) and edit it as follows:
<drivers> <driver dbnameseparator="DRIVER_SEPARATOR" defaultport="DRIVER_PORT" driver_jar="C:\Program Files\RapidMiner\RapidMiner Studio\lib\jdbc\DRIVER_JAR.jar" drivers="package.structure.for.DriverClass" name="DB_NAME" urlprefix="JDBC_URL_PREFIX"/> </drivers>
Between the outer
element, there may be multiple
elements (one for each additional driver). Edit the above to match the required settings for the desired JDBC driver. Restarting RM Studio afterwards is necessary.