Pulling data from the Reporting database from PSI extension

[Yaron]

Hi,

I created a PSI Extension as shown in the Project 2007 SDK.

Now, i want to pulling some data from the reporting database (RDB) using a
SQL query,
how i need to do this, as it says in the SDK pulling data from the RDB is
one of the advandage for using the PSI extension.

Thanks,
Yaron.

 

[Aaron Tamblyn]

Depends what you are wanting to do. It is likely that you would query the
data by using a SQL Server stored procedure against the Reporting database
for Project Server. Check out the SQL Views, they will likely be what you
query against. If you are wanting to pull data out in the PSI extension
then you would likely use ADO.Net.

Aaron.