1. Installation and Configuration Guide
  2. Configuring EPM System Products in a New Deployment
  3. EPM System Configurator Task Reference
  4. Configure Database

Configure Database

Specify the database settings to use for the products that you selected on the Task Selection page. You can specify database connection information for each product separately, or use the same settings for multiple selected products.

For ease of deployment and simplicity, for a new installation, you can use one database for all products. 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.

Database configuration notes:

  • Ensure that the database is set up.

    If you have not already created the database, see Preparing a Database.

  • A database type might not be available if one of the selected products doesn’t support it. In this case, configure this product separately. See the Certification Matrix (https://www.oracle.com/middleware/technologies/bi-foundation/hyperion-supported-platforms.html) for a list of supported databases for each product.

  • If you are configuring an additional instance of Oracle Hyperion Financial Data Quality Management, Enterprise Edition for scaleout purposes, during database configuration, when you are prompted whether to drop and re-create the tables or reuse the existing database, select Reuse the existing database.

  • When configuring Oracle Hyperion Financial Management in a distributed environment, you must select the Configure Database task for Financial Management on every machine hosting the Financial Management Application Server.

    If you are configuring an additional instance of Financial Management, when you are prompted whether to drop and re-create the tables or reuse the existing database, select Reuse the existing database.

  • If you are configuring an Oracle database, EPM System Configurator checks that the database was created with the correct character set. If not, you are prompted to correct it.