In continuation with my previous post on Creating a SQL Server Reporting Services (SSRS) Project, you will now learn how to create a Shared Data Source within that project. In this post I compare and contrast Shared and Embedded Data Sources and demonstrate how to create a Share Data Source.
A Data Source is a data connection that includes the type of data source that you are connecting to, the connection information (Server Name, Database Name), and the credential type (Windows or SQL Authentication for example). For more information on Data Sources got to:
In this posting I will explain how to create a Share Data Source. When we get to the point when we create an actual SSRS Report I will explain and demonstrate how to create an Embedded Data Source.
When developing SSRS projects you have two choices when creating Data Sources, Shared or Embedded. The primary difference between the two is that the Shared source can be used by all reports in the project, while the Embedded source can only be used by the report in which it is created. Therefore, if a change occurs that affects an Embedded source (change to server name, database name, logon credentials, etc…) someone will be required to update the configurations within each report. So if you create 50 reports that include the same Embedded source, you would need to open each report and update the affected data source. On the other hand, if the same reports used a Shared source, the change would only need to be made in one place. This will become clearer once you actually create both types of sources. In addition to the aforementioned, the Shared sources are publishable and are required for Share Datasets, which will be discussed later in this series.
Download: Creating Share Data Source
In the next post, SSRS 101 – Creating a Shared Dataset, I will explain and demonstrate how to create a shared dataset.
Talk to you soon,
Patrick LeBlanc, Microsoft, Technical Solutions Professional SQL Server and Business Intelligence