PDS vs .Net application

[ISPMO [STC]]

Dear all,
My manager wants me to develop some reports and link them to EPM menu and he
insist that I must use PDS and only PDS. his concern is about security.
is there any security issue when accessing Project Server data stored in the
MSSQL directly?
what is the benefits of PDS over .Net application?
Am I required to use the PDS only when deal with EPM Solution?

thanks to all of you guys who have made life easier.

 

[Rod Gill]

Hi,

PDS is not supported in Project 2007 so I don't recommend it as a solution.
There is no problem reading data directly from SQL Server, especially if you
use the reporting MSP_VIEW tables. In Project Server 2007 there is a
separate reporting database and a View reading '03 data will easily be
editable to read from the new '07 reporting db when you upgrade in the
future. Of course by creating Views for reports, you will need to handle
security yourself.

A .Net application would use PDS to interface with Project Server. A good
solution may be to use .Net to bring up reports from SQL reporting services.