TFS OData Service, load your TFS data into PowerPivot

By | April 11, 2011

Always wanted to play around with the data that is stored inside your TFS server? This has now become much easier. The TFS team have announced a special OData service to be released for the product.

The purpose of this project is to help developers work with data from Team Foundation Server on multiple types of devices (such as smartphones and tablets) and operating systems. OData provides a great solution for this goal, since the existing Team Foundation Server 2010 object model only works for applications developed on the Windows platform. The Team Foundation Server 2010 application tier also exposes a number of web services, but these are not supported interfaces and interaction with these web services directly may have unintended side effects. OData, on the other hand, is accessible from any device and application stack which supports HTTP requests. As such, this OData service interacts with the client object model in the SDK (it does not manipulate any web services directly).

Download the beta: OData Service for Team Foundation Server 2010
Provide feedback on the beta: TFSOData@Microsoft.com

Watch a video about it here.

TFS Odata Service, load your TFS data into PowerPivot