Configure Business Connectivity Services solutions for SharePoint 2013
Applies to: SharePoint Foundation 2013, SharePoint Server 2013
Topic Last Modified: 2014-11-14
Summary: Find links to steps that will help you install and configure SharePoint 2013 Business Connectivity Services (BCS). Choose from on-premises, cloud-only, and hybrid BCS solutions.
This article is your starting place for the procedures to install common Microsoft Business Connectivity Services scenarios for SharePoint 2013. The Business Connectivity Services solution that you deploy will most likely look different from the solutions presented here, but you can model your installation on these examples. Also, you can select the individual procedures from here to build your own procedural documents for your Business Connectivity Services solution scenario.
Every Business Connectivity Services solution is unique because each business has unique data integration problems that it solves with Business Connectivity Services. The solutions can range from something simple and straightforward that a power user or IT professional (who has the appropriate permissions) can perform by themselves, to complex solutions that require developer, IT professional, and end-user solution development involvement.
This guide presents the configuration choices for the common scenarios.
On-premises deployment All the Business Connectivity Services components are under your organizations control behind your firewall.
Cloud-only deployment All the Business Connectivity Services components are in SharePoint Online.
Hybrid deployment SharePoint Online uses Business Connectivity Services to connect to data that lives in the cloud.
Before you begin with any Business Connectivity Services scenario configuration, make sure that you have read Overview of Business Connectivity Services in SharePoint 2013 and completed the steps in Plan a Business Connectivity Services solution in SharePoint 2013.
The procedures in Deploy a Business Connectivity Services on-premises solution in SharePoint 2013 show you how to deploy a solution that involves the following:
A Business Connectivity Services infrastructure that is on your corporate network.
Information workers who access the Business Connectivity Services solution are on your corporate network.
External content that is surfaced in SharePoint as an external list.
External content that is synchronized into Outlook for offline use.
Accessing external data that is in SQL Server database on your corporate network.
SharePoint Designer 2013 to create the external content type for the SQL Server data source.
The Secure Store Service to manage mapping of user credentials to group credentials for accessing the external systems.
The procedures in Deploy a Business Connectivity Services cloud-only solution in SharePoint 2013 show you how to deploy a solution that involves a Business Connectivity Services infrastructure that is in SharePoint Online.
The procedures in Deploy a Business Connectivity Services hybrid solution in SharePoint 2013 shows you how to publish on-premises data to an external list or app for SharePoint in SharePoint Online.