Show TOC

Component documentationCross-Database Comparison

 

You use this application to compare data sources with a complex structure or hierarchy. The data sources can be in the same system or in different systems. You check whether the data is consistent in the source and target systems, for example, whether updates in the source system have been replicated to the target system. Examples of complex data sources are sales orders with several billing items, or a customer master record containing multiple addresses, partner roles, and bank details.

The data sources must contain the same data logically, but they can have different values once they have been forwarded to a different system, for example, from an ERP system to a CRM system.

Implementation Considerations

You compare databases to check the consistency of data in your systems.

Prerequisites

You have the roles and authorizations required by the application. The following roles are provided for cross-database comparison:

Generic Roles

  • SAP_CDC_ADMIN: Process champion

    Contains full authorization for all cross-database comparison tasks.

  • SAP_CDC_DISPLAY: Display user

    Contains display-only authorizations for various cross-database comparison tasks.

Specific Roles for Typical Cross-Database Comparison Tasks

  • SAP_CDC_OBJECT_MODELER: Object Modeler

  • SAP_CDC_INSTANCE_CREATOR: Instance Creator

  • SAP_CDC_INSTANCE_EXECUTER: Instance Executor

  • SAP_CDC_INSTANCE_ANALYZER: Instance Analyzer

Each role has full authorization for one task and display authorization for the others.

Features

  • You can model the data that you want to compare.

  • You can compare data at any time or schedule regular comparisons.

  • You can display the results in an overview that contains all of the relevant details.

This is a generic application, which means that you can use it to check the data consistency in both ABAP and non-ABAP systems. You can use this application to compare the following data sources:

  • Tables from the ABAP Dictionary

  • Tables that are linked via ABAP Database Connectivity (ADBC)

  • XML and CSV files on a Solution Manager application server or on your local PC

  • Tables in an SAP HANA database

  • OData services

  • SAP Business Information Warehouse

You use the application as follows:

  • Once, to check the consistency of new data

  • When necessary, to check the consistency of existing data

  • Regularly, to monitor important data

You can display the results of the comparison in Business Process Monitoring by configuring the relevant settings in Customizing for Business Process Monitoring.

The cross-database comparison application is included in the business process operations dashboard. You can create a dashboard for specific comparisons. For more information, see Business Process Operations Dashboard.