Show TOC

Procedure documentationCreating Comparisons

 

A comparison contains information about the systems with the data sources to be compared. You specify the type of data source that contains the data that you want to compare. The data can be in different types of data source, such as ABAP or non-ABAP systems.

Prerequisites

At least two systems with a data source each have been set up.

Procedure

  1. On the Comparison or Comparison Overview tab, click Create.

  2. Enter a name for your comparison and press Enter.

  3. Enter a description for your comparison.

  4. Choose one of the following extraction strategies:

    • 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.

    Depending on the extraction strategy, the available data source types are displayed for selection.

  5. Specify the type of data source in which the data is stored. For more information, see Data Sources in Cross-Database Comparison.

  6. Click Start of the navigation path Validation Next navigation step Test Connection to Source 1 End of the navigation path and Start of the navigation path Validation Next navigation step Test Connection to Source 2 End of the navigation path to test the connection.

  7. Enter the following information for all of your data sources:

    • Block Size: The block size is used to read the data for comparison. You can improve your system performance by changing the block size for each of your source systems here.

      Note Note

      Defining block sizes speeds up data extraction. However, the cross-database comparison cannot perform a binary full-block comparison if the block sizes for the source system are different. This is relevant only if you expect a near 100% consistency. Usually, it is OK to increase the system load of SAP Solution Manager if a changed block size reduces the database and network load of a source system instead.

      End of the note.

    • Max No. Differences: The number of differences detected after which the system terminates the comparison.

      Enter 0 if you want the comparison job to be executed regardless of how many differences are detected. Use this setting to prematurely terminate an incorrectly configured comparison that returns an error for every data record.

  8. Save your entries.

Result

You have created a comparison and must now create the data fields that you want to compare with one another (see Creating Data Models).