Specify the database settings to use for the products that you selected on the Task Selection page.For ease of deployment and simplicity, for a new installation, you can use one database for all products, which is the default when you configure all products at the same time. 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. See Oracle Hyperion Enterprise Performance Management System Installation Start Here.
Database configuration notes:
Ensure that the database is set up as described in “Preparing a Database” in Oracle Hyperion Enterprise Performance Management System Installation Start Here.
When you initially configure, a default database name is displayed. Change the defaults to match the name of the database and user that you already created.
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 Oracle Hyperion Enterprise Performance Management System Certification Matrix (http://www.oracle.com/technology/software/products/ias/files/fusion_certification.html) for a list of supported databases for each product.
During Performance Management Architect database configuration, EPM System Configurator checks that Oracle Database client is installed.
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. See the Oracle Hyperion Enterprise Performance Management System Installation Start Here for character set requirements.
The schemas for the EPM System databases are documented and are available in a ZIP file (EPM Data Models Release 11.1.2.1) posted on the EPM Whitepaper library: Oracle Enterprise Performance Management / Business Intelligence White papers. (http://www.oracle.com/technetwork/middleware/bi-foundation/resource-library-090986.html).
Note the following about database configuration if you are upgrading:
Select “Upgrade database to the current release from...” and select the release number.
When you run the Configure Database task for Performance Management Architect, it may take a long time to complete. Do not interrupt this task while it is running.
The following table describes options for database configuration.
| EPM System Configurator Fields | Description | Your Information |
|---|---|---|
Configure database | Confirm the list of products for which you want to configure the database. The list displayed depends on the products that you initially selected to configure. To create different databases for each product, select only one product at a time and run EPM System Configurator again to configure the database for another product. | |
Connect to a previously configured database/Perform first-time configuration of database/Upgrade existing database to the current release from... | Select whether to connect to a previously configured database, or to configure a new database. Upgrade Note! If you are upgrading from an earlier release, select “Upgrade existing database to the current release from...” and then select the release. Note: This task assumes that you have created the database. If you have not created a database, see “Preparing a Database” in Oracle Hyperion Enterprise Performance Management System Installation Start Here. | |
Database Type | Select the database type. | |
Server | Specify the name of the computer or server hosting the database. For Oracle RAC, specify the VIP name or one of the node names as the server name. | |
Port | Select the default or specify a custom server port number on which the database listens. | |
Service Name or SID, or Database Name | Specify the name of the database. If you are using an Oracle RAC database, specify the RAC service name. For Financial Management with Oracle Database, you can use TNS identifier in tnsnames.ora instead of SID or Service Name. Note that all values in tnsnames.ora are case sensitive. | |
User Name | Enter the database user name. | |
Password | Enter the database user password. Note: If the password changes, reconfigure as described in Changing Repository Passwords and Database Connection Information. | |
Advanced Options (Optional) | Click or select to specify additional information. See Advanced Options for Database Configuration (Optional). You can use this option to configure Oracle RAC. |
When you configure EPM System products to use a database, EPM System Configurator ensures that the database is connected and is a supported database type. For a list of supported databases for this release, see the Oracle Hyperion Enterprise Performance Management System Certification Matrix (http://www.oracle.com/technology/software/products/ias/files/fusion_certification.html).
You can use Windows Authentication for SQL Server connections if you use Microsoft SQL Server database. See Setting Up Microsoft SQL Server Windows Authentication.