Before you install and configure most EPM System products, you must create a database using a supported RDBMS (Oracle Database, Microsoft SQL Server, or IBM DB2).
EPM System supports 32-bit as well as 64-bit versions of all supported databases; however, the version of the database should match the operating system. For example, a 64-bit database version can be used only on a 64-bit operating system.
For simplicity and ease of deployment, you can use one database repository for all products (with the exceptions noted below). When you configure multiple products at one time using EPM System Configurator, one database is configured for all selected products.
Caution! | To use a different database for each product, perform the “Configure Database” task separately for each product. In some cases you might want to configure separate databases for products. Consider performance, rollback procedures for a single application or product, and disaster recovery plans. |
The following products and product components require unique databases:
Performance Management Architect interface data source
Extended Analytics for Financial Management and Extended Analytics for Strategic Finance
Planning – Each Planning application should have its own repository.
Performance Scorecard
FDM – Use an Oracle Database instance exclusively for FDM.
For information about the FDM database, see the Oracle Hyperion Financial Data Quality Management DBA Guide.
Data Relationship Management. See the Oracle Hyperion Data Relationship Management Installation Guide.
If you are upgrading from a previous release of EPM System products, see the Oracle Hyperion Enterprise Performance Management System Installation and Configuration Guide for information about replicating or reusing databases.