Share →
Buffer

 Adding Two New, Useful SSRS Data Sources- By James Tupper

Introduction

Watching the performance of your TFS 2010 server is important. And having reports that show historical trending is very useful. Luckily, Grant Holliday, Microsoft Program Manager for Visual Studio Team Foundation Server, has two blog posts featuring some excellent report packs. Both sets of reports can be used against TFS 2010 (although one set requires some extensive modifications).

You can view the blog posts here:

The Performance Report Pack provides a lot of great information about the state of the TFS 2010 Farm, including historical trend data for both version control and work item operations. It is great for discovering, if you are experiencing intermittent performance problems. Originally, it was written for TFS 2008, but it can be upgraded to TFS 2010.

The TFS Administration Report Pack is a set of three reports that show data about the TFS Analysis Services cube and data warehouse.

The main issue with both of these report packs is that the instructions for creating the data sources for TFS 2010 are not included, or better said, the instructions are easy to figure out, but not specific enough to be completed trivially and with ease.

The following steps make creating the required SSRS data sources trivial.

Steps for Adding Data Sources

The report data source is needed by most of the RDLs that are provided with the report packs on Grant Holliday’s blog, and it is tied to the Tfs_Warehouse database. While the configuration data source is not used by all of the reports, it is still needed and is tied to the Tfs_Configuration database.

To add the data sources, you will want to go to your report server website with the following URL structure:

Personally, I opened an RDP session with my server and used http://localhost/Reports to access the SSRS website. From here you should see the SSRS Home page.

At the top of the page there is a ribbon of buttons with “New Data Source” being the second option. Click this button to start adding a new Data Source.

Figure 1: New Data Source button

We want to configure each data source with specific names to be sure that the reports in these packs will be able to connect to them without an issue. For the Tfs_Warehouse data source we want to fill out the new Data Source Form with the following information:

Figure 2: Report Data Source Settings :

  • Name : Tfs2010ReportDS
  • Connection String : Data Source = <TFSServer>;Initial Catalog=Tfs_Warehouse
  • Credentials stored securely in report server checked
    • User Name : This should be whatever you use for your TFS reporting services (i.e. TFSReport)
    • Use as Windows credentials when connecting to the data source

Click okay, and the first data source will be created. To create the data source that is tied to the Tfs_Configuration database, click the “New Data Source” again, as done previously, and use the following configuration:

Figure 3: Configuration Data Source Settings

  • Name : Tfs2010ConfigurationDS
  • Connection string : Data Source=<TFSServer>;Initial Catalog=Tfs_Configuration
  • Credentials stored securely in report server checked
    • User Name : This should be whatever you use for your TFS reporting services (i.e. TFSReport)
    • Use as Windows credentials when connecting to the data source

In these two screen shots I used the Administrator account for the data sources, but I want to make it clear that the account used for the TFS reporting services is the account that should be used for these data sources.

Once all is said and done, your SSRS Home page should have the two new data source listed with a “!New” tag sitting next to them.

Figure 4 : SSRS Home Page after the two data sources have been added

Conclusion

With these data sources added to the SSRS web site, getting the reports in the TFS Performance Report Pack and the TFS Administration Report Pack to work is just a matter of uploading them. Having these reports can add a great deal of value to your Kanban or Scrum process, and being able to quickly and quite easily set them up is a huge bonus.

-James Tupper

Print Friendly
Tagged with →