Share this article:
✉ Send Feedback for this Article.

Vertica Integration with Oracle Analytics Desktop: 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 Oracle Analytics Desktop: Latest Versions Tested

Software Version
Partner Product

Oracle Analytics Desktop 6.4.0

Partner Product Platform Microsoft Windows Server 2019
Vertica Client

Vertica ODBC Driver 11.1

Vertica Server

Vertica Analytic Database 11.1

Vertica Server Platform CentOS Linux 8.5

Oracle Analytics Desktop Overview

Oracle Analytics Desktop is a data exploration and visualization tool that helps you get insights into your data from multiple sources. Its interactive visualizations enable you to explore data and make business decisions.

Installing Oracle Analytics Desktop

To install Oracle Analytics Desktop

  1. Go to Oracle Analytics Desktop download page.
  2. Read the instructions and download.

Installing the Vertica Client Driver

Before you connect to Vertica using Oracle Analytics Desktop, you must install the Vertica ODBC client.

To install the client driver

  1. Navigate to the Client Drivers page on the Vertica website.
  2. Download the client driver that is compatible with the Vertica server version.

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

  3. Double-click the installer and follow the prompts. When prompted to select one or more drivers, select ODBC only.

    Note To connect to Vertica, you do not need to set up a DSN. Oracle Analytics Desktop internally uses the the ODBC client so you only need to install the Vertica ODBC driver and provide the connection details.

Connecting Oracle Analytics Desktop to Vertica

To connect Oracle Analytics Desktop to Vertica

  1. Open Oracle Analytics Desktop and click Create on the top right corner of the Home page.

  2. In the Create pop-up window, click Connection to create a new connection.

  3. In the Create Connection pop-up window, click HP Vertica.

  4. Provide the Vertica database connection details:

    • Connection Name: Name of the connection.
    • Host: Enter database node IP address.
    • Port: Enter Port of database. Default port is 5433.
    • Database Name: Enter name of the database.
    • Username: Enter username of database.
    • Password: Enter password of database.

  5. Click Save.

    You need to now create a new dataset using the Vertica connection.

  6. In the Home page, click Create, and then click Data Set to create a new dataset.

  7. In the Create Data Set pop-up window, click the connection from the list.

  8. The schemas are displayed in the left pane along with an option to write a manual query.

Known Limitations

  • CHAR, VARCHAR, and LONGVARCHAR data types are displayed up to 256 characters.

  • For INTEGER data type, values are displayed correctly up to the 15th digit.

  • NUMERIC and FLOAT data types are displayed up to 15 digits of precision.

  • INTERVAL, UUID, BINARY, LONG VARBINARY, and VARBINARY data types are not displayed.

  • TIME and TIMETZ data type are displayed incorrectly.

  • For TIMESTAMP and TIMESTAMPTZ, milliseconds are displayed up to 3 digits.
  • For TIMESTAMPTZ data type, timezone is not displayed.

For More Information

Share this article: