If you didn’t already know, Microsoft provide an out of the box solution to integrate Project Server and Team Foundation Server called “Team Foundation Server Extensions for Project Server”. I’ve dealt with several organisations who have the requirement to track their agile development (managed in TFS) in Project Server (via PWA), and we ran a UK Web ‘n’ Learn via the MPUG on this very topic – to view the webcast please use this URL – http://www.mpug.com/webnlearn-recordings/webnlearn-uk-an-introduction-to-team-foundation-services-with-project-server-2010/ (you will need to log into the MPUG site to access it.)
So, is everything rosy in the Project Server / TFS integration world? Well, yes and no. Yes in terms of once everything is set up, it works very well (it does what it says on the tin!). No, in terms that setting it up can be fairly complex, which is where the following paper comes into play “Instant Team Foundation Server 2012 and Project Server 2010 Integration How-to” which is available at http://bit.ly/ZulWBG.
I’ve read the paper it and it explains exactly what you need to set up and configure in order to get the two solutions (TFS and Project Server) to talk to each other, and it includes a whole section on getting the security right, and all the powershell commands required in order to associate a Project Server plan with a TFS project.
I you are planning to deploy TFS/PS integration, then I would recommend this as a good technical starting point.
Further information and useful URLS
Solutions For Application Lifecycle Management: http://www.microsoft.com/visualstudio/en-us/solutions/management
Customer Case Studies: http://www.microsoft.com/casestudies/Case_Study_Search_Results.aspx?Type=1&Keywords=ALM
MSDN Product documentation: http://msdn.microsoft.com/library/gg455680.aspx
MSDN Public Forums – Team Foundation Server and Project Server Integration http://social.msdn.microsoft.com/Forums/en-US/tfsprojectsrvint