Connecting Primavera SDK database using Excel

E
Emma Seaton 👤 Member for 20 years 9 months

Hi, you need to know the Unique ID for the project. Do a query on the proj_id/proj_short_name within the PROJECT table and you should (hopefully) be able to identify which project you should filter on once you’ve connected to the data. Then using this UID you can then pull in the activities and associated data. It may help to root out the Physical Schema. This came with the on-disk documentation with P3e 4.1, and should in theory be on the P5 disk too...



Hope that’s of some help... I used this to connect to the MS SQL Database that the PMDB is using on my local machine. Haven’t been able to get onto the server version as yet.

Forum Sponsor

Top Posters

Nick Johnson-Pond
3 posts
sairedz25
0 posts
Ahmed Awad
2 posts
Syed Shoeb
0 posts
Vimukthi
0 posts
bal aji
2 posts
Lee Mallek
23 posts
Viet Tran
9 posts
Ola Gbotoso
0 posts
Jaturapit Multongka
1 posts