Updating the Primavera Analytics Repository with the Primavera Data Warehouse Schema Owner Password with Oracle Analytics Server
The third step in configuring the repository in Oracle Analytics Server is to enter the Primavera Data Warehouse schema owner password.
Note: If you are already logged into the Oracle Analytics Server Administration tool, skip steps 1 through 5 of this procedure.
Complete the following steps to enter the Primavera Data Warehouse schema owner password:
- Launch the Oracle Analytics Server Administration tool.
- Select File, Open, Online.
- Select your Oracle Analytics Server DSN.
- Enter the repository password (by default, Admin123).
- Enter the WebLogic administrator username and password.
- With the repository open, do the following to update the password:
- In the Physical section on the right, right-click the physical connection source (by default, Oracle Primavera P6 Data Warehouse) and select Properties.
- Select the Connection Pools tab.
- Double-click the Oracle Primavera P6 Data Warehouse Connection Pool.
- On the General tab, on the same row as username, enter the password for the Primavera Data Warehouse schema owner.
- Click OK and re-enter the password to confirm the change.
- Click OK to close the Connection Pool - Oracle Primavera P6 Data Warehouse Connection Pool window.
- Select File, Save to save the repository.
Note: If you are prompted to check file consistency, click No.
Remain in the Oracle Analytics Server Administration application and continue to the next topic.
Related Topics
Configuring the Primavera Analytics Repository with Oracle Analytics Server
Verifying the STARDW Alias with Oracle Analytics Server
Verifying the Primavera Data Warehouse Schema Owner with Oracle Analytics Server
Updating the Primavera Analytics Repository for P6 EPPM URL Links with Oracle Analytics Server
Reload Files and Metadata with Oracle Analytics Server
Last Published Thursday, December 14, 2023