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.
Navigate to the DB Connection tab (next to the BI Connection) in the left side tree in BI Validator. Click on the '+' sign to add a new DB Connection. BI Validator supports Oracle, SQL Server and ODBC connections out of the box.
Connecting to an Oracle Database
The screenshot below shows a sample connection to the Oracle database.
Connecting to SQL Server Database
Below is a screenshot of a sample SQL Server connection that uses SQL Server Authentication:
When using Windows Authentication, leave the user name and password blank.
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.
Below are the steps:
- 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:
- Create an ODBC DSN Entry for your Data Source
Below is an example of an ODBC connection to Redshift:
- Create a new DB Connection in BI Validator using the 'ODBC' option
Connecting AWS EMR using ODBC DSN: