Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Create and configure an OData service endpoint for the Business Connectivity Services hybrid scenario

SharePoint 2013

Published: April 9, 2013

Summary: Learn how to configure an OData service endpoint for a SQL database for the Business Connectivity Services (BCS) hybrid scenario.

Applies to:  SharePoint Server 2013 

note Note:

This documentation is preliminary and subject to change.

Warning Warning:

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.

Important Important:

This is Step 3 in the Business Connectivity Services hybrid scenario deployment procedures.

To create and configure the OData service endpoint

  1. 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.

  2. When you finish creating the OData service endpoint, go to Prepare the SharePoint Online environment for the Business Connectivity Services hybrid scenario.

Important Important:

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.