Update Cognos data in the test environment

You can update Cognos® data in the test environment by using the Cognos backup utility.

Before you begin

Before you run the Cognos backup utility (OPCCBackup) make sure to verify the following:

  • You have access to both the source and target database servers.
  • The <CC_user> has Read and Write permission to the OP_DATAPUMP_DIRECTORY.

    Where: <CC_user> is the name of the Cognos content store database user.

    If not, you must grant the proper permissions on both the production and test servers to the <CC_user> account on the datapump directory as follows:

    1. Log on to a machine with SQL*Plus and access to the database server.
    2. Run the following SQL command as the system user:
      grant read,write on directory OP_DATAPUMP_DIRECTORY to <CC-user>;
  • Full permission is granted to the <CC_HOME>/tools/bin folder on the target Cognos server.