Selecting the Database

The database must be connected, and must be a supported database type. For information on supported databases, see the Oracle Hyperion Enterprise Management System Installation Start Here guide.

Note:

Ensure that Planning is registered with Shared Services and is deployed to an application server before configuring the database. If you are configuring a database for Planning and a previously configured database is detected, you are prompted to create a new database or reuse the existing database. If you are configuring a product upgrade, the fields on this page are read-only except for the password.

You can select an option to set the application to Unicode mode. Unicode-mode applications support multiple character sets, and Essbase uses UTF-8 encoding to interpret and store character text. Character-based artifacts in Unicode-mode applications, such as member and alias names, can include characters from different languages. For more information, see the Oracle Essbase Database Administrator's Online Help.

  To select the database:

  1. In the Data Source wizard navigation frame, click 2. Database Details.

    To start the wizard, see Starting the Data Source Wizard.

  2. If the Database Type field is activated, select MS SQL Server, Oracle, or IBM DB2.

  3. Add or update the database configuration details:

    • Server: The server that hosts the database.

    • Port: A port number. For information about default ports, see the Oracle Hyperion Enterprise Performance Management System Installation Start Here guide.

    • Database: The name of the database.

    • User Name: The database user name.

    • Password: The database password.

  4. Optional: Click Test Connection to test the connection to the data source.

  5. Click Next, and continue with Configuring the Essbase Server.