Enabling Secondary Database Configuration for BIRT Reports

Technote (FAQ)

Question

How to configure reports to execute from an 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 a variety of formats, and often includes Enterprise and Ad Hoc reports. To configure your environment to respond to these dynamic needs, you may want your reports execute from a separate, reporting database. This separate, external database may 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 will detail two methods that this can be configured. The first method will detail 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.