SentryOne Test: Unit Testing Your Data


Free Trial       Buy

The systematic, wizard-based approach of SentryOne Test (formerly LegiTest) makes testing your SQL Server databases simple. You can test your table structures, stored procedures, and more using pre-built actions and assertions to work with your database in minutes. SentryOne Test is integrated into the familiar Visual Studio / SSDT environment, and you can use a graphical designer to create the tests. Because SentryOne Test connects with any database with an ADO.NET provider (which includes ODBC and OLE DB), you can test across multiple databases on different technologies.


SSIS Package Unit Testing | SentryOne Test | SentryOne

Easily conduct SSIS package unit testing

Testing a modern data infrastructure requires more than just testing your database. You need to test the solutions you use to manipulate and move data. SentryOne Test supports testing SQL Server Integration Services (SSIS) packages, enabling you to test an entire package or just a small portion of it.

Because SentryOne Test uses a standard Arrange – Act – Assert approach to testing, you can set up everything necessary for your package to run, and then test it in isolation, without affecting your real data.

Save time with BI and data warehouse testing capabilities

The business intelligence (BI) and data warehouse testing capabilities in SentryOne Test let you create a test case once and then execute it multiple times across a large number of scenarios using input data from a variety of sources (including any ADO.NET source, Salesforce, or REST Web Sources). The dynamic parameterization reduces coding time and allows for greater productivity and efficiency with SentryOne Test.

BI and Data Warehouse Testing | SentryOne Test | SentryOne
Interactive Comparison Editor | SentryOne Test | SentryOne

Easily set up comparison tests

Quickly and easily set up comparison tests for your data with the interactive comparison editor in SentryOne Test. The interactive comparison editor lets you test across ADO.NET, OLE DB, ODBC, and REST sources of data.


SSRS Report Unit Testing

Not only is it important to test more than the underlying code, but you also want to test what your users will see. SentryOne Test supports testing SSRS reports, so you can verify that the data your users see on their reports is what you expect them to see.


SSAS Cube Unit Testing

With support for testing both Tabular and Multidimensional SSAS databases, SentryOne Test helps ensure that everyone sees the same information. Whether you want to confirm that your dimension has the correct members in it or that your calculations are returning the correct results, SentryOne Test has you covered.


Additional Sources

Organizations today work with data from a variety of sources, not just relational databases. With support for working with REST Web Services, relational databases, file-based data and more, SentryOne Test helps to ensure that your complete data-centric solutions are validated. For those unique data sources, SentryOne Test offers extensibility to plug-in your own adapters for other systems.


SentryOne Test Pricing Options


SentryOne Test


Annual Subscription

$69/month ($828 annually)

Licensed per user
Includes annual maintenance



SentryOne Test


Annual Subscription

$499/month ($5,988 annually)

License covers 5 developers, 2 remote agents, 10 view-only users, and annual maintenance


SentryOne Test

Enterprise Licensing

Customized for your environment

Contact us for enterprise licensing options.