NBi vs Behat comparison of testing frameworks
What are the differences between NBi and Behat?

NBi

http://www.nbi.io/

Behat

https://docs.behat.org/en/latest/
Programming language

.NET

PHP

Category

Integration Testing, Unit Testing, Acceptance Testing

Functional/Acceptance Testing

General info

NBi is an open-source framework for testing Business Intelligence solutions or validating data quality.

NBi helps you to create tests targeting your databases, cubes, etls and reports. Tests are written in xml using an intuitive syntax therefore thereis no need of any development language. Nbi tests target databases, cubes, etls and reports

Behat is an open source Behavior-Driven Development framework for PHP.

Behat uses the StoryBDD subtype of behaviour-driven development (the other subtype is SpecBDD); This means the tests we write with Behat look rather like stories than code. It is inspired by Ruby's Cucumber
xUnit
Set of frameworks originating from SUnit (Smalltalk's testing framework). They share similar structure and functionality.

No

No

Client-side
Allows testing code execution on the client, such as a web browser

No

Yes

To enable Behat to test a website, you need to add Mink and a browser emulator (selenium maybe, though slow) to the mix. Mink methods are the connector between Behat and an extensive list of available drivers, and they provide a consistent testing API.
Server-side
Allows testing the bahovior of a server-side code

Yes

Nbi tests Business intelligence software which retrieve, analyze, transform and report data therefore it targets databases, cubes, etls and reports and you can natively connect to any database supporting OleDb or ODBC connection

Yes

Behat can be used for Data Integrity Testing to verify that database operations are functioning properly
Fixtures
Allows defining a fixed, specific states of data (fixtures) that are test-local. This ensures specific environment for a single test

No

Yes

One can use the 'Doctrinefixturesbundle' to create the required fixture loaders and load them in our Behat scenarios when required, using the 'BeforeScenario' hook.
Group fixtures
Allows defining a fixed, specific states of data for a group of tests (group-fixtures). This ensures specific environment for a given group of tests.

No

Yes

Behat allows for group fixtures
Generators
Supports data generators for tests. Data generators generate input data for test. The test is then run for each input data produced in this way.

N/A

By use of third party libraries like moodle-behat-generators
Licence
Licence type governing the use and redistribution of the software

Apache License 2.0

MIT License

Mocks
Mocks are objects that simulate the behavior of real objects. Using mocks allows testing some part of the code in isolation (with other parts mocked when needed)

Yes

You can create your own mock objects

By using third party libraries like Mock and Prophecy
Grouping
Allows organizing tests in groups

Yes

Yes, Nbi comes with a solution to automate, as much as possible, the creation of the test-suites through its user interface, named GenBI

Yes

You can use tags to group features and scenarios together, independent of your file and directory structure
Other
Other useful information about the testing framework