BI Validator
The most comprehensive Testing Automation Solution for BI tools such as Tableau, Oracle Analytics and Microsoft Power BI.
Oracle Corporation uses BI Validator for automating Oracle Analytics testing.
BI Validator Key Features & Benefits
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 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.
Coming soon in July 2020. This release will support regression 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.
Download BI Validator
Get a Competitive Advantage with BI Validator. Download your 30 day free trial now.
BI Validator Resources
Try BI Validator free for 30 days or contact us for a demo.
