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