User-defined ETL Script Samples

Previous TopicNext TopicContents

Oracle Primavera provides sample scripts to demonstrate how to extract, transform, and load (ETL) additional User Defined Fields from P6 EPPM to the Project, WBS, and Activity dimensions in the STAR schema.

The sample scripts are available in the <install directory>\<operating_system>\sample\user_scripts folder on your release media or download.

To execute the sample scripts:

  1. Copy the 3 *.sql files to <install_directory>\scripts\user_scripts directory.
  2. Copy user_scripts.txt to <install_directory>\res\priority directory. Listing the scripts in this file specifies the order in which the scripts will run.
  3. Run staretl.bat or staretl.sh. The scripts will run at the end of the ETL process.

The samples add UDF field values to Project, WBS, and Activity dimensions.

Related Topics

Running the STARETL Process

Running User-defined ETL Scripts



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

Last Published Friday, January 31, 2014