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.

Tricentis BI/Data Warehouse Testing Benefits
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.
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
XML, JSON
Excel
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
HPE ALM/QC
Reporting
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