Knapsack Pro

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

NBi

http://www.nbi.io/

Spock

http://spockframework.org/
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

Spock is a testing and specification framework for Java and Groovy applications

Spock has a highly expressive specification language, and due to its JUnit runner, Spock is compatible with most IDEs, build tools, and continuous integration servers.Spock is inspired from JUnit, RSpec, jMock, Mockito, Groovy, Scala, Vulcans among others
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

Spock tests front-end components and functionality by unit testing individual classes and functions
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

Spock tests back-end components and functionality by unit testing individual classes and functions
Fixtures
Allows defining a fixed, specific states of data (fixtures) that are test-local. This ensures specific environment for a single test

No

Yes

Spock contains four methods for setting up environments :setup() (run before every feature method), cleanup() (run after every feature method), setupSpec() (run before the first feature method), cleanupSpec() (run after the last feature method)
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

You can use the fixture methods to setup environments for groups of tests.
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

Apache License 2.0

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

Yes

Spock has inbuilt mocking capabilities and has no need for external libraries
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 create suites manually in spock
Other
Other useful information about the testing framework