BI Validator's Data Compare test plan to compare the report data with data from a SQL Query. Users can perform end-to-end validation of the data shown in the reports by comparing the report data with the data from the Source database or the Target database (data warehouse). 

Assuming that you already have a BI Connection created, the next step is to create a DB Connection. This article provides the details of creating a DB Connection so that it can be used in the Data Compare test plan. 

Connecting to ODBC Data Source

You can connect to any data source that support ODBC using the ODBC DSN option. Most of the data sources such MySQL, Hadoop, Redshift support ODBC DSN connection. As an example, we will show you how to create an ODBC connection to Redshift database.

Below are the steps: 

  1. Install the ODBC driver for the Data Source on the computer where you are running BI Validator.

    Below is a screenshot of the Redshift ODBC Driver after installation in the ODBC Data Source Administrator window:

  2. Create an ODBC DSN Entry for your Data Source

    Below is an example of an ODBC connection to Redshift:

  3. In BI Validator, mouse hover the DB Connections menu icon and select ODBC.  BI Validator supports the connections to following databases out-of-the-box: Oracle, SQL Server, and PostgreSQL.
    Note: Sometimes, the ODBC driver for the database will not be loaded and you might not be able to save the connection. To overcome this error, you may need to run BI Validator as administrator and create the required ODBC connection. 

Connecting AWS EMR using ODBC DSN: