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).

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.

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.