Define connections in the Tosca DI Connection Manager

Database and Tosca Data Integrity (DI) tests require you to define a connection to the source of your data. This connection contains necessary information for your tests, such as data source type, user credentials, or table metadata.

The Tosca DI Connection Manager allows you to create and centrally manage the following connections: 

It saves your connections to the  Configurations section in Tosca Commander.

This means you don't have to define a connection for every TestCase you create. Instead, you can reference the connections stored in the Configurations section.

You can define an unlimited number of ODBC or SQLite connections in the Connection Manager. If users in a multi-user workspace have different rights on the same data source, you can define the same connection with different specifications multiple times. Use different connection names and different user credentials.

For information on how to create a new connection with the Connection Manager, see chapter "Create a new connection".

Use Data Integrity connections

You can create a Data Integrity connection using an ODBC data source or ODBC connection string.

Data Integrity connections include metadata. This means that included SQL statements tell the Tosca DI Wizards how to read all relevant tables, columns, and constraint information from the database system you intend to use.

You can use Data Integrity connections in the following tests:

Use Database connections

You can create a Database connection using an ODBC data source, ODBC connection string, or SQLite connection string. Database connections do not include metadata.

You can use Database connections in the following tests: