Configuring DBeaver for JNI Access to an RDM Database

This section outlines the steps to take in order to access an RDM 15 database from DBeaver using the RDM JNI library.

DBeaver Community Edition 7.3.4 is used for this section. Details may differ depending on the edition and version of DBeaver.

Create an RDM Driver

For the local (JNI) connection to an RDM database, the RDM libraries need to be in the system path before you execute DBeaver. One way to do so is to set the following environment variable.

OS Environment Variable Example
Windows PATH C:\Raima\RDM\15.1\bin
Linux LD_LIBRARY_PATH /opt/Raima/rdm-<package>-15.1/bin
macOS DYLD_LIBRARY_PATH /opt/Raima/rdm-<package>-15.1/bin

Alternatively, you can copy or symlink all the RDM libraries into a directory included in the system's java.library.path.

To create an RDM driver in DBeaver, take the following steps.

  1. Start DBeaver
  2. From the main window, Choose Database -> Driver Manager
  3. On the Driver Manager dialog box, choose New

  1. Name the driver "RDM" (or whatever you like) in the Driver Name edit box
  2. Click Add File
  3. Choose the Raima JDBC driver (rdmjdbc-15.jar) you wish to use with DBeaver. The driver is located in the java-lib directory of the RDM installation (e.g. C:\Raima\RDM\15.1\java-lib).
  4. Click Find Class. Choose "com.raima.rdm.jdbc.RDMDriver" as it is displayed for the Driver class.
  5. Click "OK"

  1. Click Close to close the Driver Manager dialog box.

Creating a Connection

To create a connection to an RDM 15 database using DBeaver, take the following steps.

  1. From the main window, choose Database -> New Connection
  2. In the Connect to a database dialog box, type "RDM" into the search box so your newly-created entry is displayed
  3. Click "RDM"
  4. Click Next

  1. In the next screen, Generic JDBC Connection Settings, enter the JDBC URL in the JDBC URL field as follows 
jdbc:raima:rdm://local/<database_name>
  1. Click Finish

  1. Back in the main window, right-click the newly-created "New Connection" in the Data Navigator pane
  2. Select Edit Connection

  1. In the Connection "New Connection" configuration dialog box, switch to the Driver properties tab
  2. Next to the document root property, enter the Document Root location of for the database; for example:
C:\Raima\RDM\15.1\\GettingStarted\sql\sql_bookshop

  1. Click Test Connection to ensure that the connection is successful.
  2. Click Finish

Connecting to the Database

From the main window, choose the newly created connection from the Database Navigation tab

Collapse your database (e.g. "bookshop") to view the data and metadata