1. Connecting Oracle Analytics Cloud to Your Data
  2. Reference
  3. Data Sources and Data Types Reference
  4. List of Supported Databases in Oracle Analytics Cloud
  5. Vertica

Vertica

You can connect Oracle Analytics to a Vertica database.

Supported Versions

9.x, 12.x

Prerequisites

None.

Connectivity

Use Data Source With Support Connectivity Options Notes
Datasets Yes
  • Standard
  • Private access channel
  • Remote Data Connectivity
  • Data access - Live or cache
 -
Semantic Modeler Yes
  • Standard
 -
Model Administration Tool Yes
  • Standard
  • Private access channel
  • Remote Data Connectivity
  • System connection
 -
Oracle Analytics Publisher Yes
  • Standard
 -

For more information about this connectivity table, see Key to Connectivity Table.

Other Connectivity Information

  • Server-Side SSL support only – no support for Mutual-TLS.
  • Remote connectivity for datasets is only available using Data Gateway.
  • If you're connecting to an on-premises Vertica database using Data Gateway, you must copy the Vertica JDBC client driver JAR file to the machine where Data Gateway is installed:
    1. Stop the Jetty server. For example, use 
      ./stopJetty.sh
      (on Linux) or 
      stopJetty.cmd
      (on Windows). Run this command from 
      Oracle/Middleware/Oracle_Home/domain/bin
      .
    2. Copy the Vertica JAR file to 
      Oracle/Middleware/Oracle_Home/domain/jettybase/lib/ext
      .
    3. Start the Jetty server. For example, use .
      /startJetty.sh
      .

Useful Documentation Links