How To Add An Additional Datasource To The Data Warehouse (STAR) Schema (Doc ID 1925117.1)

Last updated on JULY 13, 2017

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.

Goal

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.

 

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms