Changing EPM System Product Repository Database Connection Information and Passwords

  To change the connection information for the repository for EPM System products other than Shared Services:

  1. If you are changing the password, using the database administration console, change the password of the user account that was used to configure the EPM System product database.

  2. Stop EPM System Web applications and services and processes.

  3. Start EPM System Configurator, and under the product you want to configure, select Configure Database.

  4. On the “Configure Database” page, select Connect to a previously configured database.

  5. If you are changing only the password, specify the existing database and user, and enter the new password for the user account that was used to configure the EPM System product database.

    If the database has moved to another server, you can also change the database host and port. If needed, you can also change the database user.

    You cannot change the database type.

  6. When you are prompted to choose whether to Drop and recreate tables or Reuse the existing database, select Reuse the existing database.

  7. Continue the configuration, and click Finish when you are done.

  8. Restart the Web application and services and processes.

Note:

For ERP Integrator registered with Performance Management Architect, if you change the password for the ERP Integrator database schema, then do the same for the Oracle Hyperion Financial Data Quality Management ERP Integration Adapter for Oracle Applications data source.