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
By 'transaction' I am referring to the I/O (request response) SOAP messages , our Pega application has exposed certain services that are used by consumers.
The local application DB captures all these messages. However we cannot generate reports/ query on this DB directly hence a near real time Operational data store is needed that will copy this data in a separate set up, and that reporting DB will be used for the operational (ie Live ) reporting