When using Oracle Data Integrator (ODI) for Data Warehouse to initiate a full ETL (initial_load) run within ODI studio, there are a few different ways data is updated for Primavera Analytics using ODI as your ETL engine:
- Initial Load: Run this the first time you are setup using ODI and does a 'Full' ETL similar to the traditional ETL process which did truncates and inserts. This is not an incremental process. If there are issues during your normal day to day operations where changes may have been missed during a daily ETL due to database issues or issues with source systems you can run initial load again to catch the data up and make sure all changes have been captured.
Note: This process should be used sparingly and not a regular process as this can interfere with other Real Time Load Plans that could be running. It is recommended to stop the other Real Time Load Plans before running Initial Load and then restart them once completed if Initial Load being run during regular operational hours where changes from source system could be detected.
- Daily ETL: The daily ETL does an incremental processing of changes into the data warehouse. It is similar to Initial Load covering similar data areas.
- Real Time Load Plans (for P6 only): This includes
- Real Time Global: Handles global P6 data such as resources, roles, users, etc. (like dictionary level data). This is generally triggered by running P6 Global services like Resource management, Enterprise data, or security.
- Real Time Project: Handles projects in P6 tagged for 'Immediate' updates. If no projects are tagged as such this Load Plan will remain idle.
- Real Time OnDemand: Handles when new projects are added to the system for publication or for Analytics. Triggered by enabling publication for projects in P6.
Running the Initial Load from ODI Studio
If you need to run the Initial Load it should be done so from ODI Studio:
- Go to the Designer tab, and expand Load Plans and Scenarios.
- Expand Primavera Analytics <Version Number>.
- Find LOAD_PLAN_INITIAL_LOAD, right click on it and choose Run.
- Choose the data source to run it with and click OK.
- You can view the job running in the Operator tab.