Reports databases
In some situations, executing reports can impact performance because of the high demand on database processing. To reduce the impact of running reports, you can specify that some reports obtain data from a separate reports database, known as an alternate database, which is a copy of all or part of the PegaDATA database schema.
A reports database can contain only a subset of the tables in the PegaDATA database schema. Only those tables used by a report definition for which you select the Prefer reporting data source if defined option in the Reporting database list need to be mirrored in the separate database. The tables in the separate reports database typically have a similar structure as the PegaDATA database schema. This approach offloads the demand of the production database to the replicated database. You configure mirroring of the data in the tables of the separate database schema by using the database vendor's tools and functions.
Important Considerations
As a lead system architect (LSA), remember the following points when using a reports database:
- The system does not automatically create the tables in a reports database. Instead, you need to work with a database administrator to create the reports database and identify the tables, indexes, and views to include.
- The system does not sync between the reports database and the regular PegaDATA database, so you need to work with a database administrator to set up database replication, which uses a mirroring technique.
- Data pulled out from a report may not contain real-time data. The inclusion of real-time data depends on the mirroring technique that the system uses to sync between the reports database and the regular PegaDATA database.
Whether or not you select the Prefer reporting source if defined option on the Data access tab in one or more report definition rule forms, you can prevent reports from using the reports database by adding the following entry to your prconfig.xml file:
<env name = "database/useReportingDatabase" value="false" />
For more information about how to configure a reports database, see the Specifying a data source for reports article on the Pega documentation site.
Check your knowledge with following interaction:
This Topic is available in the following Module:
Want to help us improve this content?