Define a Data Integrity connection

Define a Data Integrity (DI) connection in the Tosca DI Connection Manager if you intend to use this connection for 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.

To define your connection, follow the steps below:

1. Create a new connection and specify the DI connection type as described in chapter "Create a new connection".

2. Enter the required connection information in the General section.

3. Make sure that the Include Metadata check box is selected.

4. The Connection Manager can fetch the required table, column, and constraint information in one of the following ways:

   • Directly from the ODBC driver

   • From SQL statements you provide

   Validate this information as described in chapter "Validate driver information" and chapter "Validate SQL statements".

5. Save your connection.

Test your connection

To check whether the given information lets you connect to your data source, click on Test connection.

This check does not take SQL statements into account. A connection test can be successful even if there are errors in your SQLs statements. If you want to check your SQL statements, you can validate them.

Change existing connections

For information on how to change existing connections, see chapter "Change existing connections".