real time transaction reporting
Dears,
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?
Warm regards
PG
Pegasystems Inc.
US
Can you be more explicit regarding what you mean about a transaction?
Database level transactions - incoming/outgoing SOAP?
Do you really want real time? What does that term mean to you, it is used in many different ways unfortunately.
Infosys
IN
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
Pegasystems Inc.
US
Hi,
We capture the data regarding service performance.
You can report on this data.
Alerts are generated for transactions that exceed a given threshold.
AES / PDC provides reports on this data.
Otherwise you can do what you would like with the data.