IBM Support

Enabling Secondary Database Configuration for BIRT Reports

Question & Answer


Question

How to configure reports to execute from a Reporting Data Base?

Answer

To respond to today’s dynamic Business Environment critical business information needs to be immediately available. This business information can come in various formats, and often includes Enterprise and Ad Hoc reports.

To configure your environment to respond to these dynamic needs, you can have your reports execute from a separate, reporting database. This separate, external database can be a snap-shot of your production, transactional database, and is sometimes referred to as an external, replicated, or reporting database.

Using reporting databases can reduce the load on your production, transactional database and lead to performance improvements. These performance improvements can be especially noticeable for complex reports.

This document details two methods that this can be configured. The first method details how all reports can be configured to execute against a reporting database, and the second method will detail how a portion of the reports can execute against the reporting database.

*Note: This document applies to Maximo QBR (ad hoc) and BIRT Enterprise reports.

Revision History
Revision 4 - December 2013 - Updated diagrams, formatting, and noted that if you configure a reporting database for ALL reports – this includes QBR reports

[{"Type":"MASTER","Line of Business":{"code":"LOB59","label":"Sustainability Software"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"ARM Category":[{"code":"a8m50000000CbCSAA0","label":"Reporting-\u003EAdministration"}],"ARM Case Number":"","Platform":[{"code":"PF033","label":"Windows"}],"Version":"All Versions"},{"Type":"MASTER","Line of Business":{"code":"LOB59","label":"Sustainability Software"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"ARM Category":[{"code":"a8m50000000CbCSAA0","label":"Reporting-\u003EAdministration"}],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"},{"Type":"MASTER","Line of Business":{"code":"LOB59","label":"Sustainability Software"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSRHPA","label":"IBM Maximo Application Suite"},"ARM Category":[{"code":"a8m50000000CbCSAA0","label":"Reporting-\u003EAdministration"}],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]

Document Information

Modified date:
23 February 2023

UID

swg21304936