Create and configure an OData service endpoint for the Business Connectivity Services hybrid scenario
Applies to: SharePoint Server 2013
Topic Last Modified: 2013-12-18
Summary: Learn how to configure an OData service endpoint for a SQL database for the Business Connectivity Services (BCS) hybrid scenario.
|This documentation is preliminary and subject to change.|
To configure a hybrid SharePoint environment, you need a combination of expert skills and significant hands-on experience with SharePoint Server 2013, SharePoint Online, and related products and technologies. We recommend that you engage Microsoft Consulting Services to provide technical guidance and support during the design and deployment of your hybrid environment.|
For more information about Microsoft Consulting Services, see Microsoft Services.
The Business Connectivity Services (BCS) hybrid scenario supports connecting only to an OData source. If your external data already has an OData service endpoint, then you can skip the creating an OData service endpoint portions of this procedure. You will still need to configure permissions on the service endpoint for the ODataAccount. For the purposes of these procedures, we use the Adventureworks sample SQL Server database (AdventureWorks 2012 LT sample database script and the AdventureWorks 2012 LT sample data) as the data source and create an OData service endpoint to make the data available to the BCS hybrid solution. You use Visual Studio 2012 to create and configure the OData service.
This is Step 3 in the Business Connectivity Services hybrid scenario deployment procedures.
Perform the procedures in How to: Create an OData data service that sends notifications to BCS in SharePoint 2013 in the MSDN Library. You will need the on-premises account that was configured in Prepare the on-premises environment for the Business Connectivity Services hybrid scenario to secure the service endpoint in Internet Information Services (IIS) 7.0. For example, these procedures use an account named ODataAccount.
When you finish creating the OData service endpoint, go to Prepare the SharePoint Online environment for the Business Connectivity Services hybrid scenario.
|Link to Step 4 Prepare the SharePoint Online environment for the Business Connectivity Services hybrid scenario of the Business Connectivity Services hybrid scenario deployment procedures.|