Skip to main content

Enabling Secondary Database Configuration for BIRT Reports


Technote (FAQ)


Question

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

Answer

You may need your Version 7 reports to 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 the your live, transactional database and lead to performance improvements. These performance improvements can be especially noticeable for complex reports.

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

Note: This document applies only to BIRT Reports in the Maximo ® Base Services 7 Releases.

Additionally, you can find more details on other reporting features by accessing the Maximo Report Wiki Pages available here or the Maximo Report Reference Materials located here

Revision History
Revision 3 - January 2010 - Format Updates


secondary database configuration for reporting_rev3.pdf

Cross reference information
Segment Product Component Platform Version Edition
Systems and Asset Management Tivoli Asset Management for IT All 7.1.1
Systems and Asset Management IBM Maximo Asset Management Essentials All 7.1.1
Systems and Asset Management IBM Maximo Asset Management Essentials All 7.1

Rate this page:

(0 users)Average rating

Copyright and trademark information

IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.

Rate this page:


(0 users)Average rating

Add comments

Document information

IBM Maximo Asset Management

BIRT


Software version:
7.1.1, 7.5


Operating system(s):
Windows


Reference #:
1304936


Modified date:
2010-01-28

Translate my page

Content navigation