Share via

Getting Data Out of TFS Relational Warehouse into Excel or Wherever

  • Article

The TFS Datawarehouse schema is well documented here

https://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.

https://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.

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

Comments

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

  • Anonymous
    May 15, 2014
    My pleasure Anil. Please enjoy the features.