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.


What is BI/Data Warehouse Testing?

BI/data warehouse testing involves the creation, execution, and maintenance of tests that automatically verify data quality across all BI/DW stages (including the reporting layer). BI/data warehouse testing is designed to prevent data integrity issues by exposing the problem early and automatically.

Data Quality Testing with Tricentis Tosca

Tricentis BI/Data Warehouse Testing Benefits

Catch data integrity issues early

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

Avoid manual testing

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

Comply with regulatory requirements

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

BI/DWH Testing Data Sheet

Learn how Tricentis can help your business protect data integrity.

An Introduction to Data Warehouse Testing

Learn why and how to get started with data warehouse testing—including an overview of what's involved and best practices for developing an effective data warehouse testing strategy.

Comprehensive BI/Data Warehouse Test Automation


Prescreening 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 test to ensure that the data loaded into the staging tables is correctly structured and formatted, as well as verify that the field level data meets your requirements (e.g., allowed values or patterns).


Vital Checks for Database to Database Transfers

Vital Checks expose data acquisition (ETL) errors to help ensure the validity of the data on the target system. Using metadata and constraint information extracted from the source database, Tricentis Tosca verifies that the range of tables (and records within) have been copied successfully. 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

Reconciliation Testing

Reconciliation tests can perform algorithmic or complete row-by-row comparisons of two data sets from two disparate systems. For example, you can compare remote files to a database query, local files to data within a Hadoop cluster, or any combination of these options. 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.


Profiling 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. Or, you could validate whether a certain business process completes within a specified time period. 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.


BI Report Testing

Report testing verifies report creation and content from the end-user perspective. Tests can also check access restrictions and report generation performance. Report tests might involve a combination of UI and API tests, depending on how the reports are accessed. 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.


Supported Technologies

Supported Databases

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

Hadoop through WebHDFS

Test Examples

Straight data move

Data transformations

Report validation

File Support

Fixed & Comma Separated



Sample Operations

File to File

File to DB

DB to File

DB to DB

WebHDFS to DB/File

DB/File to WebHDFS

Miscellaneous Support

Any CI tool



Tricentis Tosca supports automating the GUI of the common reporting vendors (such as Cognos, Tableau, Qlik, SAP BusinessObjects) as well as accessing the report data via API to verify and reconcile content