When you are building a BI system, you want to test more than just the database. SentryOne Test helps you fully implement business intelligence testing across the entire Microsoft BI stack. Build an SQL Server Integration Services (SSIS) package test to ensure your ETL meets your requirements.
Validate the measures in your SQL Server Analysis Services (SSAS) cubes to balance to your data warehouse, as well as validate that your SQL Server Reporting Services (SSRS) reports are showing the right totals. SentryOne Test brings the ability to put all your tests into a common framework and get a true picture of the readiness of your BI solutions.
Simplify data warehouse testing
SentryOne Test helps you create data warehouse tests that validate the data in your warehouse. Use the wizards to build automated tests that verify the numbers in your data warehouse match the numbers in your source system. You can also create data warehouse unit tests to validate the stored procedures and other query logic that might show in a report.