About the ODSETL Process

Previous TopicNext TopicContents

The ODSETL process provides data movement between the P6 EPPM extended database and the ODS database. You can schedule the process to run at regular intervals, using operating system-specific scheduling tools, to ensure up-to-date data freshness.

Decide when and how often to update the databases from the P6 EPPM extended schema. The database will undergo a full refresh when it is updated. Oracle recommends that you run the data refresh process daily during non-peak hours.

You can update the ODS database in the following ways:

The files that launch the database refresh process are:

These files are in your P6 Reporting Database installation folder: installation folder\ods.

"" The user who initiates the database refresh process needs read/write access to the P6 Reporting Database installation folder. You can use the Windows AT command, Task Scheduler, or Unix CRON to launch the ODS file.



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

Last Published Friday, January 31, 2014