Skip to content

compare-shared-embedded-data-sources-report-builder-ssrs.md

Latest commit

 

History

History
52 lines (35 loc) · 4.8 KB

compare-shared-embedded-data-sources-report-builder-ssrs.md

File metadata and controls

52 lines (35 loc) · 4.8 KB
title Compare shared and embedded data sources - Report Builder & Reporting Services | Microsoft Docs
ms.date 11/18/2019
ms.prod reporting-services
ms.prod_service reporting-services-native
ms.technology report-data
ms.topic conceptual
author maggiesMSFT
ms.author maggies

Compare shared and embedded data sources - Report Builder & Reporting Services (SSRS)

[!INCLUDE ssrs-appliesto] [!INCLUDE ssrs-appliesto-2016-and-later] [!INCLUDEssrs-appliesto-pbirsi] [!INCLUDEssrs-appliesto-sharepoint-2013-2016i]

You can connect to data with either a shared or an embedded data source. A shared data source is defined independent of any report. You can use it in multiple reports on a report server or SharePoint site. An embedded data source is defined in a report. You can only use it in that report.

Shared data sources are useful when you have data sources that you use often. We recommend that you create and use shared data sources as much as possible. They make reports and report access easier to manage, and help to keep reports and the data sources they access more secure. If you need a shared data source, you may need to ask your system administrator to create one for you.

An embedded data source, also known as a report-specific data source, is a data connection that's saved in the report definition. Embedded data source connection information can be used only by the report in which it's embedded. To define and manage embedded data sources, use the Data Source Properties dialog box.

The difference between embedded and shared data sources is in how they are created, stored, and managed.

  • In Report Designer, create embedded or shared data sources as part of a [!INCLUDEssBIDevStudioFull] project. You can control whether to use them locally for preview or to deploy them as part of the project to a report server or SharePoint site. You can use custom data extensions that have been installed on your computer and on the report server or SharePoint site where you deploy your reports.

    System administrators can install and configure additional data processing extensions and .NET Framework data providers. For more information, see Data Processing Extensions and .NET Framework Data Providers (SSRS).

    Developers can use the xref:Microsoft.ReportingServices.DataProcessing API to create data processing extensions to support additional types of data sources.

  • In [!INCLUDEssRBnoversion], browse to a report server or SharePoint site and select shared data sources or create embedded data sources in the report. You can't create a shared data source in [!INCLUDEssRBnoversion]. You can't use custom data extensions in [!INCLUDEssRBnoversion].

Summary of differences

The following table summarizes the differences between embedded and shared data sources.

Description Embedded

Data Source		 Shared

Data Source
Data connection is embedded in the report definition. Available
Pointer to the data connection on the report server is embedded in the report definition. Available
Managed on the report server Available Available
Required for shared datasets Available
Required for components Available

Next steps

Create and Manage Shared Data Sources
Create and Modify Embedded Data Sources
Set Deployment Properties
Specify Credential and Connection Information for Report Data Sources

More questions? Try asking the Reporting Services forum