Show TOC

Procedure documentationCreating Data Models

 

For the comparison, you select data fields from one or more tables arranged hierarchically and consecutively. To do this, create comparison tables in your data model, and specify the data sources and data fields that you want to compare.

Regardless of the type of data source, the objects that you compare are represented as tables in this application.

You can select as many tables as you want for each system. You join the tables to one another using foreign keys (see Creating Foreign Keys). You assign foreign keys in the root table or the higher-level child table to the primary keys in the child tables. First create the root table: The first table that you create in a system automatically becomes the root table. Subsequent tables that you create become child tables. When the systems are compared, the information from the child tables is read using the foreign keys for the root table.

Prerequisites

You have created a comparison (see Creating Comparisons).

Procedure

  1. Open your comparison and click Edit.

  2. In the Data Model for Comparison area, right-click to open the context menu and choose Start of the navigation path Element Next navigation step Add element to table source 1 End of the navigation path.

    A dialog box appears.

  3. Enter the table that you want to compare and select the data fields that you want in include in the comparison.

  4. Save your entries.

    The data sources and data fields that you have selected are displayed graphically.

    Context fields are marked with the binoculars icon or a D. You can display details by double-clicking the field. Context fields are not in the comparison scope, but can be relevant for you as well. There are two types of context fields:

    • Field is only in one of the source systems and cannot be a mapping field.

    • Field is in both source systems but always has different contents (for example, created-by fields); it is not used as a comparison field.

  5. Repeat the above steps to add any other tables that you want to compare to source system 1.

  6. Save your entries.

  7. To create tables for the second system, right-click to open the context menu and choose Start of the navigation path Element Next navigation step Add element to table source 2 End of the navigation path.

  8. Enter the table that you want to compare and select the data fields that you want in include in the comparison.

  9. Save your entries.

Result

You have selected the tables and data fields that you want to compare.

Now create the foreign keys.