My Oracle Support Banner

How to Add an Additional Datasource to the Data Warehouse (STAR) Schema (Doc ID 1925117.1)

Last updated on MARCH 25, 2022

Applies to:

Primavera Data Warehouse - Version R3.1 and later
Primavera Analytics - Version R3.1 and later
Information in this document applies to any platform.


The goal of this document is to provide instruction for creating additional datasources to one STAR schema.

Document Notes:
  • The P6 Analytics and Star Installation and Configuration Guide (r3.1 through r15.1) does not contain complete steps for adding an additional datasource to the Star. The instruction noted within this document are intended for Data Warehouse releases through 15.1 only.
  • The instruction noted within this document will provide example of adding datasource 2 to an existing Star schema.  In such a configuration, there will be 2 distinct P6 EPPM databases populating 1 Star database.
  • Before adding any of these data sources, ensure that all of the P6 Publication services have been run on each data source.
  • All Steps noted below must be performed in the ordering provided.



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 Using Data Warehouse r15.2 and Later Releases
 Using Data Warehouse (STAR) r3.1 through r15.1

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.