Configuring DBeaver for Remote Access to an RDM Database

This section outlines the steps to take in order to access an RDM 14.2 database from DBeaver using the client/server model.

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

  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.2\java-lib).
  4. Click Find Class.
  5. Choose "com.raima.rdm.jdbc.RDMDriver" as it is displayed for the Driver class.
  6. Click "OK"

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

Creating a Connection

  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 jdbc:raima:rdm://<hostname>/<database_name>, where
    <hostname> is the hostname of the computer rdm-tfs is running, and
    <database_name> is the name of the database to open; for example:
jdbc:raima:rdm://localhost/BOOKSHOP

Make sure rdm-tfs is running first!

  1. Make sure you have rdm-tfs running. To open the BOOKSHOP database used as an example above, the DOCUMENT ROOT of rdm-tfs must point to the following directory: 
C:\Raima\RDM\15.2\\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