Oracle 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 Primavera Data Warehouse schema.
The sample scripts are available in <install folder>\<operating_system>\sample\user_scripts on your release media or download.
To run the sample scripts:
- Copy the .sql files to <install_folder>\scripts\user_scripts.
- Copy user_scripts.txt to <install_folder>\res\priority. The listing of the scripts in this file specifies the order in which the scripts will run.
- Run staretl.bat (with Windows) or staretl.sh (with UNIX or Linux).
Note: The samples add UDF field values to Project, WBS, and Activity dimensions.