Home > SSRS > Managing Shared Data source – SSRS

Managing Shared Data source – SSRS


A shared data source specifies connection properties for a data source.

A shared data source can be used share the connection string with large number of reports, models, or data-driven subscriptions

This is a best practice consider creating a shared data source to eliminate the overhead of having to maintain the same connection information in multiple places and with multiple name.

Creating a shared Data source in BIDS

Step 1: Create a new report project and give project name and store location.

pic1

Step 2: create a new shared data source. On solution explorer, right-click on the share data sources node and create a new data source.

pic2

Step 3: Enter Data Source name, choose data source type and connection string (you can build connection string by clicking edit button on right side of connection string text box) in this dialogue box. Click Edit button.

pic3

Step 4: Create connection string in this dialogue box. Enter server name, server authentication information and database name.

pic4

Step 5: choose the credential for data source in the credentials tab of Shared Data source properties.

pic5

Deploying shared Data source into Report Server

Step 6: Go to Report project property page. Right click on Report project solution in solution explorer and click on property menu item.

pic6

Step 7: Enter report deployment property details for TargetServerURL, TargetDataSourceFolder, OverwriteDataSources.

Note 1: TargetServerURL should have proper server name instead localhost.

For instance: Http:///reportserver

Note 2: we have to remove property values for TargerDataSetFolder, TargetReportFolder, TargetReportPartFolder.

pic7

Step 8: To deploy a data source. Right click on the data source name and select deploy menu item.

pic8Conclusion

Shared Data helps to keep data source deployment process separate from report. So, We can manage database connection more securely and easy manageable.

Advertisements
Categories: SSRS Tags: ,
  1. No comments yet.
  1. No trackbacks yet.

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

%d bloggers like this: