How To Add An Additional Datasource To The Data Warehouse (STAR) Schema
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.
The goal of this document is to provide instruction for creating additional datasources to one STAR schema.
- 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.
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