Home » FAQs » Can Adeaca PBA integrate with Microsoft Project and Oracle Primavera P6?
Integrations Product

Can Adeaca PBA integrate with Microsoft Project and Oracle Primavera P6?

Yes, Adeaca Project Business Automation integrates with Microsoft Project and Primavera P6 via XML files. XML files can be imported into and exported out of Adeaca PBA.

Yes, Adeaca Project Business Automation integrates with Microsoft Project and Oracle Primavera P6 via XML files. XML files can be imported into and exported out of Adeaca PBA.

The XML file is in the Microsoft Project XML format, this format can be used with Primavera P6 as well. This solution works well when collaborating with general or sub contractors. Although this solution works well for this purpose, for internal scheduling purposes we recommend utilizing Adeaca PBA as your primary scheduling engine.

XML import. When importing an XML file, you import the Work Breakdown Structure (WBS) including estimates, constraints, predecessors and role assignments. A resource in Microsoft Project is imported as a role in Adeaca PBA. Adeaca PBA resources are not part of the XML format and can only be assigned in Adeaca PBA.

It is important to understand that the actual schedule from Microsoft Project is not imported. After completed import, the WBS must be scheduled in Adeaca PBA. In most cases the resulting Adeaca PBA schedule will be identical to the Microsoft Project schedule, but ultimately Adeaca PBA and Microsoft Project are two separate scheduling engines and an identical result is not guaranteed.

You can only import an XML file during the initial baselining of a project. Once the project is operational and transactions are committed against the WBS you are no longer able to import an XML file.

This means you cannot export an operational project, import the XML file in Microsoft Project to make changes and then reimport the WBS to Adeaca PBA.

XML export. When exporting an XML file, you can select between exporting the WBS and the schedule (full format) or just the task list and schedule (distribution format). If you export a full format file and subsequently reschedule the WBS in Microsoft Project you can end up with a slightly different schedule due to different parameter settings, calendar definitions and subtle differences between the two scheduling engines. In most cases however, an identical schedule between Adeaca PBA and Microsoft Project can be expected.

You can continue to export XML files throughout the project lifecycle.

Learn more about Adeaca PBA Project Operations

About the author

Henrik Lerkenfeld

Henrik is Adeaca's Head of Product Development. Henrik has deep roots in Microsoft Dynamics, having been part of the original Axapta ecosystem and Microsoft’s team after it was acquired. His knowledge of project industries and his systematic process design approach is a crucial component of Adeaca’s customers' success.