Understanding the Integration Integrity Utility

The Integration Integrity Utility (the Utility) provides configurable end-user tools to help monitor and maintain high-quality data in separate PeopleSoft CS and PeopleSoft HCM databases. As with most integration, unplanned scenarios can sometimes leave data out-of-sync. The Utility provides methods to detect, report, and resynchronize data where necessary.

Data Integration Assumptions and Practices

Using the Integration Integrity Utility to regularly monitor data provides assurance that your data is being synchronized properly between separate PeopleSoft CS and PeopleSoft HCM databases.

A valuable feature of the Utility is the ability to resync data if discrepancies are found; however, it is important to remember some general assumptions and guidelines when using this Utility:

• Oracle integration design models for separate CS and HCM databases (Owner/Subscriber, Subscriber Only) assume that shared data is replicated exactly between both databases.

• The Utility is not designed to replace standard Application Messaging. Errors that may occur in Integration Broker Queue processing should be properly investigated and the message transaction resubmitted for proper handling.

• If data discrepancies appear regularly on comparison reports, there may be a systemic problem that should be investigated, and corrected.

• Data discrepancies may be the result of a variety of root causes. Investigation into the issue is critical.

• Data comparisons should be run during periods of low activity, and when transaction changes are not expected to occur frequently.