One of the common misconceptions I run into with new Primavera P6 customers is that the SDK is a program. Well – it is, but they feel like they should be able to double click it and a white light will surround you from the heavens and a magic user-friendly interface will solve all of your bulk data import/export needs. I believe this stems from searching the internet for information on the SDK and seeing tons of articles about how people used it to load resources, costs, tasks, and other tedious-to-enter-especially-when-you-already-have-it-in-excel data sets.
Today we are going to set the record straight.
First of all the SDK in Primavera P6 SDK stands for Software Development Kit. So what is a Software Development Kit? It is an interface that allows a third-party program to access data and functionality of another program. In the case of Primavera P6, it is a “back door” into the P6 database.
So in order to use the Primavera P6 SDK you need a program to talk to it. The easiest one that comes to mind is Microsoft Excel. I mean, who doesn’t have a copy of Excel laying around? Even Mac users do.
The P6 SDK creates what’s called an Open Database Connector (ODBC). ODBC connectors have been around for decades now. So long I feel old thinking about the first time I used one. Excel can use the ODBC connection that the SDK creates to directly access almost anything in a P6 schedule. Although this article doesn’t cover how to connect it, bookmark this page because a follow up article will. In the meantime you can download a fully-working excel document with embedded macros for importing and exporting EPS and Project data from Oracle. Just look for document 894555.1.
If you need something more complex or more specific to your needs, contact us! We have been doing it for years.