Show TOC

Component documentationCross-Database Comparison Locate this document in the navigation structure

 

You use this application to compare data sources with a complex structure or hierarchy. You can also do this across different systems. By doing so, you check whether the data in the source and target systems is consistent, for example, whether updates in the source system have been correctly 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.

Even though the data sources must contain the same data logically, 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 can:

  • Model the data you want to compare

  • Compare data at any time or schedule regular comparisons

  • Display the results in an overview containing all 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 Connectivitiy (ADBC)

  • XML files on a Solution Manager application server

You use the application as follows:

  • Once to check new links between data sources

  • When necessary to check existing links

  • Regularly to monitor important data

You can display the results of the comparison in business process monitoring. To do so, configure the relevant settings in Customizing for business process monitoring.

Implementation Considerations

You use this application because you suspect that there are inconsistencies between systems and want to check the data consistency of your systems.

Prerequisite

  • You have the roles and authorizations required to use the application.

Integration

The cross-database comparison is a separate application and therefore independent of other applications. No further components are required to use this application.

Features

  • You create comparison objects. In a comparison object, you specify which data from which data sources you want to compare and create filters.

  • You create comparison instances. A comparison instance contains a comparison object. In a comparison instance, you specify which specific systems are to compared using which filter settings.

  • You schedule comparisons. By doing so, you specify when and how often you compare the relevant data sources.

  • You display the comparison results. By doing so, you can see where the inconsistencies are in the data sources.