Accessing Data not in the RDB?

[Darrell]

I want to be able to access data that is not in the RDB. I work for an IT org
so I have the resources to develop whatever I may need. However, I am not
sure exactly what I need to ask for so that I can access this data in a safe
and secure manner. I have read about the PSI and extensions but do not
understand everything I know. Can anyone provide me with some basic direction
on how to accomplish my task of reporting against data not in the RDB?

Darrell

 

[Rod Gill]

The only approved way of getting data not in the Reporting db is to either
open the schedules and read data using automation or use the PSI. See the
Project SDK for getting started on using the PSI and MSDN.microsoft.com for
further information and examples.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

 

[Darrell]

Rod,

Thx for the reply.

We have a lot of reports that are generating daily, weekly and monthly using
everything from an Access DB pulling data from the RBD, to exporting Project
and Resource Center, as well as Data Analysis, views to Excel where the data
can be further manipulated. I am sure we will need more reporting
capabilities as the organization matures in using Project Server so I was
thinking about developing a solution to access all of the data to generate
the views which can then be exported and used as reports. If I understand
what I am reading in the SDK I can use the PSI to accomplish this - right?

Darrell

 

[Rod Gill]

The PSI lets you read and write data to Project Server. I think it would be
slow to read large amounts of data to other sources but I haven't done that.

Rather I would use PSI to add any data missing from the Reporting db to a
new Table you create in the Reporting db.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com