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:
-
Data Integrity connections for tests you create with the Tosca DI Wizards
-
Database connections for your database tests
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:
-
Tests you create with the Vital Checks: File to Database and Vital Checks: Database to Database Wizard
-
Tests you create with the Field Tests: Single Database and Field Tests: Database to Database Wizards
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:
-
Tests you create with the Metadata comparison Module
-
Tests you create with the Row by Row Comparison Module
-
Tests you create with the DI DB Expert Module