Connecting to Vertica Database

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.

2. Install the driver

In order to connect to the Vertica database, you need to download and install the HPE Client Drivers.

Make sure that ADO.Net Provider is selected from the list of HPE Verica componentes.

Install the HPE Vertica ADO.Net Provider
Install the HPE Vertica ADO.Net Provider

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: 7am-6pm, ET, Mon-Fri