Vertica Integration with DBeaver: Connection Guide

About Vertica Connection Guides

Vertica connection guides provide basic instructions for connecting a third-party partner product to Vertica. Connection guides are based on our testing with specific versions of Vertica and the partner product.

Vertica and DBeaver: Latest Versions Tested

Software Version
Partner Product

DBeaver Enterprise Edition 21.1.0

Desktop Platform

Windows Server 2019

Vertica Client

Vertica JDBC driver 11.0.0

Vertica Server

Vertica Server 11.0.0

DBeaver Overview

DBeaver is a free and open-source database tool for developers and database administrators. It is based on an open-source framework and allows users to write various extensions.

Installing DBeaver

Download the latest version of DBeaver from the DBeaver website.

To install DBeaver, follow the instruction prompts on the installer.

Note Do not extract DBeaver in the same folder where an older version of DBeaver is installed. Ensure to remove previous versions before installing a new version in the same folder.

Downloading the Vertica Client Driver

Before you can connect to Vertica using DBeaver, you must install the Vertica JDBC client driver by following these steps:

  1. Go to the Vertica Client Drivers page.
  2. Download the JDBC driver package.

Note For details about client and server compatibility, see Client Driver and Server Version Compatibility in the Vertica documentation.

Connecting DBeaver to Vertica

Follow these steps to create a connection to Vertica:

  1. Open DBeaver.
  2. From the menu, click Database > New Database Connection.

    newconnection.png

  3. In the Connect to a database window, search Vertica.

  4. Click Next.
  5. Enter your connection details: 

    databasecredentials.png

  6. Click Edit Driver Settings.
    The Edit Driver 'Vertica' window opens.
  7. Select Libraries and then click Add File.

  8. Select the Vertica JDBC file you downloaded.
  9. Click Open. The file appears in the Edit Driver Vertica window.
  10. Click OK.
  11. Click Test Connection. If your connection to Vertica is successful, a message appears.

Known Limitations

  • For DOUBLE data type, the smallest double value is not supported and displayed as zero.

  • For TIME data type, milliseconds are not supported.

  • For TIMETZ data type, milliseconds and time zone values are not displayed.

  • For TIMESTAMPTZ data type, time zone is not displayed.

  • For TIMESTAMP data type, milliseconds are not supported. To resolve this,
  1. In DBeaver, select Window > Preferences.
  2. In the Preferences window, select Editors > Data Editor > Data Formats.
  3. Change the Type to Time or Timestamp. This will display the millisecond value.

    timestamp.png

  4. Click Apply and then click Apply and Close.

    The milliseconds will now be displayed correctly.

For More Information