Although TFS already integrates with Microsoft Office Project Standard 2007 and Microsoft Office Project Professional 2007, the same level of integration has not been available with Microsoft Office Project Server 2007. In response to strong customer demand for a solution, the Visual Studio Team System Rangers worked closely with the community to develop the Visual Studio Team Foundation Server - Project Server 2007 Connector (PS-TFS Connector), which streamlines the flow of data directly between TFS and Project Server 2007. This provides a number of benefits, including more effective Enterprise Resource Management across development projects, better project management, improved status management and automated updates.
The Connector synchronizes Project, Resource and Task data between the two systems. Project Managers and Resource Managers continue to work in the EPM environment while the development team works in the development environment and data seamlessly flows between the two systems. Updates to work items in TFS are automatically applied to the corresponding assignments and tasks in Project Server and vice versa. Project Managers have complete control over the inflow of the actuals into the project plan. In addition, resource management functions for all development projects, like managing time and utilization for resources working across multiple projects, team staffing etc. can be performed in Project Server. Lastly, portfolio and program level reports can easily be generated for projects being executed in TFS and managed in Project Server.
The connection between Team Foundation Server and Microsoft Project Server is now freely available for download from CodePlex, Microsoft's open source project hosting Website.