To configure the Primavera Data Warehouse database connection in the STAR Database Connection screen, complete the following steps:
- In the Oracle Database Connection section:
- In the Host Name field, enter the server machine name or IP address where you installed the Primavera Data Warehouse instance.
- In the Port Number field, enter or verify the port number for this instance. The default port number is 1521.
- Enter the Service Name or SID for your Primavera Data Warehouse instance.
- In the Database Administrator Account (DBA) section:
- In the Username field, enter or verify the user name that has DBA privileges for the Primavera Data Warehouse database. The default name is SYSTEM.
- In the Password field, enter the password for the DBA user.
- In the Create STAR user account section:
- In the Username field, enter or verify your Primavera Data Warehouse user name. This user will own the Primavera Data Warehouse tables. This username can be any name you choose. The recommended value is STARUSER.
- In the Password and the Confirm Password fields, enter a password for the Primavera Data Warehouse user.
- Deselect the TDE option if you want to disable Transparent Data Encryption (TDE) for all database tables.
Note: Transparent Data Encryption (TDE) is enabled by default.
- In the Select Custom Tablespaces section:
- If you are using non-default tablespace names, select the Use Non-Default Tablespaces option.
- Select the tablespaces you are using from the Data Tablespace, History Tablespace, and Temporary Tablespace lists.
- Click Next.
The configuration utility tests that the connection information is valid by attempting to connect to the database instance. If the test connection fails, ensure you have entered all the information correctly and try again. If the test connection succeeds, the Configuration utility proceeds to the Primavera Data Warehouse Connection screen. See Configuring ETL Settings to continue the configuration process.