Tricentis Tosca

Automate Data Integrity testing across your complete data landscape

Data integrity issues cost organizations $15M annually, on average (Gartner). And $3.1T overall is wasted finding and fixing data issues each year (HBR). Stop these data issues in their tracks—with an automated, integrated process that covers your complete data landscape.

Tricentis Data Integrity is the industry’s top end-to-end data testing solution for enterprise organizations. Rely on our advanced automation to eliminate data integrity issues before they can compromise your decision making.

Tricentis Tosca - BI Data Warehouse End to End Testing

Tricentis Data Integrity 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 DI’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

Oracle, DB2, MS SQL, Teradata, Hadoop, SAS, SAP (ECC, BW, and HANA), Snowflake, Postgres, Azure, Google, AWS, Mongo, Orient, Couchbase, NEO4j….including 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/CD tool


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


Message Queues