Primavera P3 and Suretrak were built on the Btrieve database. Primavera provides a ODBC driver - Odbc32v2 for those who want to access their data via ODBC to build their custom reports. This is their old interface since, I beileve, Primavera is now built on top of Oracle database.
I found that the following tables are available in their database:
- WBS Structure and WBS assignment
- Activity Code and Activity Code Assignment
- Activity Relationship
- Custom Data Item
- Cost Account
- Holiday Information
- Project Options
Primavera is one of the data collection points. The structure of the elements captured in the Primavera schedule determines how the project schedule can integrate with the other project management related systems, such estimation, cost control, accounting, resource management, etc. My philosophy is that with a proper integration design, an organization can bring their project data from different systems into their project data warehouse.
It is important for us to support Primavera's various structures, including activity codes, WBS, and Cost Account. Once we get the structure into our data warehouse, people can create their own reports using our leading BI tools. These structure can be the "conformed dimension" so the data from various source can be viewed together.
Comparing with Microsoft Project, Primavera's structure is actually much simpler, in my opinion. My next study will be the Microsoft Project database.
A major progress has been made this weekend.