Modifying the OpenPages database password in Cognos

If you change the IBM OpenPages® database password, you must update the OpenPages DataSource in IBM® Cognos® Analytics. If you have an Oracle database environment, you must also update the Oracle Native Driver.

Procedure

  1. Ensure that all application servers and reporting servers are running.
  2. Open a browser window and log on to the OpenPages application user interface as a user with administrative permissions.
  3. Click Primary menu Primary menu icon > Analytics.
  4. Click Manage > Administration Console to launch the IBM Cognos Administration page.
  5. Click the Configuration tab.
  6. Click the link for the OpenPages DataSource, and then click OpenPages DataSource.
    The Directory ‎> Cognos ‎> OpenPages DataSource ‎> OpenPages DataSource page is displayed.
  7. Under the Actions column, click the Set properties - OpenPages DataSource icon Set properties icon.
  8. Click the Signon tab.
  9. Click the Edit the signon link.
  10. Type the password of the OpenPages database, and then click OK.
  11. If you use Oracle, do the following additional steps:
    1. Return to the Directory > Cognos page.
    2. Click the link for the Oracle Native Driver, and then click Oracle Native Driver.
      The Directory ‎> Cognos ‎> Oracle Native Driver ‎> Oracle Native Driver page is displayed.
    3. Click the Signon tab.
    4. Click the Edit the signon link.
    5. Type the password of the OpenPages database, and then click OK.
  12. Log out of OpenPages.
  13. Restart all OpenPages application servers.
  14. Log on to OpenPages and open a report to test Cognos.