For Classic Planning applications, you can use the wizard to update the data source name, description, relational database, and details for the relational database and Essbase server.
To edit data sources:
In the Classic Application Wizard, click Manage Data Source.
Specify the application database details:
Server: Server hosting the database
Port: Port. For information about default ports and how to change them, see Oracle Hyperion Enterprise Performance Management System Installation Start Here.
Database: Database name
User: Database username
Password: Database password
For advanced users only: Optionally, create the data source using a custom URL instead of the information in the Server and Port fields. Click Custom, and then enter the URL for the data source in Connection URL.
For detailed information on configuring the database with the EPM System Configurator and examples of URLs, see the Oracle Hyperion Enterprise Performance Management System Installation and Configuration Guide.
Entering a custom URL overrides previous connection settings for server and port. To remove the custom URL and return to the previous server and port settings, clear the Custom check box.
Click Validate Database Connection, and fix any issues that are noted.
Specify Essbase server details:
Server: Server name
User: Server username
Password: Server password
Click Validate Essbase Connection, and fix any issues that are noted.
Optional: To set the application to Unicode mode, select Unicode Mode.
For more information, see the Oracle Essbase Database Administrator's Guide.
At the message that the data source was updated successfully, click the X to close the message.
Use the EPM System Configurator to select an instance (cluster) to use for the application. See the Oracle Hyperion Enterprise Performance Management Architect Administrator’s Guide or Online Help.