The Vital Checks: File to Database Wizard

Use the Vital Checks: File to Database Wizard to test a source file against a target database.

The source file can be any structured text file with data items arranged in fixed-width columns or organized with separators, such as ; or |.

The target database 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: File to Database Wizard to create TestCases for some or all of the following tests:

• Metadata

• Completeness

• Field tests on file level (see chapter "Step 4 - Test Selection")

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

Run Vital Checks: File to Database tests

To perform Vital Checks: File 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: File to Database Wizard: Select a BI folder and click the File to Database icon in the dynamic menu BI Testing.

   Alternatively, you can right-click a BI folder and select Tosca BI->Vital Checks: File to Database from the context menu or press CTRL+W, CTRL+T.

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

4. The Wizard guides you through the creation of TestCase-Design TestSheets: 

   • Step 1 - Source File Definition

   • Step 2 - Target Database Definition

   • Step 3 - Match Tables

   • Step 4 - Test Selection

   • Step 5 - Template Selection

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

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