Getting Data Out of TFS Relational Warehouse into Excel or Wherever


The TFS Datawarehouse schema is well documented here

http://msdn.microsoft.com/en-us/library/ee620640(v=vs.120).aspx

As an example, let’s say we wanted to get this kind of data in the following form into Excel.

We can use the following SQL statement.

Use Tfs_Warehouse

Go

Select IterationPath, StartDate, FinishDate from DimIteration order by StartDate, IterationPath

This yields as follows:

If we were to create new iterations, we can process the Warehouse immediately through a web service. Select ProcessWarehouse link from the following URL.

http://msdn.microsoft.com/en-us/library/ff400237.aspx

This provides the following screen.

Finally, use the following link to use the query to populate an Excel spreadsheet.

http://office.microsoft.com/en-us/excel-help/use-microsoft-query-to-retrieve-external-data-HA010099664.aspx

 

 

 

 

Comments (2)

  1. Anil Kumar says:

    This is really a great and informative article. By this method everybody can get data out of TFS Relational Warehouse into Excel easily.

  2. Jason Singh says:

    My pleasure Anil. Please enjoy the features.