Export (0) Print
Expand All

Configure Business Connectivity Services solutions for SharePoint 2013

SharePoint 2013

Updated: April 9, 2013

Summary: Find links to procedures to help you install and configure SharePoint 2013 Business Connectivity Services (BCS) for the on-premises, cloud-only, and hybrid solutions, and other scenarios.

Applies to:  SharePoint Foundation 2013 | SharePoint Server 2013 

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.

About Business Connectivity Services installation scenarios

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 procedures in 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.

Prerequisites

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.

On-premises deployment

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.

Cloud-only deployment

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.

Hybrid deployment

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.

Change History

Date Description

April 09, 2013

Added new section: "Deploy a Business Connectivity Services hybrid solution in SharePoint 2013."

July 16, 2012

Initial publication

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft