The benefits of integrating Primavera P6’s database with Microsoft Excel have long been a secret weapon of many advanced Primavera users. By leveraging spreadsheet functionality to manipulate project and enterprise level P6 data and avoid time consuming manual data entry, users are able to drastically increase their productivity and leave envious colleagues in awe of their P6 wizardry.

The Primavera Software Development Kit (SDK) is a legacy technology feature that is included with Primavera P6. It was released with P6 r3.0 (at the time known as P3e). It implements an ODBC driver that enables a connection between the Primavera P6 data store and other software such as Excel or Access. However, as the underlying P6 technology has advanced significantly in recent years, many are finding the old SDK tricks falling short in today’s Primavera enterprise environments. Some serious technical drawbacks of the antiquated SDK have made it a non-option for many Primavera client companies.

In January when the oil prices fell below 50$ a barrel, many of our Calgary clients started re-evaluating their capital project plans to get the most out of this year’s investments. One of our clients was planning to invest in significant pipeline infrastructure and progress on a drilling program with 6 drill rigs on the go at any given time. The client needed to rearrange priorities and reduce this year’s plan down to 3 rigs and decrease main trunk line development.

Many people confuse Project Management with Project Portfolio Management and with Strategic Portfolio Management, as though they were virtually interchangeable terms. They are not.

This is a very common and puzzling question for someone who is installing P6 on a single workstation and is only going to have a single user – should I go with P6 Professional, also known as Primavera Project Portfolio Management (PPM), or P6 Enterprise, also known as Enterprise Project Portfolio Management (EPPM)?

One of our consultants who is currently loading large amounts of P6 data using Emerald’s P6 Loader came to me with a concern that there is sometimes a lag between loading information using our P6 Loader (via the API’s) and it appearing in P6, even if he repeatedly pressed the F5 (Refresh) key. The lag could be minutes or hours depending on the situation.

Primavera Unifier has a powerful security model that can be challenging to administer. It allows modeling roles by using groups and assigns roles to users by adding them to those groups. In addition, permissions can be granted to groups. The thing that makes it difficult to administer is that each project and shell has its own groups.

Emerald Associates Announces the New Release of Primavera P6 Add On Tools for Automating and Updating P6 Project Data

The release of version 10.1 marks a new milestone in the progression of Primavera Unifier as an international product. It’s a tough choice between whether the introduction of multi-language capabilities or the significant changes in the P6 Integration functionality is our favorite improvement.

In our last update we discussed the installation of the Oracle Database Appliance (ODA). Today I am writing to share an update on our latest project milestone, the connection of the ODA to the ZFS storage appliance.

Working in the field is such an amazing and rewarding experience. I recently returned from a large turnaround project that was implemented by one of Emerald’s largest customers in Fort McMurray.

The proper management of resources on a turnaround project is vital to its success. Levelling functionality of Primavera P6 is heavily utilized by planners and schedulers to make sure the deadlines set by the turnaround (TA) management are met and resources are utilized in the optimum way.

A turnaround is a very large undertaking. The first and foremost priority must be safety. Always keeping that in mind, the team must address all aspects of the in scope (known work) as well as found work (which has the potential for a few surprises!). Scheduling of such an event is a must!

We are just at the beginning of a project to migrate our client's Primavera databases and applications onto multiple Oracle Database Appliance X4-2s (ODAs) and Oracle ZFS Storage Appliance ZS3-2s (ZSAs) in multiple datacenters, implementing the Oracle Maximum Availability Architecture to ensure the highest standard of availability is maintained. They have had issues in the past with their system becoming unavailable during a turnaround and they have acquired these appliances and contracted Emerald Associates to ensure that experience is not repeated.

As a continuation to Funding and Unifier Part 1 where we discussed how to track funds at the company level, we will now discuss funds at the project level, including how to allocate funds to a project, the approval workflow, and how to assign funds at the WBS Level.

One of the foundations of any project is the funding. Without funding, it is not possible to achieve the scope of the project. For this reason, the fund control in the company plays a fundamental role in the project and cost management.