Decide when and how often to update the databases from the P6 EPPM Extended Schema. The database will undergo a full update, but the historical trend data from previous periods will not update.
You can update the Star database in the following ways:
The files that launch the database refresh process are:
They reside in your P6 Reporting Database installation folder: installation folder\star.
To ensure that your P6 Reporting Database system has the latest data from the P6 EPPM Extended Schema, Oracle recommends that you run the update daily during non-peak hours.
Note: Allow sufficient time to complete the scheduled run of the database update; this applies to multiple data source environments as well. Do not overlap the ETL processes; run only one ETL process at a time.
You can use any mechanism to launch or schedule the launch of the STARETL process. The Windows AT command, Task Scheduler, or Unix CRON are all viable options. The user who initiates the STARETL process needs read/write access to the P6 Reporting Database installation folder.
Legal Notices
Copyright © 1999, 2014,
Oracle and/or its affiliates. All rights reserved.
Last Published Friday, January 31, 2014