You are here: Reporting > How to use a reports database

How to use a reports database

Execution of reports by application users or by agent processing may provide a substantial source of database processing database demand in some cases. To reduce the performance impact of report execution, you can direct that some reports obtain data from a separate reports database, which is a copy (a replicated mirror) of all or part of the live PegaRULES database.

The reports database must have the same structure (tables and columns ) of the live database, but may contain only a subset of the tables needed for reporting, and may contain slightly stale data.

To use a reports database:

  1. Work with a database administrator to create the reports database, identifying the tables, indexes, and views that need to be included.
  2. Work with a database administrator to set up the replication, which may use master-slave or other mirroring techniques.
  3. Create a database data instance (Data-Admin-DB-Name) for the reports database and establish connectivity.
  4. Update Database Table instances to identify this database in the Reports Database field.
  5. Check the Use alternate database check box on the Data Access tab of Report Definitions (or on the Content tab of list views or summary views) that are to extract data from the reports database.

To disable use of a reports database even when the Use alternate database option is selected, add the following entry to your prconfig.xml file.

<env name = "database/useReportingDatabase" value="false" />

The default value is true.

As an alternative to the prconfig.xml file, you can use Dynamic System Settings to configure your application.
See How to create or update a prconfig setting.

NoteUse of a reports database is less helpful in situations where JVM memory, CPU processing, or network traffic are more

For List View and Summary View reports, to force the use of a reports database even for standard reports (for which the Use alternate database? option is not checked), set the pyUseAlternateDb parameter to true when calling the Rule-Obj-ListView.ShowView or Rule-Obj-SummaryView.ShowView activities.

Definitions reports database
Related topics About Database Table data instances
Standard rules Atlas — Standard Database Table instances

UpSysAdmin category