Primavera Data Warehouse and Analytics are data warehousing products. Implementing them involves databases, servers, and controlling an ETL process. Oracle Primavera provides the code to perform the ETL process. The ETL process can be run from PL/SQL database or Oracle Data Integrator (ODI) for on-premises. Analytics contains a set of pre-built dashboards, analyses, and underlying metadata to provide end users with easy access to information.
When planning each deployment, you need to consider:
- What is required for physical storage and CPU processing.
- Which components of Primavera Data Warehouse and Analytics will be implemented.
- The differences in data volumes, frequency of data changes, and business requirements.
To successfully implement these products:
- Review the critical performance factors.
- Outline a methodology for planning an installation.
- Determine the physical storage requirements of the data warehouse.
- Address the server performance requirements of the STARETL process.