---
title: "Create an Embedded or Shared Data Source (SSRS) | Microsoft Docs"
ms.custom: ""
ms.date: "03/08/2017"
ms.prod: "sql-server-2014"
ms.reviewer: ""
ms.technology: "reporting-services-native"
ms.topic: conceptual
helpviewer_keywords: 
  - "data sources [Reporting Services], creating"
ms.assetid: b111a8d0-a60d-4c8b-b00a-51644b19c34b
author: maggiesMSFT
ms.author: maggies
manager: kfile
---
# Create an Embedded or Shared Data Source (SSRS)
  A report data source specifies a name and connection information. [!INCLUDE[ssRSnoversion](../includes/ssrsnoversion-md.md)] supports two types of data sources: embedded and shared. An embedded data source is defined in a report definition and used only by that report. A shared data source is defined as a separate item and can be used by multiple reports. For more information, see [Embedded and Shared Data Connections or Data Sources (Report Builder and SSRS)](../../2014/reporting-services/embedded-and-shared-data-connections-or-data-sources-report-builder-and-ssrs.md).  
  
 In Report Builder, you browse to the report server or SharePoint site and select data sources or create embedded data sources. You cannot create shared data sources in Report Builder.  
  
 In Report Designer, you can create shared or embedded data sources. From the Report Data pane, begin to create a data source reference, and then select the **New** option. After you create the data source reference, a new shared data source will automatically be added to Solution Explorer under the Shared Data Sources folder.  
  
> [!NOTE]  
>  [!INCLUDE[ssRBRDDup](../includes/ssrbrddup-md.md)]  
  
 You can also create shared data sources directly on a report server or SharePoint site. For more information, see [Create, Delete, or Modify a Shared Data Source (Report Manager)](../../2014/reporting-services/create-delete-or-modify-a-shared-data-source-report-manager.md) or [Create and Manage Shared Data Sources (Reporting Services in SharePoint Integrated Mode)](../../2014/reporting-services/create-manage-shared-data-sources-reporting-services-sharepoint-integrated-mode.md).  
  
### To create an embedded or shared data source  
  
1.  On the toolbar in the Report Data pane, click **New** and then click **Data Source**. The **Data Source Properties** dialog box opens.  
  
    > [!NOTE]  
    >  If the Report Data pane is not visible, click **Report Data** on the **View** menu.  
  
2.  In the **Name** text box, type a name for the data source or accept the default. The data source name is used internally within the report. For clarity, we recommend that the name of the data source contain the name of the database specified in the connection string.  
  
3.  For an embedded data source, verify that **Embedded connection** is selected.  
  
    1.  From the **Type** drop-down list, select a data source type; for example, **Microsoft SQL Server** or **OLE DB**.  
  
    2.  Specify a connection string using one of the following alternatives:  
  
    -   Type the connection string directly in the **Connection string** text box. For a list of example connection strings, see [Data Connections, Data Sources, and Connection Strings in Report Builder](../../2014/reporting-services/data-connections-data-sources-and-connection-strings-in-report-builder.md) or [Data Connections, Data Sources, and Connection Strings in Reporting Services](../../2014/reporting-services/data-connections-data-sources-and-connection-strings-in-reporting-services.md).  
  
    -   Click the expression (**fx)** button to create an expression that evaluates to a connection string. In the **Expression** dialog box, type the expression in the Expression pane. [!INCLUDE[clickOK](../includes/clickok-md.md)]  
  
    -   Click **Edit** to open the **Connection Properties** dialog box for the data source type you chose in step 2.  
  
         Fill in the fields in the **Connection Properties** dialog box as appropriate for the data source type. Connection properties include the type of data source, the name of the data source, and the credentials to use. After you specify values in this dialog box, click **Test Connection** to verify that the data source is available and that the credentials you specified are correct. For more information about specific data source types, see topics in [Add Data from External Data Sources (SSRS)](report-data/add-data-from-external-data-sources-ssrs.md).  
  
4.  For a shared data source, verify that **Use shared data source reference** is selected.  
  
    1.  Click **New**. In the **Shared Data Source** properties dialog box, follow steps 2 and 3 to create a new data source.  
  
    2.  [!INCLUDE[clickOK](../includes/clickok-md.md)]  
  
         The new shared data source appears in the Shared Data Sources folder in Solution Explorer.  
  
5.  [!INCLUDE[clickOK](../includes/clickok-md.md)]  
  
     The data source appears in the Report Data pane. In the Report Data pane, a shared data source points to the data source definition. In Report Builder, the data source definition is on a report server or SharePoint site. In Report Designer, the data source definition is a file in Solution Explorer under the Shared Data Sources folder.  
  
### To import an existing data source in Report Designer  
  
1.  In Solution Explorer, right-click the **Shared Data Sources** folder in the report server project, and then click **Add Existing Item**. The **Add Existing Item** dialog box opens.  
  
2.  Navigate to an existing Report Definition Shared data source (rds) file and then click **Open**.  
  
3.  [!INCLUDE[clickOK](../includes/clickok-md.md)]  
  
### To convert an embedded data source to a shared data source in Report Designer  
  
-   In the Report Data pane, right-click the data source and then click **Convert to Shared Data Source**.  
  
### To convert a shared data source to an embedded data source in Report Builder  
  
-   In the Report Data pane, right-click the data source and open **Data Source Properties**.  
  
-   Click **Embedded Connection** and finish creating the embedded data source as described in an earlier procedure.  
  
## See Also  
 [Store Credentials in a Reporting Services Data Source](report-data/store-credentials-in-a-reporting-services-data-source.md)   
 [Embedded and Shared Data Connections or Data Sources (Report Builder and SSRS)](../../2014/reporting-services/embedded-and-shared-data-connections-or-data-sources-report-builder-and-ssrs.md)   
 [Convert a Data Source from Embedded to Shared (Report Builder and SSRS)](report-data/convert-data-sources-report-builder-and-ssrs.md)   
 [Bind a Report or Model to a Shared Data Source (SSRS)](report-data/bind-a-report-or-model-to-a-shared-data-source-ssrs.md)   
 [Configure Data Source Properties for a Report  (Report Manager)](report-data/configure-data-source-properties-for-a-report-report-manager.md)   
 [Data Sources Supported by Reporting Services (SSRS)](create-deploy-and-manage-mobile-and-paginated-reports.md)