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
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.
All ODBC databases, e.g. Oracle, Db2, Teradata, MSSQL, Hive, HBase
Hadoop through WebHDFS
Straight data move
Fixed & Comma Separated
File to File
File to DB
DB to File
DB to DB
WebHDFS to DB/File
DB/File to WebHDFS
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