During the training Certified Data & Analytics Tester (Foundation Level) we provide a list of tools that can be used in testing or monitoring Business Intelligence and Data Warehouse products.
Below you can find the first 4 tools of this list, with a short description and links to the tool providers.
We are curious for your experiences when using these tools. What have they brought to your (testing) team? What is a Big Plus of using the tool – and with which features are you less impressed? Is an active user community available, or a help desk that makes a difference? Please let us know, by leaving a message under this post, through the Contact Form, LinkedIn or Twitter.
Note: We are not being sponsored by one of the products or their integration partners.
Data Cleaner is software which is used for Data Profiling.
It can also be used in the process of creating logical and physical test cases as it offers extensive support to analyze and browse through data sets.
Data Cleaner also offers features to clean, transform and export data sets. Rules can be built and reused.
Data Cleaner is free, additional (paid) features are available.
It can be downloaded to your desktop (Windows, Mac) environment from sourceforge or the community website:
SAS Unit is a framework for the unit testing of SAS programs (SAS EG 9.2, 9.3, 9.4).
Amongst others, SAS Unit offers features to assess test coverage of SAS Macros, running tests in batch mode, performance testing of SAS programs.
SAS Unit uses assertions to test the values of macro variables, contents of SAS data sets, relations between data sets, the existence of files incl. log files and – messages.
SAS Unit is open source software and built from SAS macros.
Informatica offers a testing solution called Data Validation Option for PowerCenter (DVO).
The DataValidator for PowerCenter product was originally developed by a company DVO SOFTWARE. It is now available under the Informatica brand as Informatica PowerCenter Data Validation Option.
DVO is a custom tool built on top of Informatica PowerCenter. DVO integrates with the Informatica PowerCenter Repository and Integration Services and enables developers and business analysts to create rules to test the data being transformed during the data integration process.
Informatica mentions the following ETL Testing Use Cases: Production Validation Testing, Source to Target Testing and Application upgrades.
Amongst others, it features:
- An easy-to-use GUI interface to test the rules created for data validations for multiple projects.
- No programming skills needed to create validation tests.
- A repository with reporting capabilities to provide a complete audit trail of all tests and their results.
- Reading data definitions from PowerCenter metadata repositories and can easily deal with data definition changes.
Note that DVO tests data only, not mappings or workflows. Testing mappings is unit testing, which is different from data validation.
As DVO is a commercial product it may be attractive to Informatica Power Center users. At this moment, no free trial seems available (Feb 9, 2020).
Datagaps ETL Validator
Datagaps offers several products, e.g. ETL Validator, BI Validator, Data Flow and Test Data Manager.
The Datagaps ETL Validator comes pre-packaged with an ETL engine capable of extracting and comparing millions of records from multiple data sources while executing test cases in parallel.
ETL Validator also has a Visual Test Case Builder with drag-and-drop capabilities and a Query Builder that enables defining tests without manual typing.
Key features include enterprise collaboration, flat file testing, data profile testing, baselining, data quality testing, and database metadata testing.
Datagaps offers a free 30-day trial.
Next 4 Tools
The next page shows another 4 tools.
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.