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.
aka NBi 1.24.0
appVeyor build - nuget link - gpr link
Upgrade-Package NBi.Framework -version 1.24.0
This release 1.24 fix a bug fixes and add some enhancements from new contributors: Davijde and fmms. All these important contributions are really welcome.
aka NBi 1.23.0
appVeyor build - nuget link - gpr link Upgrade-Package NBi.Framework -version 1.23.0
This release 1.23 extends the work on the alterations but also welcome some features and bug fixes from new contributors: lukzas, TheAutomatingMrLynch , saviourofdp or people reporting issues with the toolset and its documentation: FLandgraf, volkerheck, AnimeshRoy86, fdw. All these important contributions are really welcome.
query-scalar
to get a Json value out of a databaseSome new alterations to ease the writing of tests:
union
to create a single result-set from twoduplicate
extend
supporting variables when defining the script for the new valueSome new native transformations to ease the transformation of data
run-once
is brokensave suite
action incorrectly serializes CSV profile propertiesaka NBi 1.22.0
appVeyor build - nuget link - gpr link Upgrade-Package NBi.Framework -version 1.21.0
This release 1.22 extends the work on the testing of data exposed by a REST API. Many new improvements are related to existing features but are now supporting new scenarios.
aka NBi 1.21.0
appVeyor build - nuget link - gpr link Upgrade-Package NBi.Framework -version 1.21.0
This release 1.21 extends the work on the support of data quality checks. The main achievement is the new result-set
now available in the assertions. This new result-set also includes the xml-source
element to source some information from an xml file. This inclusion also adds a few additional features for this source that really helps en enlarge the scope of possibilities. The availability of the element result-set
in the assertions means that you can use all the features such as alterations even in the result-set defined in the assertion equal-to
. Speaking about alterations, we have added a bunch of them for summarization, unstacking (kind of pivot) but also to rename or project some columns. Another new set of features concerns files and paths, NBi is now able to use a set of files as the source of an instance-settling
and some native transformations should help when creating tests with a dynamic set of files. A few other enhancements focus on the native transformations and the usage of variables in many places.
The different packages are now also available on GitHub package repository at https://github.com/Seddryck/NBi/packages
aka NBi 1.21.0-rc0002
appVeyor build - nuget link - gpr link Upgrade-Package NBi.Framework -version 1.21.0-rc0001
This release 1.21 extends the work on the support of data quality checks. The main achievement is the new result-set
now available in the assertions. This new result-set also includes the xml-source
element to source some information from an xml file. This inclusion also adds a few additional features for this source that really helps en enlarge the scope of possibilities. Availability of the result-set means that you can use all the features such as alterations even in the result-set defined in the assertion equal-to
. Speaking about alterations, we have added a bunch of them for summarization, unstacking (kind of pivot) but also to rename or project some columns. Another new set of features concerns files and paths, NBi is now able to use a set of files as the source of an instance-settling and some native transformations should help when creating tests with a dynamic set of files. A few other enhancements focus on the native transformations and the usage of variables at many places.
The different packages are now also available on GitHub package repository at https://github.com/Seddryck/NBi/packages
aka NBi 1.21.0-rc0001
appVeyor build - nuget link - Upgrade-Package NBi.Framework -version 1.21.0-rc0001
This release 1.21 extends the work on the support of data quality checks. The main achievement is the new result-set
now available in the assertions. It means that you can use all the features such as alterations even in the result-set defined in the assertion equal-to. Speaking about alterations, we have added a bunch of them for summarization, unstacking (kind of pivot) but also to rename or project some columns. Another new set of features concerns files and paths, NBi is now able to use files as the source of an instance-settlingand some native transformations should help when creating tests with a dynamic set of files. A few other enhancements concern the native transformations and the usage of variables at many places.
aka NBi 1.20.0
appVeyor build - nuget link - Upgrade-Package NBi.Framework -version 1.20.0
This release 1.20 extends the work on the support of data quality checks. This new release introduces the concept of multiple-instances for a single test definition. It means that you can run multiple the same test but with different parameters slightly affecting what is exactly tested. as an illustration, this new feature offers the opportunity to you create a single test asserting anything on all the files contained in a directory and named following a pattern of dates. To support this new major feature, we've introduced the concept of local variables. These variables are only valid in the scope of a test. The ways to define the possible values of these variables is already supporting a few use-cases such as loop with a sentinel or pre-defined lists. These variables can be used in the test but also to dynamically define traits and categories.
We've continued to work on the lookup assertions. With this release performances of the lookup-exists
have been increased but we also add support to a new assertion checking that the value returned by a lookup is equal to the value contained in the result-set.
Another subset of features including on this releases are intended to improve the support of text files (csv ...). It's now possible to define a custom parser and to handle case where these files are missing.
As usual, this release also comes with some other improvements … especially around native transformations!
This release 1.20 extends the work on the support of data quality checks. This new release introduces the concept of multiple-instances for a single test definition. It means that you can run multiple the same test but with different parameters slightly affecting what is exactly tested. as an illustration, this new feature offers the opportunity to you create a single test asserting anything on all the files contained in a directory and named following a pattern of dates. To support this new major feature, we've introduced the concept of local variables. These variables are only valid in the scope of a test. The ways to define the possible values of these variables is already supporting a few use-cases such as loop with a sentinel or pre-defined lists. These variables can be used in the test but also to dynamically define traits and categories.
We've continued to work on the lookup assertions. With this release performances of the lookup-exists
have been increased but we also add support to a new assertion checking that the value returned by a lookup is equal to the value contained in the result-set.
Another subset of features including on this releases are intended to improve the support of text files (csv ...). It's now possible to define a custom parser and to handle case where these files are missing.
As usual, this release also comes with some other improvements … especially around native transformations!
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 by users … thanks for sharing your ideas!
ignore-case
when comparing two textual valuesall-rows
constraintall-rows
constraints with an expressioncase 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 arrayexpression
includes unexpected attributescsv-profile
(missing-cell and empty-cell)Review of the build and fix issue when deploying NBi with Nuget. If you're not using Nuget you can continue to use the release 1.18.0 (it was a pure metadata issue).