Oracle Primavera is a powerful software for planning and managing large-scale projects and programs in the construction, engineering, aerospace, and other industries. Large-scale projects often begin as programs and are subdivided into sub-projects. A range of project management tools is often used, either within a single company or between the company and its external suppliers. For example, program planners use a tool such as Oracle Primavera for scheduling, but the sub-project manager uses Microsoft Project or. Project Online in der Cloud – or vice versa.
Coordinating hundreds or even thousands of tasks over the course of a multi-year project is a real challenge. It’s very tedious and time-consuming to reconcile data, find and correct data transfer errors and handle the resulting long reporting cycles.
Having a professional middleware software to efficiently handle the data sharing solves this problem.
For over 20 years, TPG PSLink has served as a proven middleware solution for sharing data between enterprise systems and diverse project management tools. By doing so, it supports the bidirectional integration with Oracle Primavera. The high degree of configuration flexibility enables it to handle all possible use cases. With a range of default configurations, the product can be quickly and easily implemented.
Integration of Oracle Primavera with Microsoft Project
Here’s how it works: In Primavera and Microsoft Project, the processes to be included in the data exchange are marked as such. The project name, task name, start and finish dates of these tasks are synchronized by the TPG PSLink middleware in a SharePoint list. From this hub, the data in the other system can be selected from a dropdown menu and imported to the correct spot in the schedule.
Discrepancies between the deadlines in your own plans and those of your business partners are clearly indicated in both systems by the split bars: one showing your plan and one showing that of the external project (see the following graphic). Deviations are immediately recognizable and can be promptly discussed with those responsible.
If the collaboration extends beyond corporate boundaries, an integration that avoids the problems associated with access permissions is especially advantageous.
Further information about the following use case is available here: SharePoint Integration.
In some cases, SharePoint can act as an intermediate stop at which users can edit and supplement the master data (e.g. project opportunities from Microsoft CRM or resources from Microsoft Dynamics AX) as well as update the data in other systems (e.g. Primavera). Lists like these can be read from the source system and imported into the target system (such as the selection lists for Primavera fields) using TPG PSLink.
Using TPG PSLink, you can make work package data available in SharePoint. The data maintained there can then be imported into Primavera or the ERP system.
TPG PSLink lets you automatically create and allocate checklists for a project in Primavera based on SharePoint templates. These are updated with information from the project plan (e.g. milestone deadlines). The updated checklist items are synchronized with project milestones and phase-related fields in Primavera (e.g. completed phase milestone, change of status, etc.).