Updating the Primavera Analytics Repository with the Primavera Data Warehouse Schema Owner Password with OAS

The third step in configuring the repository in Oracle Analytics Server (OAS) is to enter the Primavera Data Warehouse schema owner password.

Note: If you are already logged into the OAS Administration tool, skip steps 1 through 5 of this procedure.

Complete the following steps to enter the Primavera Data Warehouse schema owner password:

  1. Launch the OAS Administration tool.
  2. Select File, Open, Online.
  3. Select the OAS DSN for your OAS.
  4. Enter the repository password (by default, Admin123).
  5. Enter the WebLogic administrator username and password.
  6. With the repository open, do the following to update the password:
    1. In the Physical section on the right, right-click the physical connection source (by default, Oracle Primavera P6 Data Warehouse) and select Properties.
    2. Select the Connection Pools tab.
    3. Double-click the Oracle Primavera P6 Data Warehouse Connection Pool.
    4. On the General tab, on the same row as username, enter the password for the Primavera Data Warehouse schema owner.
    5. Click OK and re-enter the password to confirm the change.
    6. Click OK to close the Connection Pool - Oracle Primavera P6 Data Warehouse Connection Pool window.
    7. Select File, Save to save the repository.

      Note: If you are prompted to check file consistency, click No.

Remain in the OAS Administration application and continue to the next topic.

Related Topics

Configuring the Primavera Analytics Repository with OAS

Verifying the STARDW Alias with OAS

Verifying the Primavera Data Warehouse Schema Owner with OAS

Updating the Primavera Analytics Repository for P6 EPPM URL Links with OAS

Updating the Primavera Analytics Repository for Primavera Unifier URL Links with OAS

Reload Files and Metadata with OAS


Last Published Tuesday, December 20, 2022