Sharepoint 2010 Report Server File Sync Feature

If your users will frequently upload published Report Server items directly to SharePoint document libraries, you may want to consider enabling the Sharepoint 2010 File Sync feature as a best practice.

The Report Server File Sync Feature synchronizes Report Server files (.rdl, .rsds, .smdl, .rsd, .rsc) from a SharePoint document library to the report server when files are added or updated in the document library.

But what does this mean ? I have already integrated Reporting Services with Sharepoint, I thought this would already be the case!   Yes and No.  The File Sync features utilises Sharepoint event handlers to synchronize the report server catalog with items in document libraries more frequently. The reality is that in an integrated Reporting Services environment you have a Report Server database and a seperate Sharepoint Content databases that share information.   If the File Sync feature is not activated, content will still be synchronized but not as frequently, so why take the risk.

A classic example is if you are utilising third party products to build scheduled solution documentation snapshots such as Pragmatic Works BI Documenter.   This tool reads the Report Server catalog (as well as the database, SSIS and SSAS components) to build an exact as built snapshot of your current Microsoft B.I. content and solutions.  This gives you the ability to find out what has changed between any two snapshots, hence an excellent example of why you would want the Report Server catalog kept strictly up to date.

and Setup is mindless….

1. From the main page of your site, click the Site Actions menu and click Site Settings

2. In the Site Actions click Manage Site Features

3. Find Report Server File Sync in the list

4. Click Activate

 

About AussieBICG

Connect with me here https://au.linkedin.com/in/aussiebicg

1 Response

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s