We are using pega 7.1.9 and with the help of BIX we are generating XML file of work objects and the same file is being transferred to different system for some data analysis.
We have received a new requirement to ensure the data integrity of the XML and check if the data which is being transported as part of XML and the one stored in Pega database is same. I know BIX exports the same data what he have in the database but Unfortunately I couldn't find any OOTB wayout to prove this.
One possible solution I can see is using File listener which can read all the exported XML files and then compare the content from database.
Could someone suggest any alternate way?
***Edited by Moderator Marissa to update platform capability tags****
If the extracts are of 'live' data that can change, doing this would not be possible. A work object could be updated immediately after the extract has run but before this verification step has been completed, regardless of how it is performed, and report that the extract contained incorrect information.
If the data is stale/static and not expected to change, it's possible that your approach would work. Beyond that method, I can't think of another way of doing it.
After generating XML, if you are storing those in DB, then you can use the same DB for reference.
And, if you the XML loaded in DB, then the other approach is to replace the BIX with Trigger and load the data from Pega to the destination DB. That will ensure 100% integrity of data, and can be customize as you want.