Connecting Project Reporting Database from MS Access

M

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.
 
M

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
 
Top