Show TOC

Procedure documentationGenerating Extractors for a Comparison

 

After you have created the comparison and the comparison tables, and you have assigned the table relationships within and between the systems, you generate the extractors for the comparison. When you generate the extractors, the system creates additional elements that are required for the comparison, such as RFC-enabled functions in the case of ABAP systems or SQL statements in the case of SQL-based extractions. You can test the SQL statements in the application before you generate them.

If you change the settings in a comparison, you must generate the comparison again so that the extractors take into account the changes in the systems.

When the application generates the extractors, it tests the connection and validates the comparison. If errors occur, the generation is terminated.

Note Note

If you have saved your comparison data in an XML or CSV file in SAP Solution Manager, do not generate the extractors because the system reads the data directly from the file. You can test the specified path.

End of the note.
Automatic Generation of Extractors

Depending on the source type used in your comparison, you can configure the system in such a way that extractors are generated automatically when you save the comparison. To enable automatic generation, set the Extractor Generation option to Automatic Generation Only or Both Automatic and Manual Extractor Generation in Customizing for SAP Solution Manager under Start of the navigation path Capabilities (Optional) Next navigation step Business Process Operations Next navigation step Data Consistency Management Next navigation step Cross-Database Comparison Next navigation step Define Cross-Database Comparison Source Types End of the navigation path.

Prerequisites

  • You have created a comparison.

  • You have created comparison tables.

  • If required, you have created foreign keys for the tables in a system.

  • You have assigned the data fields in the systems to one another.

  • For data sources that generate a function module, you have specified the connection that is to be used to create the initial function module.

Procedure

  1. Test the connection by choosing Start of the navigation path Validation Next navigation step Test Connection to Source 1 End of the navigation path or Start of the navigation path Validation Next navigation step Test Connection to Source 2 End of the navigation path.

  2. Check the comparison by choosing Start of the navigation path Validation Next navigation step Validate Parameters and Data Model End of the navigation path.

  3. Generate the extractors by clicking Generate Extractors and choose whether you want to generate the extractors for source 1, source 2, or both.

  4. Proceed as follows depending on the type of data source you are using:

    • If your data source generates an extractor that in turn generates a function module (for example, SAP ABAP System (RFC to Generated Extractor)), specify a transport request to transport your function module and save. If you do not want to transport the function module, leave the field empty.

      Create the function module in a development system and test it together with the function group. Then transport the function module to a test system.

      To execute the comparison in other systems, transport the function module to the systems that contain the tables that you want to compare. If you have created a function module in multiple systems, create multiple comparisons to compare the tables in the various systems.

    • If your data source generates an extractor that in turn generates an SQL statement (for example, Remote Database (Using ADBC)), check the SQL statement and the count statement.