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). For ease of deployment and simplicity, you can use one database repository for all products (with the exceptions noted below). When you configure multiple products at one time using Oracle's Hyperion Enterprise Performance Management 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, roll-back 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.
