Preparing a Database

Before you install and configure most Oracle Enterprise Performance Management System products, create a database using a supported RDBMS.

In general, the database should be in the same data center as the EPM System deployment. To prevent timeout issues when configuring with EPM System Configurator, you cannot locate a database in a remote location where there is latency.

For simplicity and ease of deployment, you can use one database repository for all products (with the exceptions noted below). In most cases, 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:

• Oracle Hyperion Planning – Each Planning application should have its own repository.

• Oracle Data Relationship Management. See the Oracle Hyperion Data Relationship Management Installation Guide.

The following products must use the same database schema:

• Oracle Hyperion Financial Close Management

• Oracle Hyperion Tax Governance

• Account Reconciliation Manager

• Supplemental Data Manager

• Tax Supplemental Schedules