real time transaction reporting
i need to log and archive all transactions, message exchanges (ie xml instance of a webservices consumed by our Pega application) happening via our Pega implementation into an external reporting DB (OPerational Data Store)
The archival duration is quite long for legal and regulatory purpose. Plus the logging/ archiving has to happen near real time, this is required for certain operations support , that requires tracking the transactions en-masse , generating reports etc etc
Building a reporting portal that would directly query the applications production DB is not something we foresee as an option for performance issues.
Also i dont know if BIX is a valid option to use here, because i understand there the data feeds are in batch mode rather than real time.
I would assume the best way is to establish some triggers on the flow that stores the transactions into an external DB. So that the replica DB can then be used to generate the necessary reports and tracking mechanism
Any suggestions please?