NBi is a testing framework (add-on to NUnit) for Business Intelligence and Data Access. The main goal of this framework is to let users create tests with a declarative approach based on an Xml syntax. By the means of NBi, you don't need to develop C# or Java code to specify your tests! Either, you don't need Visual Studio or Eclipse to compile your test suite. Just create an Xml file and let the framework interpret it and play your tests. The framework is designed as an add-on of NUnit but with the possibility to port it easily to other testing frameworks.
This release 1.19 extends the work on the support of data quality checks. This new release introduces the support of tests around referential integrity. You can now assert if a result-set has all its foreign-keys pointing to a reference result-set (or the other way). Also interesting to note that we're expanding the usage of variables, they are now usable in more places and can be overridden in the configuration file. Another new feature, to be develop further in the next releases, is the scoring of a result-set. This feature lets you define a percentage of quality, clearly stating if a result-set is fit for purpose or not, in place of reporting a number of rows violating a predicate. This last feature is not documented in the RC.
As usual, this release also comes with some other improvements. Fifty percent of them were ideas submitted users … thanks for sharing your ideas!
case cross
is now supporting a join on multiple columnscolumn-index
and type
to expression
elementtransformation
elementcross
doesn't work when one the columns contains an arrayThis release 1.18 introduces the notion of extensions. An extension is the possibility to plug additional dlls to query other kind of database engines. Three extensions have been developed at the moment and more to come. The currently available extensions target graph databases and more specifically are Gremlin (Tinkerpop) for any database compatible with Tinkerpop\Gremlin (such as Azure Cosmos DB, Tinkerpop Server, OrientDB or JanusGraph) and connecting through the Gremlin.Net driver, Neo4j using the Bolt driver and supporting Cypher queries and finally Cosmos DB (SQL and Graph API) supporting the native API. Note that for Cosmos DB, If your database is a graph database, it's recommended to use the Gremlin.Net driver and so the Gremlin extension and not the Cosmos DB extension.
This NBi release is downloadable from there and each extension can be downloaded form the links above. To install them just download the binaries and copy them (overwrite if needed) to the same folder than NBi. Don't forget to register them in the config file and to update the binding redirections as explained there.
Version: 1.18.0.1
any-of
Or
and And
now stops to evaluate the remaining predicates as soon as one of the condition is true
(for Or
) or one is false
(for And
). Especially usefull if some of your values are null
This release 1.18.0-RC2 introduces the notion of extension. An extension is the possibility to plug additional dlls to query other database engine. Development of Neo4j and Cosmosdb (SQL and Graph API) are currently running and beta are already available.
This release is downloadable from there.
Version: 1.18.0-RC2
This release 1.17 introduces a new use-case for NBi: Data Quality Rules Engine. More than this, it's also the first step to the version 2.0 and it introduces the first elements of the syntax 2.0 but is still fully supporting the elements of the syntax 1.0!
This release is downloadable from there.
Version: 1.17.0.8 aka v1.17
This release 1.17-RC1 introduces a new use-case for NBi: Data Quality Rules Engine. More than this, it's also the first step to the version 2.0 and it introduces the first elements of the syntax 2.0 but is still fully supporting the elements of the syntax 1.0!
This release is downloadable from there.
Version: 1.17.0.3 aka v1.17-RC1
This release 1.16 introduces two new constraints (unique-rows and subset-of/superset-of), a bunch of new predicates to use with all/no-rows and some native transformations plus some small enhancements and a bug fix.
This release is downloadable from there.
Version: 1.16.0.2 aka v1.16
This release 1.15 introduces a small amount of new features to assert the result-set returned by a query and a few bug fixes or improvements. It also supports SSIS 2017RC1
This release is downloadable from there.
Version: 1.15.0.1 aka v1.15 (same binaries than the beta version)
This release 1.14 introduces some new and disruptive features to assert the result-set returned by a query and a few bug fixes or improvements.
This release is downloadable from there.
Version: 1.14.0.3 aka v1.14
If you're using genbiL, you should also check to the side project genbiL-tmBundle. The focus of this project is to support syntax highlighting for genbiL.
Main ideas for release 1.15 (or next)
This release 1.14 introduces a small amount of new and disruptive features to assert the result-set returned by a query and a few bug fixes or improvements.
This release is downloadable from there.
Version: 1.14.0.1 aka v1.14-beta