Deploy a Business Connectivity Services hybrid solution in SharePoint

  • Articolo

 

**Si applica a:**SharePoint Online, SharePoint Server 2013, SharePoint Server 2016

**Ultima modifica dell'argomento:**2017-06-22

Summary: Learn how to configure the Business Connectivity Services (BCS) hybrid scenario to access on-premises data through SharePoint Online.

This article is part of a roadmap of procedures for configuring SharePoint hybrid solutions. Be sure you're following a roadmap when you do the procedures in this article.

The Servizi di integrazione applicativa Microsoft (BCS) hybrid deployment scenario allows you to securely publish on-premises data to an external list or app per SharePoint in SharePoint Online. From there, users can view and edit the data, depending on the permissions that they have.

In this scenario, you will learn how to:

  • Configure your on-premises environment so that you can securely publish confidential business data to your SharePoint Online tenancy.

  • Create and configure an OData service endpoint and an external content type with Visual Studio 2012.

  • Prepare your SharePoint Online tenancy to host an app per SharePoint or an external list, which makes the external data available to your extranet users.

  • Create a connection settings object that tells Servizi di integrazione applicativa in SharePoint Online how to connect to the on-premises OData service endpoint.

  • Deploy an app per SharePoint or external list to SharePoint Online.

  • Validate and troubleshoot the BCS hybrid scenario.

In this article:

  • What these procedures help you deploy

  • How to use these procedures

  • Roadmap of the procedures

What these procedures help you deploy

BCS is a centralized infrastructure in SharePoint Server, Office 2016, and SharePoint Online that enables you to integrate data that is not in SharePoint products or Office 2016 into SharePoint Server. BCS implementations take many forms. This includes this hybrid form that uses SharePoint Online and SharePoint Server on-premises. These procedures show how to install and configure BCS to integrate data from an on-premises OData service endpoint into SharePoint Online. For this scenario, we use the AdventureWorks sample SQL database and create an OData service head for the database. The solution looks as shown in the following diagram.

Figure: Hybrid BCS solution

Shows the sequence of actions for BCS hybrid

  1. An information worker logs on to SharePoint Online by using their federated account and opens an app per SharePoint or external list that needs data from an on-premises OData data source.

  2. The external list creates a request for the data and sends it to Servizi di integrazione applicativa. Servizi di integrazione applicativa looks at the connection settings object to see how to connect to the data source and which credentials to use.

  3. Servizi di integrazione applicativa retrieves two sets of credentials:

    1. The Secure Channel certificate from archiviazione sicura in SharePoint Online. This is used for SharePoint Online authentication to the reverse proxy.

    2. An OAuth token from the Azure AD Service. This is used for user authentication to the SharePoint Server farm. You gain access to the Azure AD service with your SharePoint Online subscription. It is a security token service that manages security tokens for users of SharePoint Online.

  4. Servizi di integrazione applicativa sends an HTTPS request to the published endpoint for the data source. The request includes the client certificate from archiviazione sicura, the OAuth token, and a request for the data. The reverse proxy authenticates the request by using the client certificate and forwards it to the on-premises SharePoint Server farm. For more information about publishing SharePoint to the Internet, see SharePoint publishing solution guide in the Forefront Technical Library.

  5. The on-premises farm retrieves the user’s cloud identity from the OAuth token (for example, user123@contoso.com), and through the Client Side Object Model (CSOM) code, maps it to the on-premises identity (for example, contoso\user123). The on-premises credentials are mapped to credentials that have access to the external data via a archiviazione sicura target application.

  6. The on-premises Servizi di integrazione applicativa forwards the request to the OData Service endpoint. The OData Service authenticates the request (via IIS) and returns the data, which is passed back through the chain to the external list for the user to work with.

Video: Watch a demonstration of the BCS hybrid scenario

How to use these procedures

The steps to completely deploy this scenario are presented in smaller procedures. Some of the procedures are on TechNet, some are on Office.com, and some are on MSDN. Each procedure is numbered indicating its position in the overall sequence. At the beginning and end of each procedure, links direct you to the previous and following steps. The following list contains links to all of the procedures, in the required order, for your reference. Be aware that this list includes the steps to deploy an external list and an app per SharePoint. You can deploy one or the other or both, depending on your needs. You should skip the steps for whichever configuration you don’t want to deploy. You must follow them in sequence to build out the scenario. You can also use these procedures individually for your own unique scenarios. When you assemble individual procedures to build out your own scenarios, it is important that you test the complete set of procedures, in order, in a lab setting before you try them in production.

Roadmap of the procedures

To configure the BCS hybrid solution:

  1. Follow the procedures in Predisporre l'ambiente per lo scenario ibrido dei servizi di integrazione applicativa to configure the underlying settings and services needed.

  2. If you want to use an external list, follow the procedures in Distribuire lo scenario ibrido di Servizi di integrazione applicativa come elenco esterno.

  3. Follow the procedures in Convalidare lo scenario ibrido dei servizi di integrazione applicativa to validate your setup.

See also

Ambiente ibrido per SharePoint Server
Pianificare un ambiente ibrido di SharePoint Server
Installare e configurare SharePoint Server ibrido

Introducing OData: Data Access for the Web, the cloud, mobile devices, and more