Test databases

Ready to create database tests? Then this topic is for you. It explains the most important steps to your first database test case.

Supported versions

For information on supported versions, check out the system requirements.

Create database test cases

To create database tests, use Tosca Cloud's standard modules for databases. Standard modules are pre-built modules for common tasks that Tosca Cloud provides out of the box.

You can find the database modules in the left panel of the test case building area, under Modules.

Before you start

Create an ODBC connection to your database, so Tosca Cloud can access it at runtime. If you want to test multiple databases, create ODBC connections for them all.

Create your test case

Once you have your ODBC connections in place, you can create a test case to steer your databases.

Please choose your use case:

To create such a test case, follow these steps:

  1. Create a new, empty test case.

  2. Add the module DB Expert to your test case and fill out the resulting test step. This allows you to perform the following actions:

    • Open a connection to a database.

    • Run an operation on the database with one SQL statement.

    • Close the connection.

To create such a test case, follow these steps:

  1. Create a new, empty test case.

  2. Open a connection to a database. To do so, add the module DB Open Connection to your test case and fill out the resulting test step.

    To open more than one connection, add the module multiple times.

    The connection you opened last is the active connection. For example, if you open connection 1, 2, and 3, then connection 3 is the active connection. If you want to start your test case with an operation on connection 2, use the module DB Current Connection to switch active connections.

  3. Run an operation on the database via SQL statement with the module DB Run SQL Statement. To run multiple operations, use the module multiple times.

  4. Close the connection with the module DB Close Connection. If you opened multiple connections, use the module multiple times to close them all.

What's next

You've just created your first database test case. Well done!

Next up: do a test case trial run. Trial runs help you find and fix issues, so you can make your tests as stable and reliable as possible.

Once you're happy with your test case, pack it into a playlist, so you can run your tests in earnest.