The following diagram depicts how data flows between P6 EPPM and Primavera Unifier into Primavera Data Warehouse. Depending on your organization's specific deployment, it is possible to have one or many P6 EPPM and/or Primavera Unifier databases loading data into a single Primavera Data Warehouse. This technique of having multiple databases populating a single Primavera Data Warehouse is known as multiple data source. The diagram below shows how data flows between P6 EPPM and Primavera Unifier into Primavera Data Warehouse:
For On-Premises
Use either the PL/SQL-based or ODI-based StarETL process.
Note: The term, StarETL, is used generically, unless it is specific to PL/SQL or ODI.
In the diagram, P6 EPPM contains a set of processes, called Publication Services, that are designed to move, manipulate and store data in specific database views, called the P6 EPPM Extended Schema (Px). These views are used as the source of data for Primavera Data Warehouse. Once the data in P6 EPPM Extended Schema is up-to-date and ready to be moved into Primavera Data Warehouse, the STARETL process is run. After the STARETL process is complete, the data in Primavera Data Warehouse is up-to-date in the current and historical fact and dimension tables.
Primavera Unifier goes through a similar process. Data in the Primavera Unifier database is published (by a set of Publication Services) to the Primavera Unifier Staging tables. Once the data in the Primavera Unifier Staging tables is up-to-date, the STARETL process is run, manually through a command line interface, through a web-based interface, or through a scheduled routine. After the STARETL process is complete, the data in Primavera Data Warehouse is up-to-date in the current and historical fact and dimension tables.
On-premises installations have two alternatives to run the STARETL process, using PL/SQL or ODI.
- A STARETL process using PL/SQL is denoted as STARETL (PL/SQL).
- A STARETL process using ODI is denoted as STARETL (ODI).
The data is now available for access through applications such as Oracle Business Intelligence.