Test Automation for Oracle Analytics

The most comprehensive testing automation solution for Oracle Analytics – OBIEE, OAC, OAS, OTBI.

Successfully used by Oracle Corporation for Oracle Analytics testing internally.

Oracle Analytics Testing Features & Benefits

Automate Functional, Regression, and Stress Testing of Oracle Analytics Dashboards, Reports, Subject Areas & Security.

Dashboard & Report Testing

Baseline and compare Dashboard & Report snapshots to identify data and layout differences.

Performance Testing

Monitor dashboard and report performance periodically in production environment.​

Stress Testing

Simulate concurrent user load and gather view performance statistics with varying user load.​

OAS Upgrade Testing

Compare pre and post upgrade dashboards / reports or across environments.

Subject Area Testing

Perform adhoc report testing by automatically generating thousands of logical queries.

Functional Testing

Map and compare report data with data from database SQL query to validate the reports.

OAC Migration Testing

Compare data of reports generated by OBIEE, OAC and OTBI to validate Oracle Cloud migration.

Security Testing

Baseline and compare the catalog object permissions to identify report access issues.

Enterprise Collaboration

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

Enables Continuous Integration for Oracle BI

By automating the BI Regression and Performance testing, BI Validator enables Continuous Integration for Oracle Analytics report 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.
  • Prompts Testing:BI Validator automatically retrieves dashboard prompts making it easy to test the list of values displayed in a prompts as well as applying them.
  • PDF Snapshot Comparison:BI Validator compares PDF snapshots of the dashboards and highlights the differences intuitively.

OA Performance and Stress testing

Upgrade with peace by comparing Oracle Analytics (OAC & OAS) dashboard performance before and after the upgrade.

  • Performance testing:BI Validator automates performance testing of OA dashboards by accurately measuring the time taken by initial page load and complete load events.
  • Stress testing: The performance of the OA dashboards and 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 Oracle Analytics.

Perform End-to-end OA testing

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

  • Compare Report to SQL Query output: Connect to any ODBC enabled data source and compare OA report 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 OBIEE, OAC, OAS, OTBI, Business Objects, Cognos and Tableau can be compared with each other.
  • 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 14 day free trial now.