Skip to main content

Table of Contents

Setting up reports database


Only available versions of this content are shown in the dropdown

In some cases, running reports can impact performance because of high demands on database processing. To reduce the performance impact of running reports, you can specify that some reports obtain data from a separate reports database, which can be a copy of all or part of the PegaRULES database.

The reports database must have the same structure (tables and columns) as the PegaRULES database. A reports database might contain only a subset of the tables needed for reporting, and might contain old data.

  1. Work with a database administrator to create the reports database, identifying the tables, indexes, and views to include.

  2. Work with a database administrator to set up database replication, which uses a mirroring technique.

  3. Create a database data instance ( Data-Admin-DB-Name ) for the reports database and establish connectivity. For more information, see Creating database data instances.

  4. Update the Database Table data instances to identify this database on the Database tab in the Reports Database field.

  5. In the report definition rule that obtains data from the reports database, on the Data Access tab, select the Prefer reporting data source if defined option in the Reporting database field.

    To require the use of a reports database for standard list view and summary view reports when the Prefer reporting data source if defined option is not selected, set the pyUseAlternateDb parameter to true when calling the Rule-Obj-ListView.ShowView or Rule-Obj-SummaryView.ShowView activities.

  • Disabling usage of a reports database

    You can disable a report from obtaining data from a reports database, even if the Prefer reporting data source if defined option is selected on the report definition rule form.

  • Configuring dynamic system settings

    As a best practice, set system configuration settings by using dynamic system settings data instances. For example, you can use a dynamic system settings to configure which fields are available in full-text search. Dynamic system settings are stored in the Pega Platform database and are used by all nodes that share that database.

Did you find this content helpful?

100% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Ready to crush complexity?

Experience the benefits of Pega Community when you log in.

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us