(Optional) Force a full ETL
Automated incremental ETL (extract, transform, and load) jobs run regularly to update the data from the PPM system to the Operational Reporting database schema. In case of instability or frequent errors during incremental ELT runs, you can force a full ETL to update the data.
To force a full ETL:
Navigate to the <Op_Report_Home>/install/sample directory.
Open the sample_full_etl_all.sh file (or sample_full_etl_all.bat) file in a text editor and then replace the parameter placeholders with valid values.
Run the sample_full_etl_all.bat (or sample_full_etl_all.sh) script.
- When prompted, enter passwords for the Operational Reporting database schema and the PPM database server schema.