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   Maintenance Mode Data Model   Maintain Fields and Tables  .

  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.

  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.