Connecting Project Reporting Database from MS Access

[MSPLearner]

I would like to connect to the reporting database to view the tables, view
etc documented in the SDK.

When I connect to the Database Server (separate machine from Project Server
2007), I mostly see what looks like system tables. Where do I find the
tables, cubes, views as documented in the SDK? Should I be looking for a SQL
instance ProjectServer_Reporting on the Database Server?

Appreciate any help.

 

[Marc Soester [MVP]]

Hi MSPLearner,

you will need to connect to the reporting database of project server.
depending on how your administrator called the database during the
installation, I would assume you will have to look for something like
"ProjectServer_Reporting" database. There you will find all the reporting
tables required.
Hope this helps

 

[MSPLearner]

Thanks Marc,

I suspected as much. I appreciate the confirmation.

MSPLearner