Knapsack Pro

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

NBi

http://www.nbi.io/

DbUnit

http://dbunit.sourceforge.net/
Programming language

.NET

Java

Category

Integration Testing, Unit Testing, Acceptance Testing

Unit 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

Dbunit is a Junit extension for unit testing database driven programs

DbUnit has the ability to export and import your database data to and from XML datasets. Since version 2.0, DbUnit can also work with very large datasets when used in streaming mode and can also help you to verify that your database data match an expected set of values
xUnit
Set of frameworks originating from SUnit (Smalltalk's testing framework). They share similar structure and functionality.

No

Yes

It is a JUnit extension which is one of the most widely known members of the xUnit family
Client-side
Allows testing code execution on the client, such as a web browser

No

No

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

Yes its used to test database functionality
Fixtures
Allows defining a fixed, specific states of data (fixtures) that are test-local. This ensures specific environment for a single test

No

N/A

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

N/A

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

N/A

Licence
Licence type governing the use and redistribution of the software

Apache License 2.0

GNU 2.1 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

No

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

No

Other
Other useful information about the testing framework