Try OpenEdge Now
skip to main content
Core Business Services - Security and Auditing
Auditing : Querying and Reporting on Audit Data : Audit data querying and reporting : Reporting from multiple audit databases
Reporting from multiple audit databases
In some scenarios, it might be necessary to report against multiple audit databases, for example, to report on data in both the short-term operational database (application database) and a designated, audit archive database. If this is a requirement, then the reports used should be developed to accommodate extracting data from multiple data sources and aggregating the results at run time. If you are adopting this model, take care to resolve duplicates; it is possible that the same audit data can exist in each of the databases, which would ordinarily be resolved as part of the archive into a central reporting database.