Share this article:

Vertica Integration with Dundas BI: Connection Guide

Vertica connection guides provide basic information about setting up connections to Vertica from software that our technology partners create. This document provides guidance using the latest versions described in the next section.

Dundas BI and Vertica Product Versions Tested

This document provides guidance using the software listed as follows:

Software Version
Dundas Client

Dundas BI version 5

Desktop Platform

Windows Server 2012 R2

Vertica Client

Vertica 9.1.1 ADO.NET driver

Vertica Server

Vertica 9.1.1

Dundas BI Overview

Dundas BI provides a set of tools that allows you to view, analyze, and transform your data using comprehensive business intelligence capabilities.

You can connect and integrate Dundas BI with Vertica in real time and on any device from desktop to mobile. You can run Dundas BI on premises or in a cloud environment.

Dundas allows you to:

  • Create interactive and customizable dashboards and reports.
  • Run ad-hoc queries.
  • Analyze your data and performance.

For more information about Dundas BI, visit the Dundas BI website. To start learning about Dundas BI, see the Tutorials and User Guides.

Install Dundas BI

Before downloading and installing Dundas BI, go to the Dundas BI System Requirements page for hardware and software requirements.

Go to the Dundas BI download page to download and install the product. To download the product complete the registration criteria and click Submit. You will receive a verification email. Click the download link from the email to access the download page.

Run the Dundas BI executable (for example, Dundas.BI.Setup.x.x.x.xxxx.exe) to install the product. For detailed installation and configuration instructions see the Dundas installation documentation.

Important Dundas BI is a web-based server application that requires IIS and access to Microsoft SQL Server or PostgreSQL for storing application data. The IIS server and metadata database should be up and running before you try to connect.

Download and Install the Vertica Client Drivers

Dundas BI uses the Vertica native connector to connect to your Vertica database. Download and install the Windows ADO.NET driver on your Dundas BI client machine as follows:

  1. Go to the Vertica Client Drivers page.
  2. Download the version of the Vertica client package that is compatible with the architecture of your operating system and Vertica server version.
  3. Based on the client driver package you downloaded, follow the installation instructions in the Vertica documentation.

Connect Dundas BI to Vertica

Follow these steps to connect Dundas BI to Vertica :

  1. Use the Dundas administrator account you set up during installation to log on to your Dundas BI website using a browser. The URL is provided to you at the end of the installation process, for example: http://<myDundasServer>:8000/.

  2. After you log in the Getting Started window appears:

  3. In the left hand side menu of the Getting Started window, click the Home icon. The Welcome Home screen appears:



  4. Select Explore Data. The following appears:


  5. Select Data Connectors from the menu on the right-hand side of this screen. The following toolbar appears:


  6. Select the New Data Connector icon. The New Data Connector window appears on the left side of the screen:




  7. From the Data Provider drop-down menu, select Vertica database.
  8. Enter the following information:

    • Authentication
    • Login credentials
    • Host IP address
    • Database name
    • Connection pooling parameters
    • Connection settings parameters
    • Session settings parameters
  9. Click Test connection to verify that the connection works.
  10. After you verify that the connection works, select the check box at the bottom-right of the screen.

Work with the Vertica Data

Follow these steps to select the data you want to work with:

  1. Click the Home icon on the upper-left of the screen to return to the Welcome Home page.
  2. Click Explore the data. The Metric Sets window opens.

    A metric set is an object that allows you to work with your Vertica data. You can define measures, dimensions, filters, sorting, and hierarchy, and sort and transform your data. You create a visualization of that data using the characteristics specified in your metric set.

  3. Click Use an existing data structure. A list of objects in the schema displays.

  4. Select the table you want to work with and select the check box to view the details of that table:

    Now you can view, transform, and make visualizations of the data in your Vertica database.

Known Limitations

Before using Dundas BI with Vertica, be aware of the following known limitations:

  • Dundas BI does not display data and may display an error for the following Vertica data types:
    • Binary
    • Varbinary
    • Longvarbinary
    • Time
    • TimeTz
    • IntervalSeconds
    • IntervalMonth
    • UUID
  • Dundas BI rounds to 2 digits after a decimal for DECIMAL and FLOAT values.

  • Dundas BI does not support the following FLOAT data type values:
    • SmallestDouble
    • ZeroPlusFraction
  • Dundas BI truncates the millisecond portion of the typical values TIMESTAMP and TIMESTAMPTZ data types.

For More Information

 

Share this article: