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:

2. Click Next.

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

You can download a JDBC driver matching your CData Virtuality Server version from your own CData Virtuality Server instance or the CData Virtuality Driver 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:

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

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

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

6. Click Finish to connect DBeaver to CData Virtuality.