Tricentis Tosca

BI/Data Warehouse Testing

One of the biggest challenges with BI and Data Warehouse projects is guaranteeing the integrity of the data—and ensuring that any errors are detected as early as possible. Tricentis BI and Data Warehouse testing ensures data integrity faster, more rigorously, and more reliably than manual ETL testing and report verification.

Tricentis Tosca - BI Data Warehouse End to End Testing

BI/Data Warehouse Testing Benefits

Improve costs, decrease testing effort, and speed your time-to-market with Tricentis Tosca’s resilient test automation capabilities by BI/data warehouse testing.


Detect Data Integrity Issues Earlier

Expose data integrity issues as they’re introduced—before they impact your data-driven decisions.


Make the Right Business Decisions

Invest in the best business decisions for your company based on verified data integrity.



Expecting business analysts to catch all critical issues while reviewing reports is risky, slow, and burdensome.



Formalize and document your data quality efforts to satisfy regulatory requirements (e.g., BCBS 239, Basel III and 4, SOX).


Increase Data Confidence

Save time and money by rapidly pinpointing root causes to ensure accurate reporting.

A few months after our new BI/data warehouse testing approach launched, people finally started trusting the applications. They’re highly used now, and they have become a vital tool in making critical business decisions.

Head of Enterprise Quality Assurance Team  – Global Payments Processor

Automated End-to-End Data Integrity Testing

Automated End-to-End Data Integrity Testing

Detect Errors Early

Tricentis Tosca’s pre-screening wizard identifies when field and table structures have changed (e.g., new or removed tables or fields, modified precision or length). If a change is detected, tests can be automatically updated.

When working with file sources, you can now test to ensure that:

  • The data loaded into the staging tables is correctly structured and formatted
  • Verify that the field level data meets your requirements (e.g., allowed values or patterns).
Pre-screening with Tosca BI/Data Warehouse

Verify Data Quality and Processing

Data acquisition (ETL) errors are found through Tosca BI’s Vital Checks wizard. Tests for metadata changes, completeness, uniqueness, integrity and reconciliation are then automatically created, saving time and making test maintenance easy.

The following test types can be created out-of-the-box:

  • Completeness tests: Enable count comparisons between source and target
  • Uniqueness tests: Check for the uniqueness constraint defined in the database
  • Referential integrity tests: Check that complete records have been copied and that technical and logical integrity is maintained
Vital Checks with Tosca BI/Data Warehouse

Automated Reconciliation Testing

Tosca’s automated reconciliation testing performs complete source-to-target comparison—including file-to-database and database-to-file comparisons. These reconciliation tests can perform algorithmic or complete row-by-row comparisons of two data sets from two disparate systems.

These tests can be associated with your transformation requirements—providing instant insight into which transformation requirements have been tested and whether those tests succeeded or failed.

Ensure Data Integrity in BI Reporting Tools

Tricentis Tosca’s Model-based Test Automation automates testing of BI reports by providing checks for fully-laid-out reports or analyzing the underlying data that is fed into the reports (e.g., Cognos, Tableau, QlikView, etc.). For example, a test might open a Cognos report in a web browser, retrieve a value from a table in the report, and then compare it with a result retrieved from a database query.

Tricentis customers who have used Model-based Test Automation to automate their BI report testing have achieved automation rates of up to 90+%.

Profile Tests

Profiling tests validates data for logical consistency and correctness from a business perspective. For example, you can automatically check that insurance contracts can only be canceled if all outstanding invoices have been paid.

Profiling functionality can also be used to monitor how many data values of a certain type exist at any given point, alert you to “out of range” values and use results to create a trend profile over time.

Extensive Technology Support

Supported Databases

All ODBC databases, e.g. Oracle, DB2, Teradata, MSSQL, Hive, HBase

Hadoop through WebHDFS

OLAP & OLTP Databases

Test Examples

Straight data move

Data transformations

Report validation

File Support

Fixed & Comma Separated



Sample Comparison Operations

File to File

File to DB

DB to File

DB to DB

WebHDFS to DB/File

DB/File to WebHDFS

More Support

Any CI tool


Reporting Vendors, e.g. Cognos, Tableau, Qlik, SAP BusinessObjects


Message Queues