Getting Data Out of TFS Relational Warehouse into Excel or Wherever

The TFS Datawarehouse schema is well documented here

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


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.

This provides the following screen.

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





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.