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.
You compare databases to check the consistency of data in your systems.
You have the roles and authorizations required by the application. The following roles are provided for cross-database comparison:
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.
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.
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.