About the Primavera Data Service Guide
The Primavera 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. The service supports both HTTP basic authentication and SSL authentication.
Submit a Service Request in My Oracle Support to request the Primavera Data Service be enabled.
Caution: Personal information (PI) may be at risk of exposure. Depending on local data protection laws organizations may be responsible for mitigating any risk of exposure.
This is an administrator-level function.
Note: You are responsible for all aspects of the query process including writing, executing, and consuming query results and storing the fetched data.
Using the Primavera Data Service with P6 EPPM
Read only access is available to the following for P6 EPPM:
- SELECT privileges on all P6 tables (including X tables) except ADMIN_CONFIG, BRE_REGISTRY, PREFER, PUBUSER, SETTINGS, and tables that start with DLT, DR$ and MDRT_.
- For granted tables, synonyms use the same name as the table.
- Views for pxrptuser use the same names (You must use the pxrptuser config name to access these views). However, select privileges are not provided for the following views and synonyms of pxrptuser.
Views: PXSETTINGS, AUDIT_SETTINGS
Synonyms: GATEWAYDEPLOYMENT, GATEWAYPROVIDER, GATEWAYSYNCACTION, PREFER, PROJDEPLMENT, SECPAC
For more information about the P6 EPPM schema, see the P6 EPPM Schema Documentation.
Using the Primavera Data Service with Primavera Unifier Project Controls and Facilities and Real Estate Management
Read only access is available to the following for Primavera Unifier:
- SELECT privileges on all Unifier tables except those starting with QRTZ_.
- For granted tables, synonyms are provided with same names.
- Unifier views are also available.
For more information about data definitions, data elements, data mapping, and data structure, see the Primavera Unifier Reference Guide.