Installing ODI
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.
See the Tested Configurations document for the supported version of Oracle Data Integrator (ODI).
For more details on installing ODI, see the ODI 12c (12.2.1.4.0) Installation Guide.
Related Topics
Creating and Configuring the ODI Java EE Agent
Increasing the Connection Pool for odiMasterRepository and odiWorkRepository
Last Published Friday, December 16, 2022