Show TOC

Procedure documentationCreating Comparison Tables Locate this document in the navigation structure

 

For the comparison, you select data fields from one table or multiple tables arranged hierarchically after one another. To do this, create comparison tables in which you 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 are read using the foreign keys for the root table.

Prerequisites

You have created a comparison object.

Procedure

  1. Choose   Comparison Object   Edit  .

  2. In the context menu for the comparison table, choose   Node   Add Node   TABLE_SOURCE_1  .

    A dialog box appears.

  3. Specify the data source 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 a binocular icon or a D. You can display details by double-clicking the field. Context fields are not part of the actual comparison scope but can be relevant for you as well. There are two types of context fields::

    • Field is only available in one of the source systems and can not be used as a mapping field.

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

  5. Save your entries.

  6. To create additional tables in the first system, in the context menu for the comparison table, choose   Node   Add Node   TABLE_SOURCE_1  .

  7. To create the data fields for additional tables, repeat steps 2 to 3.

  8. To create tables for the second system, in the context menu for the comparison table, choose   Node   Add Node   TABLE_SOURCE_2   and repeat steps 2 to 7.

  9. Save your entries.

Result

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

Now create the foreign keys.