Deploy a Business Connectivity Services cloud-only solution in SharePoint 2013

SharePoint 2013

We are in the process of combining the SharePoint Server 2013 and SharePoint Server 2016 content into a single content set. We appreciate your patience while we reorganize things. See the Applies To tag at the top of each article to find out which version of SharePoint an article applies to.


Applies to: SharePoint Server 2013

Topic Last Modified: 2016-12-16

Summary: How to configure Business Connectivity Services (BCS) in SharePoint Online to access Azure SQL Database.

The following scenario shows how to create a Microsoft Business Connectivity Services solution in SharePoint Online to access Azure SQL Database. You will learn how to:

  • Configure the Business Connectivity Services in SharePoint Online.

  • Configure a Secure Store Service target application to map credentials between SharePoint Online and SQL Database.

  • Create an external content type by using SharePoint Designer 2010.

  • Create an external list in SharePoint Online.

  • Grant permissions to manage the external content type.

In this article:

Because SharePoint 2013 runs as websites in Internet Information Services (IIS), administrators and users depend on the accessibility features that browsers provide. SharePoint 2013 supports the accessibility features of supported browsers. For more information, see the following resources:

Business Connectivity Services is a shared service in SharePoint Online. In SharePoint Online you can make external data visible through external lists or through apps for SharePoint. In this example, we use external lists. The solution looks as shown in the following diagram.

Figure: Cloud-only BCS solution

The sequence of data flow for BCS All In The Cloud
  1. The user logs on to SharePoint Online and opens an external list that the user has rights to.

  2. The Business Data Connectivity service runtime queries the external content type for the list in the Business Data Connectivity service metadata store to learn how to access the external system, which operations can be performed, and which credentials to use. The external content type tells the Business Data Connectivity service runtime to retrieve the necessary credentials from the Secure Store.

  3. The Business Data Connectivity service runtime passes the request (SOAP over HTTP) to the endpoint of the SQL Azure Windows Communication Foundation (WCF) service.

  4. The SQL Azure service returns the data in a SOAP envelope.

  5. The SharePoint Online site displays the external list in the user’s browser. The user can then perform all the configured operations on the data source for which the user has permissions.