Share this article:

Vertica Integration with DBeaver: Connection Guide

About Vertica Connection Guides

Vertica connection guides provide basic information about setting up connections to Vertica from software that our technology partners create. These documents provide guidance using one version of Vertica and one version of the third party vendor’s software. Other versions of the third-party product may work with Vertica. However, other versions may not have been tested.

Vertica and DBeaver Versions Tested

This document is based on our testing of Vertica and DBeaver using the following versions:

Software Version
Partner Product

DBeaver 4.3.0

Desktop Platform

Windows Server 2012 R2

Vertica Client

Vertica JDBC driver 9.0.x

Vertica Server

Vertica Server 9.0.1-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.

Download and Install DBeaver

Download the latest version of DBeaver from the DBeaver site.

To install DBeaver, follow the instructions provided by the automatic installer distribution. Alternatively, you can unpack the download and start the DBeaver executable.

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

Download Vertica Client Drivers

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 version of the Vertica client package that is compatible with the architecture of your operating system and Vertica server version.

Note Vertica drivers are forward compatible, so you can connect to the Vertica server using previous versions of the client. For more information about client and server compatibility, see Client Driver and Server Version Compatibility in the Vertica documentation.

Connect DBeaver to Vertica

Follow these steps to create a connection to Vertica:

  1. Open DBeaver.
  2. Select Database > New Connection.


  3. In the Create New Connection window, select Vertica.
  4. Click Next.
  5. In the General tab, enter your database credentials. 


  6. Click Edit Driver Settings. The Edit Driver Vertica window opens.
  7. Select 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

In time-related tables, milliseconds do not appear. You can resolve this issue by following these steps:

  1. In DBeaver, select Window > Preferences.
  2. In the Preferences window, select Database > Result Sets > Data Formats.
  3. Change the Type to Time or Timestamp. This will display the millisecond value. 


For More Information

Share this article: