Connecting to Vertica
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.
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.