Connector Details

Connector Attributes	Details
Name	Primavera P6
Description	Oracle Primavera P6 is a powerful project, program, and portfolio management tool used for planning, managing, and executing projects across various industries—including Construction, Oil and Gas, Aerospace and Defense, Government and Federal Agencies, Energy and Utilities, and Biotech. Key Features - Planning: Create project schedules, allocate resources, and manage costs. - Scheduling: Plan and control large-scale programs and individual projects. - Resource Management: Optimize resource allocation. - Cost and Schedule Management: Integrate cost and schedule data. - Multiuser Access: Allows project managers to coordinate costs and schedules. - Team Collaboration: Gather status updates from team members.The Primavera P6 Data Service provides read-only access to your cloud-based P6 EPPM, Primavera Unifier Project Controls, and Primavera Unifier Facilities and Asset Management transactional data via RESTful endpoints.
Connector Type	Class C

Features

Feature Name	Feature Details
Load Strategies	Full Load, Incremental Load
Metadata Extraction	Supported
Data Acquisition	Supported
Data Publishing	Not Supported
Automated Schema Drift Handling	Not Supported

Connector Features

Compatible with P6 configurations:
1. ds_p6adminuser to access the P6 EPPM database as admuser (Tables).
2. ds_p6reportuser to access the P6 EPPM database as pxrptuser (Views).
3. ds_unifier to access the Primavera Unifier database.
Metadata
1. Refresh P6 Data Service metadata from source
2. Includes metadata for over 1,065 non-blacklisted tables.
Data Extraction
1. Extract P6 source data using pagination (SYNC) or ASYNC*. Default is SYNC.
2. Blob/Clob data type columns in the future.
3. Includes P6 Metadata Table and Columns tables during extraction as objects.
4. Enforces field datatypes during extraction.

Connection Parameters	Data Type	Example
Connection Name	String	PrimaveraP6APIConnector
Base URL	String	Stage: https://us2.p6.oraclecloud.com/p6-customer-name/stage OR Production: https://us2.p6.oraclecloud.com/p6-customer-name
Username	String	P6USERNAME
Password	String	your-password
Configuration Name	String	DS P6 Admin User (ds_p6adminuser) DS P6 Report User (ds_p6reportuser) DS Unifier (ds_unifier)
Bronze Schema (Optional)	String
Silver Schema (Optional)	String

Base URL: The environment section of the endpoint URL is formatted as follows:
1. OCI Stage: .p6.oraclecloud.com//stage
2. OCI Production: .p6.oraclecloud.com/
3. GBUCS Stage: -stage-primavera.oracleindustry.com
4. GBUCS Production: -primavera.oracleindustry.com
Configuration Name: Compatible with P6 configurations:
1. ds_p6adminuser to access the P6 EPPM database as admuser (Tables).
2. ds_p6reportuser to access the P6 EPPM database as pxrptuser (Views).
3. ds_unifier to access the Primavera Unifier database.
  
  Note: The Empower Primavera P6 connector will be configured to point at one configuration at a time (i.e. P6 Admin User (ds_p6adminuser). If you need to pull data from multiple configurations, create a new Data Source Connection in the Empower Analytics UI for a new configuration. This is done because there is an overlap in tables/views with the same name between different configurations in P6.
Required Permissions & Module access in P6:
1. Integration API
2. P6 Analytics
3. Web Services
  
  Note: Any data that is required for data extraction will also need to be granted to the service account being used for Empower P6 connector (i.e. Portfolios, Projects, Timesheet, and Resources). For example, if Project data is required, then the service account will need to have P6 Module access to Project data.