The Field Tests: Database to Database Wizard

Use the Field Tests: Database to Database Wizard to compare data from a source database to data from a target database.

These databases can come from one of the following sources:

• an Open Database Connectivity (ODBC) connection pointing to any database vendor, including Hadoop

• a DDL (data definition language) text file that contains all table, column and constraint information

Tosca BI offers various field tests, such as comparing length, average or sums between source and target. For more information, see chapter "Available field tests for the Field Tests: Database to Database Wizard".

To use ODBC connections in your Tosca BI tests, you must first configure them in the ODBC Data Source Administrator as described in chapter "Create an ODBC connection to a database (ODBC data sources)". If you run a 64-bit operating system, you can use both 32-bit and 64-bit ODBC connections.

Run Field Tests: Database to Database tests

To perform Field Tests: Database to Database tests, follow the steps below:

1. Ensure that your Field Tests TestCase templates are located in the _Tosca BI Templates folder.

   If you want to use a template that you have created manually, make sure to move it to the _Tosca BI Templates folder.

2. In the TestCase template you are going to use for your tests, fill out the TestStepValues DSN, UserID and Password.

   Alternatively, you can create test configuration parameters which have to be set once (see chapter "About test configuration parameters").

3. Open the Field Tests: Database to Database Wizard: Select a BI folder and click the Database to Database icon in the dynamic menu BI Testing.

   Alternatively, you can right-click a BI folder and select Tosca BI->Field Tests: Database to Database from the context menu or press CTRL+W, CTRL+G.

4. In the Tosca BI TestSheet properties dialog, click Yes.

5. The Wizard guides you through the TestCase creation:

   • Step 1 - Source Database Definition

   • Step 2 - Target Database Definition

   • Step 3 - Match Tables

   • Step 4 - Select Field Tests

   • Step 5 - Additional Options

6. If you have performed Step 5 - Additional Options in its entirety, you can now run your tests.

   If you have not performed Step 5 in its entirety, you must take additional steps before you can run your tests. For more information, see chapter "Step 3 - Additional Options".

Tosca BI offers parallel execution for specific TestCases. For more information on which tests you can run in parallel and how to do so, see chapter "Run Tosca BI tests in parallel".