Share this article:

Vertica Integration with Dundas BI: Connection Guide

About Vertica Connection Guides

Vertica connection guides provide basic information about setting up connections to Vertica from software that our technology partners create. These documents provide guidance using one specific version of Vertica and one specific version of the third-party vendor’s software. Other versions of the third-party product may work with Vertica. However, those other versions may not have been tested.

About this Document

This document explains how to connect Dundas BI, a feature-rich data exploration tool, to your Vertica database.

Software Versions Tested

Vertica engineers have tested Vertica 8.0.x and Vertica 8.1.x with Dundas BI 4 on Windows.

Partner Product Dundas BI 4
Desktop Platform Windows Server 2012 R2
Vertica client

Vertica native connector (ADO.NET driver 8.0)

 

ADO.NET 8.1 is not supported for connecting to Vertica from Dundas BI 4.

Vertica server Vertica 8.0.x, Vertica 8.1.x

Dundas BI Overview

Dundas BI provides a comprehensive set of tools that allow 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 that Dundas provides for users.

Installing Dundas BI

You can download Dundas BI using the information in these links :

Before you install Dundas BI, review the Dundas BI System Requirements.

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

Install the Client Driver

Dundas BI uses the Vertica native connector to connect to your Vertica database.

To install the native connector in your existing Dundas BI environment, follow these steps:

  1. Download and install the Windows ADO.NET 8.0 driver on your Dundas BI server machine from: https://my.vertica.com/download/vertica/client-drivers/.
  2. Restart the IIS Server.

Connect Dundas BI to Vertica

Follow these steps in order to connect Dundas BI to Vertica via the native connector :

  1. After you install Dundas BI (Installing Dundas BI), navigate to the generated web link for Dundas BIWebsite, which is something like: http://myDundasServer:8000/.

  2. If you have an account, enter your login credentials, and skip to step 5.

  3. If you do not have an account, click Register.

  4. Enter the following information:
    • Name
    • Account name
    • Email
    • Any message for the Dundas administrators.

    Dundas sends you an email when your account has been approved.

  5. The Getting Started window appears.

    The following graphic identifies functional areas of Dundas BI that you should familiarize yourself with.

  6. To create the connection to Vertica, first click the Home button in the upper-left corner of the Getting Started window. The Welcome Home screen appears.

  7. Click Connect to data. The New Data Connector window opens.

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

    • Authentication
    • Login credentials
    • Host IP address
    • Database name
    • Connection pooling parameters
    • Connection settings parameters
    • Session settings parameters
  10. Click Test connection to verify that the connection works.
  11. After you verify that the connection works, click the checkmark 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. To return to the Welcome Home page, click the Home icon on the upper-left of the screen.
  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 tranform your data. You create a visualization of that data using the charactertistics 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 click the checkmark. You can see the details of that table:

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

Known Limitations

Dundas BI does not support the following data types. Dundas BI does not display data of these types and may display an error:

  • Binary
  • Varbinary
  • Longvarbinary
  • Time
  • TimeTz
  • IntervalSeconds
  • IntervalMonth

Dundas BI rounds off some decimal values as follows:

  • 79228162514264.337593543950335 to 79228162514264.34
  • 1234.56789 to 1234.57

Dundas BI truncates the decimal part of some decimal values:

  • 7.9228162514264337593543950335 to 7.92
  • 7922816251426433759354395.0335 to 7922816251426433759354395.03

Dundas BI truncates some floating-point values as follows:

  • 1.000001 to 1.00
  • 122.333444455555 to 122.33

Dundas BI does not support the following FLOAT data type values:

  • SmallestDouble
  • ZeroPlusFraction

For More Information

Share this article: