Connecting to Vertica

Contents[Hide]

1. Overview

This article shows you how to set up a Data connector for connecting to the Hewlett Packard Enterprise (HPE) Vertica database on Windows.

2. Install the driver

To connect to the Vertica database when Dundas BI is installed on Linux or if you have an older version of Dundas BI, you may need to download and install the drivers first. For details, see the System Requirements for your version of Dundas BI.

For details on installing the ODBC or JDBC drivers on Linux, see Vertica's documentation.

3. Create the data connector

Log on to Dundas BI and create a new data connector.

Enter a name for your data connector.

Set the Data Provider dropdown to Vertica Database.

Select the Authentication method and, if required, provide credentials. Enter the Host server and the Database name.

Create a new data connector for Vertica Database
Create a new data connector for Vertica Database

 Click Test Connection to check the connection to your Vertica database.

If the test is OK, click submit to create the data connector and perform data discovery.

4. See Also

Dundas Data Visualization, Inc.
500-250 Ferrand Drive
Toronto, ON, Canada
M3C 3G8

North America: 1.800.463.1492
International: 1.416.467.5100

Dundas Support Hours:
Phone: 9am-6pm, ET, Mon-Fri
Email: 7am-6pm, ET, Mon-Fri