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.
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.
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
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).
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
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+%.
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
All ODBC databases, e.g. Oracle, DB2, Teradata, MSSQL, Hive, HBase
Hadoop through WebHDFS
OLAP & OLTP Databases
Straight data move
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
Any CI tool
Reporting Vendors, e.g. Cognos, Tableau, Qlik, SAP BusinessObjects
REST, SOAP APIs