Primavera Data Warehouse accumulates data over time with each run of the STARETL process. The traditional ETL process is used to run STARETLs to extract, transform, and load (ETL) data into Primavera Data Warehouse.
Primavera Analytics gives you an alternative option to run STARETLs by using Oracle Data Integrator (ODI) to extract, transform, and load (ETL) data from the following data sources into Primavera Data Warehouse:
- P6 EPPM
- Unifier
Oracle Data Integrator (ODI) is a comprehensive data integration platform that covers all data integration requirements: from high-volume, high-performance batch loads to event-driven, trickle-feed integration processes and SOA-enabled data services. ODI allows for near real-time migration of data.
ODI allows for features not supported by the traditional ETL process such as:
- Real-time analytics
- Single project loading on-demand
Note: ODI is a separately licensed application.