Show TOC

Object documentationComparison

 

To compare data sources, you must create a comparison. A comparison contains information about the source systems as well as the connection information for the initial comparison. You specify the type of data source that contains the data that you want to compare. Data sources can be, for example, ABAP or non-ABAP systems.

Structure

A comparison is structured as follows:

Global Instance Parameters

The Global Instance Parameters area contains all of the generic data for your comparison.

  • Name and description

  • Extraction strategy

    The following strategies are available:

    • Default: Individual data selection in each source system

      The data to be compared is selected independently in each system.

    • Use keys of source system 1 to select in source system 2

      The data block to be compared is first extracted from system 1. Then the keys identifying each record are used to extract the required data from system 2.

    • Use keys of source system 2 to select in source system 1

      The data block to be compared is first extracted from system 2. Then the keys identifying each record are used to extract the required data from system 1.

    • Execute comparison in one system

      The data is compared in one system only. This extraction strategy is relevant for internal database comparison and for comparison in an SAP HANA database.

  • Data sources from which the data to be compared is to be extracted

    For more information, see Data Sources in Cross-Database Comparison.

  • Comparison block size

    Block size used to read the data for the comparison. You can use this value for the comparison depending on your system performance.

  • Maximum number of differences

    Number of differences detected after which the system terminates the comparison.

Iteration Parameters

The Iteration Parameters area allow you to specify the maximum number of iterations, for example.

Comparison-Specific Filters

The Comparison-Specific Filters area lists the filters that are available for comparing databases. You can specify values for the variable filters that you create in the comparison. This allows you to create multiple comparisons and specify different filter values for each. For example, one comparison could have Country = “DE” and another comparison could have Country = “US”.

Data Model for Comparison

The Data Model for Comparison area contains the tables and fields in the source systems that are to be compared. The data model is displayed as a graphical user interface on which you can choose the compared tables and fields from both databases and define mapping between those fields. For more information, see Creating Data Models.