Zoomdata Version

Managing Vertica Connectors

Zoomdata's Vertica connector lets you access the data available in this SQL query engine for visualization and exploration within the Zoomdata Client. Zoomdata supports versions 7.1 and 7.2 .

By default, Vertica is not included with Zoomdata. Before you can establish a connection from Zoomdata to Vertica, a Vertica connector server needs to be installed, configured and enabled first by the Zoomdata Account Administrator.

The Vertica connector requires a JDBC driver to be configured before you can connect to your data source. You can download the driver from the vendor's site. If you are upgrading, keep in mind you need to configure the JDBC driver - see Upgrading Zoomdata Server to v2.5 for instructions. For more information and steps, see Adding a JDBC Driver .

What does vertica support?

The table below lists information on the features that are supported by Vertica.

Supports Distinct Count? Yes
Supports Group-by Time? Yes
Supports Multi Group-by Charts? Yes
Supports Histogram? Yes
Supports Box Plot? Yes
Supports Derived Fields? No
Custom SQL Capable? Yes
Live Mode & Playback Yes
Supports Last Value? Yes

Managing your vertica connections

Zoomdata supports Flex tables. However, you must properly map the metadata for the Flex tables in Vertica to use these data in Zoomdata.

The Interval data type in Vertica will be converted to the Number type in Zoomdata. The values for the Interval data type will be converted as follows in Zoomdata:

  • INTERVAL [DAY TO SECOND] - number of seconds
  • INTERVAL [YEAR TO MONTH] - number of months

The fields containing these converted data will be marked as Raw Data Only. You can view these data in the Details window on a chart or export as Raw Data .

Chart Settings for Vertica

On the Charts page, you can:

  1. Edit Global Default Settings .
  2. Select the Standard and, if available, Custom chart styles to be used with the data source.
  3. Set default parameters (group, sub-group, colors, sorting, and so on) for each chart style.
Learn more about how to customize a chart .

Select Finish to save your changes. Once your data connection has been established, it is listed under My Data Sources.

Was this topic helpful?