|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
Oracle Analytics Desktop 5.4.0
|Partner Product Platform||Microsoft Windows Server 2016|
Vertica ODBC 9.3.1
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
- Go to Oracle Analytics Desktop download page.
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
- Navigate to the Client Drivers page on the Vertica website.
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.
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
Open Oracle Analytics Desktop and click Create on the top right corner of the Home page.
In the Create pop-up window, click Connection to create a new connection.
In the Create Connection pop-up window, click HP Vertica.
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.
You need to now create a new dataset using the Vertica connection.
In the Home page, click Create, and then click Data Set to create a new dataset.
In the Create Data Set pop-up window, click the connection from the list.
You can select columns from the database or write a custom query for the new dataset.
After you include the columns in the data set, click Get Preview Data to view this data.
- 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.