Testing of Data & Analytics environments is increasingly supported by test tools. At Verified, we wonder what your experience is with one of these tools – and if you propose certain tools that have helped you ?
Please let us know, by leaving a message under this post, through the Contact Form, LinkedIn or Twitter or contact us in any way you prefer. If you like, we can reply with a listing of more than 15 tools that should help testers and analysts in testing and quality issues.
Note: We are not sponsored in any way by the tool providers.
Querysurge is a commercial product made for testing ETL, where comparison of source and target tables is the main object.
It offers dashboards, query wizards, various prefabricated queries for comparison of data, text search etc.
A trial version is available: https://www.querysurge.com/compare-trial-options
Note that for BI Testing, an add on is available. Connectors are available for Cognos, Tableau, SAP Business Objects, Microstrategy and OBIEE. Features include comparison of reports when upgrading or migrating, querying report meta data.
iCEDQ is a commercial ETL Test Tool, which runs in the cloud, on premise or hybrid.
It offers a rule engine module, which features:
- Checksum rules (e.g. row counts)
- Reconciliation rules (e.g. missing records)
- Validity rules (SCD Type 2, Format Checks)
- Script rules (e.g. execute DML/DDL, pre and post actions).
iCEDQ currently integrates with Jenkins, TFS, Jira, HP ALM and ServiceNow.
iCEDQ offers trials through their website:
QualiDI focuses on ETL testing from sources to targets.
It provides data validation and comparison of data, has a centralized repository of requirements, test cases, test results and has a API trigger based automation of test execution.
There is Business Rules Engine, enabling non-technical users to write rules instead of queries. It integrates with Bitwise Test Data Management Suite for providing test data.
QualiDi is a commercial product, a 30 day trial is available
SSIS Tester is offered by bytesoftwo and focuses on testing Microsoft SSIS.
SSIS Tester is a testing framework built on top of SQL Server Integration Services. It enables you to test packages, tasks and precedence constraints. It supports two types of tests:
- unit tests
- integration tests.
SSIS Tester helps you to develop you ETL process in the test driven manner and to identify errors early in the development process. It offers “data taps” and fake source or targe components, enabling developers to work independently. Tests target packages or particular tasks.
More information on SSIS Tester on MSDN can be found here:
SSIS Tester offers a free 21-day trial version:
Next 4 Tools
In a few weeks I will publish the next Blog post, asking for new experiences. Thanks for reading this post!
Omdat deze tekst gericht is op een internationaal publiek, heb ik ervoor gekozen om de bovenstaande tekst in het Engels op te stellen. Stelt u prijs op een vertaling naar het Nederlands? Neemt u dan aub contact met ons op.