Share 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 5.4.0

Partner Product Platform Microsoft Windows Server 2016
Vertica Client

Vertica ODBC 9.3.1

Vertica Server

Vertica Database 9.3.1-0

Vertica Server Platform CentOS Linux 7.4.1708 (Core)

Oracle Analytics Database Overview

Oracle Analytics is a comprehensive solution to meet the breadth of all analytics needs. Get the right data, to the right people, at the right time with analytics for everyone in your organization. With built-in security and governance, you can easily share insights and collaborate with your colleagues.

Installing Oracle Analytics Database

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.

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.

    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.

  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. You can select columns from the database or write a custom query for the new dataset.

  9. After you include the columns in the data set, click Get Preview Data to view this data.

Known Limitations

  • INTERVAL, UUID, BINARY, LONG VARBINARY, and VARBINARY data types are not supported.
  • Timezone for TIMETZ and TIMESTAMPTZ data types is not supported.
  • Milliseconds are truncated for TIME, TIMESTAMP, TIMETZ, and TIMESTAMPTZ data types.
  • For NUMERIC data types, values are rounded off after the 15th digit.
  • For DECIMAL data type, 0 is displayed as the minimum value.

For More Information

Share this article: