BI Validator

The most comprehensive BI Testing tool / Testing Automation Solution for BI tools such as Tableau, Oracle Analytics and Microsoft Power BI.

Download Now

Oracle Corporation uses BI Validator for automating Oracle Analytics testing – Validating BI Data

BI Validator – BI Testing Tool

Key Features & Benefits

A BI Testing Tool to Automate Testing of BI Platforms such as Tableau, Oracle Analytics, Microsoft Power BI.

Migration Testing

Map & compare reports data while migrating from or to Tableau, Oracle Analytics & Microsoft Power Bi.

Stress Testing

Simulate concurrent user load & gather dashboard performance statistics with varying user load.

Regression Testing

Baseline & compare report / dashboard PDF snapshots to identify data & layout differences.

Upgrade Testing

Compare pre and post upgrade reports or reports across environments for data (CSV) or PDF differences.

Catalog Testing

Baseline and compare web catalog XML to identify changes or compare them across environments.

Functional Testing

Compare data in a report with data from a SQL query on the source or target database.

Adhoc Report

Automatically generate adhoc reports for a given subject area and identify errors.

Performance Testing

Monitor dashboard and report performance periodically in production environment.

Enterprise Collaboration

Test Plans and Test Plans results are shared between team. Tests can be scheduled and results emailed.

Supported BI Platforms

BI Validator – Datagaps BI Testing Tool can be used to automate the testing and CI/CD of these BI platforms.

Supports testing of Dashboards, Reports, Subject Areas & Web Catalog of Oracle Analytics.

Supports testing of Workbooks & Views deployed in Tableau Server and Tableau Online.

Supports regression, performance and functional testing of Power BI Reports, Pages and Visuals.

BI Platforms with Limited Support

Supports testing of Business Intelligence Reports and Documents in SAP BusinessObjects.

Supports testing of Business Intelligence Reports in IBM Cognos.

Supports testing of Business Intelligence Reports and Dashboards in MicroStrategy.

Enables Continuous Integration for BI

By automating the BI Regression and Performance testing, BI Validator enables Continuous Integration for Business Intelligence application development.

Integrates with Jenkins: BI Validator provides a command line interface for kicking of Test Plans. Customers have used this interface to execute tests automatically from Jenkins.
Email Notifications: Key stakeholders are automatically notified by email.
Web Reporting: BI Validator comes with out-of-the-box web reporting. Queries can be executed on the BI Validator repository for additional reporting.

Compare Report Data & UI

BI Validator is integrated with the BI Platform’s REST API and Javascript API to making it easy to automate BI testing. It uses the metadata to completely eliminate the need for custom programming.

Report UI & data Testing: Baseline and compare reports to automatically identify data and UI differences.
Filters & Parameters Testing: BI Validator automatically retrieves Filters and Parameters making it easy to test the list of values displayed in a filter as well as applying them before running the reports.
PDF & Image Comparison: BI Validator compares PDF exports and Image snapshots of the BI dashboard and highlights the differences intuitively.

Easy Wizard Based Test Creation

BI Validator is tightly integrated with the BI tools making it easy to automate BI testing. It uses the BI tool metadata to completely eliminate the need for custom programming.

Regression Testing: Baseline and compare reports to identify data and UI differences.
Stress Testing: Simulate concurrent user load to identify system bottlenecks.
Adhoc Report Testing: Automatically tests different attribute and measure combinations.
Performance Testing: Track report performance trends and issues proactively.
Functional Testing: Compare report data with data from SQL Query.

BI Performance and Stress testing

Upgrade with peace by comparing BI dashboard performance before and after the upgrade.

Performance testing: BI Validator automates performance testing of dashboards by accurately measuring the time taken by BI bootstrap requests and tab-switch events. BI Validator further simplifies the performance recording.
Stress testing: The performance of the BI reports under concurrent user load can be tested using the stress test plan. Stress testing can be very helpful when adding new users or upgrading to a version of the BI Platform.

Perform End-to-end BI Testing

BI Validator helps automate the comparison of report data with database query output thus enabling end-to-end testing of BI reports and dashboards.

Compare Report to SQL Query output: Connect to any ODBC enabled data source and compare BI worksheet data with SQL Query output from the ODBC data source.
BI Tool Migration testing: BI Validator makes it simple to compare the data between reports from different BI tools. Data from one BI Platform can be compared with the data in another BI Platform.
Compare Summary to Detail report data: Compare aggregate metrics in a summary report with data in a detail report.