Connecting Primavera SDK database using Excel
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
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 youve 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 thats of some help... I used this to connect to the MS SQL Database that the PMDB is using on my local machine. Havent been able to get onto the server version as yet.