Primavera DACS provides direct read-only SQL access to your cloud-based P6 EPPM, Primavera Unifier Project Controls, and Primavera Unifier Facilities and Asset Management transactional data. The service uses a shared secret for the authentication and security of the IPSec tunnel.
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. Oracle will provide a database integration account to be used with this service. This service is to facilitate system integrations only and is not meant for access by individuals.
Note: You are responsible for all aspects of the query process including writing, executing, and consuming query results and storing the fetched data.
Using DACS 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 are provided in the format of T6_{base table name}.
- Views for pxrptuser are also recreated and use the same names (without a T6 prefix).
For more information about the P6 EPPM schema, see the P6 EPPM Schema Documentation.
Using DACS 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 QRTZ tables.
- For granted tables, synonyms are provided with same names.
- Unifier views are also recreated.
For more information about data definitions, data elements, data mapping, and data structure, see the Primavera Unifier Reference Guide.