ORAYLIS BI.Quality

Project Description:

ORAYLIS BI.Quality is a testing suite for BI solutions makes it easier to develop in an agile environment. The suite is based on NUnit and supports quite a lot of different testing methods.

Having made subtle changes or after refactoring their ETL chain, BI developers can rely on automated tests whether their processes still produce the expected figures - both using SQL and MDX.

For example it can automatically compare result sets from different sources, for example SQL and MDX. This allows to define test scenarios the system must meet after the OLAP cube has been loaded. For migration projects it can still run queries against the old system and compare the results with the new system. As everything can be automated, tests can be run on a regular basis (for example directly after every cube processing) to make sure, that all facts are really complete and correct.

Version 2.0.1 is now released
Plans for Release 3.0.0

Test-Scenarios

  • Structure tests
  • Data-availability tests
  • ForeignKey tests
  • Unknown Member tests
  • Constraint tests
  • Compare tests

NUnit is required

Screenshots

Test without Error
Successful test run

Test with error
Test run with errors

HTML Output
Output in HTML

Features

  • Automatic query tests against SQL Server via OLEDB
  • Automatic query tests against Analysis Services via OLEDB
  • Unlimited number of connections, referenced by name
  • Compare table result against row count
  • Record table results
  • Compare current table result against a former result
  • Compare fields of a result set against a static value +/- tolerance
  • Internal configuration tests
  • User documentation incl. quick start
  • Sample project based on Adventure Works
  • Easy deployment
  • Grouping of test cases in categories (eg. Integration tests, Long running tests, etc.)
  • Automatic tests from command line and output as XML
  • HTML report as mail target

Last edited Nov 4, 2010 at 9:52 AM by apolko, version 24