Emerald Associates
Calgary, AB T3E 7J4
- Map It
-
Contact Partner
403 6867100
- Have Partner Contact You
Solution Name
Solution Summary
Integrate data into and out of P6 quickly and easily with Emerald's EAI P6-Cloud API.
Solution Profile
Accessing P6 data via the existing Oracle P6 API or Web Services can be a daunting task during an integration project. With hundreds of tables to work with, it can be complex and time consuming for an organization to take on the effort of learning how the API works and how to integrate it with the other corporate tools. This can also be an expensive approach to building the integration.
Another consideration for a P6 integration is the volume of data that P6 will need to be sending into other tools every time the team re-schedules the projects; large volumes of data will be interacting from P6 with other systems. Investing in out-of-the-box middleware tools may seem like a good strategy, however the vanilla nature of these tools often fall short on ease of use, and also on performance. Developing integrations from scratch is also an option but even more costly and very time consuming to build, as well as full of potential issues, since not all of the data that P6 shows to the users is actually stored in the database.
During a P6 integration project, Emerald recommends purchasing the subscription to the EAI P6-Cloud API to ensure the fastest development during the project, and the quickest processing speed for the integration transactions after rollout. Emerald used our 28 plus years of integrating Primavera tools to develop the EAI P6-Cloud API, making integrating data into and out of P6 much easier and cheaper. The EAI P6-Cloud API has sophisticated, built-in technology that manages data from hundreds of P6 tables, and from all your projects. The EAI P6-Cloud API processes streamline the integration efforts tables into pre-existing data bundles, based on the usual business processes required for integration. These bundles make integrating more efficient and removes all unnecessary processing, making the integration more performant. This is particularly valuable when sending real-time dates, tasks, and resource updates into other systems. All complex data, including the resource and cost spreads and earned value information, are available in the EAI P6-Cloud API.
The EAI P6-Cloud API has the basic plumbing code that streamlines the integration effort, saving significant consulting costs for the project. Our sophisticated querying processes also take into account the way integration data is typically bundled, making the performance much faster than vanilla integration middleware tools and the basic Oracle API approach.
The EAI P6-Cloud API is also being maintained with new releases and versions of P6 with ongoing improvements as new features are being added to P6.
Emerald has used the EAI P6-Cloud API to integrate P6 with dozens of tools, including; Oracle Financials, Oracle Fusion, Oracle JD Edwards, SAP on premise and SAP Hana Cloud, Maximo, Aveva, Hexagon Smart Completions, QByte, WellView, SiteView, RigView, PVR , PIMS, Quickbooks, Discover, ZOHO, and many others.
Emerald also uses the EAI P6-Cloud API in all of our products, including: P6-Loader, P6-Scrubber, P6-Calculator, TAPS, CAPPS, P6-Auditor, P6-Reporter (previously EP-datawarehouse), and more.
Distinguishing Features
Easy, Flexible, and Secure
■ API type transparency - build for either WS or the API effortlessly
■ Increased quality of integration
Saves Time
■ Faster performance for P6 integration, particularly for large datasets
■ Easy and fast development
Saves Money
■ Reduced costs to build and maintain P6 integration
Solution Name
Solution Availability
Global
Oracle Products
- Aerospace and Defense
- Chemicals
- Construction and Engineering
- Industrial Manufacturing
- Natural Resources
- Oil and Gas
- Primavera
- Primary and Secondary Education
- Professional Services
- Public Sector
- Travel and Transportation
- Utilities
Company Size Solution is Targeting
No data available.
Open Source Solutions
No
Case Studies
Integrated capital projects and maintenance work orders from Maximo to P6 using Maximo IFACE tables and EAI P6-Cloud API to allow detailed planning and resource management within P6. Created new tasks from P6 via Maximo Web Services when schedulers needed to add additional supporting tasks to the schedule, and updated tasks from P6 to Maximo via Informatica when the tasks are scheduled in P6.
■ Projects - create/update projects using a standard P6 template by geography and project type
■ WBS - create/update work orders in weekly maintenance planning and yearly project planning. Update statuses
■ Tasks - create/update/delete from work order tasks developed by engineering
■ Resources - create/update resource crews as new ones are added to Maximo
■ Resource Assignments - create/update resource assignments from Maximo. Allow P6 team to control hours as needed
■ Steps - update summary data from work orders on summary tasks in projects for easier reporting and management
■ P6 → Maximo - allow P6 to create tasks in Maximo for certain work types and update project start and finish datesSAP Hana Cloud to P6 Integration
Emerald Associates created Work Orders from SAP Hana Cloud into Primavera P6 Azure Cloud for detailed task and resource management in Primavera P6 using Mulesoft and the EAI P6-Cloud API. We created SAP Operations and supporting resources and resource limits as new resources are introduced in SAP.
■ Work Breakdown Structure (WBS) - create/update SAP Operations into Primavera P6
■ Tasks - create/update tasks from SAP operations
■ Relationships - create/update relationships from SAP and allow Primavera P6 schedulers to change and update them back from Primavera P6
■ Resources - create/update for new crews in SAP and set limits
■ Resource Assignments - create/update resource assignments from SAP operations and sub-operations for detailed resource management
■ Primavera P6 → SAP - return operation and sub-operation lists and relationships to update SAP with Primavera P6 schedule information
■ Return task lists generated in Primavera P6Oracle Fusion Cloud to P6 Integration
Projects were created in Oracle Fusion and integrated with project estimates and tasks from P6 on-premise, using Oracle Fusion API and EAI P6-Cloud API. Actual resources and expenses costs were sent from Oracle Fusion into P6, and P6 forecasting was sent into Oracle Fusion. Both project and ledger currencies were managed, as well as hours for labour and equipment resources.
■ WBS - create/update/summarize and consolidate and rollup
■ Tasks - managed in P6 with durations and logic - integrated to Fusion for billing and charging against
■ Resources - auto-create any new resources, labour, materials, and equipment that are assigned within Oracle Fusion
■ Resource Assignments - create and update resource assignments, including percent complete forecasting, to allow resource management and estimate accountability
■ Expenses - create/update expenses, including percent complete forecasting
■ P6 → Oracle Fusion - allow revising of the budget in P6, and updating of the Fusion budget automatically.
■ P6 → Oracle Fusion - allow all progress updating and forecasting of physical percent complete, units percent complete, and start and finish dates to be managed and overwritten in P6
About Emerald Associates