Configuring and Running P6 EPPM Publication Services

Previous TopicNext TopicContents

The ETL process relies on data from the P6 EPPM Extended schema and related Publication Services. You must run this process prior to running the ETL process. The Publication Services enable users to control what data to calculate and store, and how often the data is updated.

The logical views that are part of the P6 EPPM Extended Schema are used to populate the P6 Reporting Database via the ETL process.

For the ETL process to access P6 EPPM data, you must configure and run the P6 EPPM publication services before running the ETL process.

To configure the P6 EPPM publication services:

  1. Login to P6.
  2. Click the Administer menu and select Application Settings.
  3. On the Application Settings pane, click Services.
  4. On the Services page, in the Publication section, set how much and how often data updates in the P6 EPPM Extended Schema. The reporting databases use the:
  5. Select the Enable Publish Projects option and adjust the remaining options in this section as necessary for your data.

    Once you've enabled publication, projects that qualify for publication based on your settings will begin to publish to the P6 EPPM Extended Schema.

  6. Once all necessary projects publish, run the P6 EPPM Global Scheduled Services:
    1. Click the Administer menu and select Global Scheduled Services.
    2. Set each service to run immediately.

      See the P6 Help for more information on the P6 Publication Services.

      Notes:

      • You must run the publication services before you set up the P6 Reporting Database.
      • After you complete the above steps, you should configure the Global Scheduled Services to run at regular intervals to work in conjunction with any changes to the P6 EPPM data.


Legal Notices
Copyright © 1999, 2014, Oracle and/or its affiliates. All rights reserved.

Last Published Friday, January 31, 2014