Primavera Data Warehouse requires an Oracle Database instance.
Set up and configure an Oracle Database instance and supporting tablespaces. If the server where Primavera Data Warehouse will be installed does not have an Oracle Database instance, install and configure an Oracle Database client on the server machine where the STARETL process will run.
Oracle recommends the following:
- Primavera Data Warehouse instance reside on a different physical machine than both the P6 EPPM instance and/or the Primavera Unifier instance. This minimizes the impact that Primavera Data Warehouse has on the performance of P6 EPPM and/or Primavera Unifier instance server. Refer to the Primavera Analytics Planning and Sizing Guide for more information.
- Due to the volume and potential size growth of the Oracle Database instance, dedicate this instance to Primavera Data Warehouse.
- Configure this instance with database partitioning enabled.
If you choose not to enable database partitioning, certain features of Primavera Data Warehouse will not function properly including daily level activity history and multiple data source support.
Before installing Primavera Data Warehouse, the instance CHARACTER SET and COLLATION for Primavera Data Warehouse must match the instance CHARACTER SET and COLLATION that is set on the P6 EPPM and/or the Primavera Unifier instances.
Note: Do not run the Primavera Data Warehouse instance in ARCHIVELOG mode.