P6 EPPM Publication Services Overview

If you are using P6 EPPM as a data source, Primavera Data Warehouse relies on data from the P6 EPPM Extended Schema and related publication services. Configure the P6 EPPM publication services and run them successfully prior to running a STARETL process. The publication services are responsible for moving and transforming P6 EPPM data into the P6 EPPM Extended Schema.

There are two types of publication services within P6 EPPM that need to be run in order to ensure that the data in the P6 EPPM Extended Schema is up-to-date prior to running the STARETL process.

Global Scheduled Services: Global services are responsible for moving global/enterprise level data (users, security, codes, or hierarchies) from the P6 EPPM base tables into the Extended Schema.
Global scheduled services include the following:
- Publish Enterprise Data Service calculates and publishes enterprise-level business objects containing calculated and denormalized fields, including cost accounts, currencies, calendars, codes, funding sources, resource teams, role teams, timesheet dates, UDFs and more. Enterprise data does not usually change frequently, so consider scheduling this service to run less frequently.
- Publish Enterprise Summaries Service calculates and publishes EPS-level spread data for currently published projects in a given EPS. Depending on the spread interval you intend to use, EPS-level spread data can change frequently, so it might be appropriate to consider scheduling this service to run more frequently.
- Publish Resource Management Service calculates and publishes the resource hierarchy, resources, resource rates, resource limits, role rates, resource role assignments, and resource security. Resource management data does not usually change frequently, so consider scheduling this service to run less frequently.
- Publish Security Service publishes users, the OBS, and security profiles and calculates security for the P6 Extended Schema. Security data does not usually change frequently, so consider scheduling this service to run less frequently.
Project Level Service: This service updates data in the P6 EPPM Extended Schema for each project. This service can be configured to run at specific time intervals or based on a number of changes interval. This service processes projects sequentially depending on the Publication Priority assigned to each project. Projects with a lower value for Publication Priority are published before those with a higher value for Publication Priority.

Complete the following steps to load P6 EPPM projects to P6 Extended Schema before running the ETL process for CIC:

Related Topics