The Vital Checks: Database to Database Wizard

Use the Tosca BI Vital Checks: Database to Database Wizard to test data copies or data moves from one layer to another.

Your databases can come from one of the following sources:

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

    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.

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

You can use the Vital Checks: Database to Database Wizard to create TestCases for some or all of the following tests:

  • Metadata

  • Completeness

  • Referential Integrity

  • Uniqueness

  • Nullness

If you use an ODBC connection to connect to your source and/or target, your selections in the Connection Manager determine which tests you can create.

Run Vital Checks: Database to Database tests

To perform Vital Checks: Database to Database tests, follow the steps below:

  1. Ensure that your Vital Checks 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. Open the Vital Checks: 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->Vital Checks: Database to Database from the context menu or press CTRL+W, CTRL+D.

Open the Vital Checks: Database to Database Wizard via the context menu

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

Create BI TestSheet properties

  1. The Wizard guides you through the TestCase creation: 

  2. If you have performed Step 4 - Template Selection in its entirety, you are now ready to execute your tests.

    If you have not performed Step 4 - Template Selection in its entirety, you must take additional steps. For more information, see chapter "Step 4 - Template Selection".