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.
A comparison is structured as follows:
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.
The Iteration Parameters
area allow you to specify the maximum number of iterations, for example.
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”.
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.