How to read time phased data from Project Server 2007 directly from Project Server Database ?
- by Nikhil Vaghela
I am working on a custom web part for Project Web Access, for Project Server 2007.
We are so far using PSI web services only to read and write data from and to Project Server 2007 databases.
But there is a signinficant performance issue when you retrieve time phased data through Statusing web service, it is basically an expensive call for querying time phased data for each tasks.
I want to access Time phased data entered by user for each tasks by directly hitting the Project Server Database. [ I do not want the solution suggested at this link : http://blogs.msdn.com/project_programmability/archive/2007/05/24/getting-at-the-task-time-phased-data.aspx as it reads data from reporting database which gets entry only after the project is published. ] I want to get time phased data as soon as user enters it.
Any idea ?
Thanks.