DBeaver

DBeaver is a free and open-source database tool for developers and database administrators. It runs on any platform and supports any database with a JDBC driver.

Connector Setup

1. Create a new database connection in DBeaver, select SQL from the tabbed menu on the left-hand side, and then select Data Virtuality:

DBeaver database connection dialog showing available database drivers, with Data Virtuality selected among SQL options.

2. Click Next.

3. Open the Libraries tab and provide the location of the CData Virtuality JDBC driver:

DBeaver 'Edit Driver - Data Virtuality' dialog showing the Libraries tab with the JDBC driver file and driver class configuration.

You can download a JDBC driver matching your CData Virtuality Server version from your own CData Virtuality Server instance or the CData Virtuality drivers download page.

4. Open the Settings tab and provide the URL and default port that suits the configuration of the Data Virtuality Server you want to connect to:

DBeaver Edit Driver Data Virtuality window showing driver settings with class name com.datavirtuality.dv.jdbc.Driver, JDBC URL template, default port 31001, default database datavirtuality, and default user admin.

Please note that the JDBC URL differs for encrypted and unencrypted connections:

for an SSL connection (usually port 31001): jdbc:cdatavirtuality:{database}@mms://{host}:{port}
for a non-SSL connection (usually port 31000): jdbc:cdatavirtuality:{database}@mm://{host}:{port}

5. On the next screen, enter details of the CData Virtuality Server you want to connect to:

DBeaver Data Virtuality connection settings dialog showing host and port 31001, database datavirtuality, user credentials, optional SSL setting, and buttons for testing and finishing the connection.

6. Click Finish to connect DBeaver to CData Virtuality.

JDBC connection string changed in v4.10: both jdbc:datavirtuality and jdbc:cdatavirtuality are acceptable