Depending on your organization's specific deployment, P6 EPPM and Primavera Unifier work together with Primavera Data Warehouse and Primavera Analytics as depicted below.
For On-Premises
Use either the PL/SQL-based or ODI-based StarETL process.
Note: The term, StarETL, when used generically, applies to PL/SQL as well as ODI.
Applications:
P6 EPPM and Primavera Unifier: P6 EPPM and Primavera Unifier are the primary interfaces for administering and managing projects. In one or both of these applications, you will gather the data on which Primavera Analytics will report. P6 EPPM and Primavera Unifier provide an extensive array of features designed to optimize all phases of Project Management, Resource Management, and Portfolio Management. They include full support for activities, work breakdown structures, planning and scheduling, costs, resource administration and assignment, codes, user-defined fields, roles, teams, and capacity planning.
Oracle Business Intelligence (OBI): OBI integrates data from multiple enterprise sources, and transforms it into key insights that enable strategic decision-making, drive continual business process improvements, and promote alignment across the enterprise. OBI can also generate proactive alerts based on integrated reports data mined from Primavera Data Warehouse.
Primavera Analytics: This integrated dynamic reporting tool uses the gathered data to facilitate the creation of ad hoc reports and interactive custom dashboards reflecting trends and metrics for activities, portfolios, resource assignments, utilization, and project history.
Technology:
The P6 EPPM Database: The main database for P6 EPPM data. The P6 EPPM database includes the P6 Extended Schema (Px) optimized for reporting.
The Unifier Database: The main database for Primavera Unifier data. The Primavera Unifier database includes the Primavera Unifier Staging Tables optimized for data extraction.
Primavera Data Warehouse: Primavera Data Warehouse consists of the Star database. It pulls data from the P6 EPPM Extended Schema and the Primavera Unifier Staging Tables, which can then be used to create reports. The Primavera Data Warehouse database accumulates project and cash flow data over time, providing baselines for tracking trends and for advanced business intelligence; it also provides key metrics on current data, which allows you to drill through root cause analysis. You can use tools, such as OBI, to analyze the data in Primavera Data Warehouse.