P6 EPPM On-Premises System Architecture for CIC
To access projects created in a P6 EPPM on-premises application in CIC, a sync client application will need to be deployed and instantiated in your on-premises environment. The sync-client application connects with a sync server on the cloud to synchronize and replicate data in real-time between your P6 on-premises application and a P6 cloud service setup. CIC will now use the P6 EPPM cloud database which mirrors your on-premises data to display only the selected P6 EPPM projects in CIC.
Note: The P6 cloud service which mirrors your on-premises data will only include the PX schema of the P6 database and any other component that CIC needs.
The following diagram illustrates the system architecture that needs to be implemented to display P6 EPPM on-premises projects in CIC:
A brief description and role of each illustrated component is provided below.
Goal
Use CIC to access and view projects created in a P6 EPPM on-premises.
On-Premises Environment Components
Your on-premises environment consists of the following components:
P6 On-Premises Application: P6 is the primary interface for administering and managing projects. Here, you can select the projects being brought over to CIC.
P6 On-premises Database: The main database for P6 data. The P6 database includes the P6 Extended Schema (Px) optimized for reporting. Data from this source will be used to provide insights in CIC.
Sync Client Application: The sync client application is used to synchronize the data between a P6 on-premises database and P6 cloud service. This application is used to continuously mirror the data available in your on-premises database on the cloud.
Sync Client Schema: The sync-client schema consists of database objects required for Sync-client application. It acts as an intermediate schema to store data and changes captured from the P6 on-premises database.
Cloud Environment Components
Your cloud environment consists of the following components:
Sync Server Application: The sync server application connects with the installed on-premises sync client application to synchronize the data between a P6 on-premises database and P6 cloud service database. This application continuously mirrors the data available in your on-premises database on the cloud.
Sync Server Schema: The sync server schema contains the database schema of the sync server application.
P6 Cloud Service Database: The data from the P6 on-premises application is made available to a P6 EPPM cloud service database.
CIC Administration Application: The CIC administration application allows administrators to manage CIC and P6 EPPM data sources configured for your organization.
Use this application to:
- bring data over to CIC for analysis using the ETL process
- manage P6 data sources
- create, monitor, and retrain machine learning models
- Set up benchmarking groups to compare current projects with projects previously delivered
- Configure threshold settings for the CIC Advisor application
Data Warehouse:The Data Warehouse database consists of the Star database. It pulls data from the P6 EPPM Extended Schema optimized for reporting. Data from this source will be used to provide insights in CIC.
CIC Applications: CIC Suite applications include the following:
- CIC Advisor is a smart project advisor that uses Artificial Intelligence and Machine learning to predict the project and activity delay, make invisible risks visible and enable learning from past projects.
- CIC Analytics is is an industry solution built on a modern analytics platform delivering value to stakeholders to track project cost, schedule and risk.
Last Published Thursday, December 7, 2023