Primavera Data Warehouse supports adding user-defined steps to the ETL process, which can be used to extract, transform, and load additional data into the Primavera Data Warehouse schema. When using this option, user-defined scripts are automatically run as part of the standard ETL process.
To run user-defined scripts during the STARETL process, complete the following steps:
- Create scripts and keep a copy in a safe place.
Note: Each script should have an “EXIT" at the end.
- Make sure each script runs successfully with good performance in sqlplus.
- Copy the scripts to the <install_folder>/scripts/user_scripts. Scripts will be picked up by the STARETL process.
- If you want some of the scripts to run in certain order, add the script name to the file <install_folder>/res/priority/user_scripts.txt, one line for each script file name (no path information is needed). The scripts will run in the order they are listed. Scripts not in user_scripts.txt are will run in no specific order after the listed scripts.
- Run staretl.bat (with Windows) or staretl.sh (with UNIX or Linux). The user-defined scripts are the last step of the STARETL process.
Note: Running configStar.cmd or configStar.sh will not override these scripts.