🎉 🎉   RAPIDMINER 9.5 BETA IS OUT!!!   🎉 🎉

GRAB THE HOTTEST NEW BETA OF RAPIDMINER STUDIO, SERVER, AND RADOOP. LET US KNOW WHAT YOU THINK!

CLICK HERE TO DOWNLOAD

🦉 🎤   RapidMiner Wisdom 2020 - CALL FOR SPEAKERS   🦉 🎤

We are inviting all community members to submit proposals to speak at Wisdom 2020 in Boston.


Whether it's a cool RapidMiner trick or a use case implementation, we want to see what you have.
Form link is below and deadline for submissions is November 15. See you in Boston!

CLICK HERE TO GO TO ENTRY FORM

How do I add database drivers for new databases in RapidMiner Studio

User13User13 Member Posts: 155  Guru
edited August 19 in Knowledge Base

To add a driver for a database not supported out of the box, follow these steps:

  1. Download the JDBC driver .jar file for it first. Google should help in that regard.

  2. Place the file inside the RapidMiner Studio installation folder in the lib/jdbc subfolder.

  3. Start RapidMiner Studio, and go to “Tools” -> “Manage Database Drivers”.

  4. 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).

  5. 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
<drivers>
element, there may be multiple
<driver>
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.



Tagged:
t_fischer
Sign In or Register to comment.