Can PDS be used to call procedures?

[Nosh]

we needed a view which would show the relationship between custom outline
codes,wbs and actual hours to the finance team. This view was made with a
query which used one of the timephased tables and a few view tables along
with the outline codes table. Latter on this query was converted into two
procedures.

However for some performance and compatability reasons we are being forced
to use PDS for these views, which actually would be the right way to go about
it.
Going through the PDS documentation what I understand is that PDS allows
function calls via xml format, but it does not allow access to the database
similar to direct calls to the database. Following are the problems I have
with this:

1. I dont know how to make the function calls via PDS in a way that would
group the data the way the query does.
2. Is there a way to call procedures from PDS? I guess a PDS extension will
have to be written.
3. If we make a logon through PDS can we still make calls to the database
via the same connection?

If there is a better way to approach this problem please advise, any help
would be much appreciated in this regard.

 

[Nosh]

Allright I have been reading PDS docs and now I know we can make procedure
calls from within PDS by creating a PDSExtension, but in the end what is the
use if we can simply do that directly calling the database?

 

[Brian K - Project MVP]

Allright I have been reading PDS docs and now I know we can make procedure
calls from within PDS by creating a PDSExtension, but in the end what is
the
use if we can simply do that directly calling the database?

Because it implements it in a way that allows you to more easily use it
across other applications that might access Project Server data.