Setting Up BCS Hybrid Features End to End In SharePoint 2013

For those of you who will be attending SharePoint Conference 2014 (, I'm going to be teaching a half-day course after the three main days with Bill Baer and some other folks on SharePoint Hybrid features.  This is firming up to be a pretty good session from a presenter standpoint, because we'll have folks from SharePoint Marketing (Bill), other members of the SharePoint Product Group (Luca, Steve W. and Neil), the Microsoft Technology Center in Irvine (Ali), and our lead / best escalation engineer for SharePoint hybrid (Manas).  That's a whole lot of hybrid expertise in one location so if you have a chance to attend check out the "SharePoint Server 2013 and Office 365 Hybrid" session in the listings at

One of the things that I'll be covering in that session is getting the BCS hybrid features to work.  At a high level, the goal of the BCS hybrid features are to allow you to access your on-premises line of business data from within your Office 365 tenant.  As I've started scraping together some content for this topic, I realized that I did not see a really comprehensive "end-to-end" walk through of how to make this work; it's really a series of documents and blog posts.  So…while getting a sample up and running in the lab I made a list of all the different resources I pulled info from to get things going.  In this post I'm just going to do an outline of what those steps and resources are; if there is need / demand still, then once we've delivered on the SharePoint Conference I may try and flesh this out with pictures, examples and more detailed instructions.  For now I'm hoping you can just follow the steps in order, track down the links I provide to pull together the data you need, and use that to build your BCS hybrid applications.

1.  Find / Create an OData data source:  See 2nd half of
2.  Publish your OData endpoint (https):  you need to have an HTTP/HTTPS endpoint from which your OData content is accessible
3.  Create an External Content Type based on your OData data source:
4.  Make your ECT file “tenant ready”:  See 1st half of
5.  Create a connection to your on premises services:  Follow the tips described here:
6.  Upload your model (.ECT) file to o365 BCS:  Follow the rest of the tips here:
7.  Create a new External List and use the BCS model you uploaded:  once your model is uploaded successfully you can create a new External List in o365 and use that to work with your on-premises LOB data.

Let me know how far this gets you, or the trouble spots you might run up against and we'll see what we can do to address them as time permits.  If you're coming to the SharePoint Conference hopefully I'll get a chance to meet up and talk with you there.

Comments (11)

  1. Ed (DareDevil57) says:

    thanks for sharing.

  2. alexandrad9x says:


  3. Anonymous says:

    First let me point out that I gratuitously co-mingled the terms "BCS" and "BDC" in

  4. Allan says:

    *SharePoint Conference 2014

  5. Anonymous says:

    Como estrenamos mes nuevo, toca un nuevo recopilatorio de enlaces sobre SharePoint 2013. Como siempre

  6. Josh says:

    Steve, thanks for this. Just what I am needing. Although, if you feel up to the challenge, I would love to see an authoritative post/walkthrough on this topic, or even video from the above mentioned session if it’s possible, since not everyone (like myself) can make it you to SPC14.

  7. Anonymous says:

    In a hybrid environment that uses Microsoft SharePoint Server 2013 and SharePoint Online enables shared functionality between services and features. In this post, Microsoft Technology Center (MTC) Architect Ali Mazaheri discusses why and how to implement

  8. Shirley Schimdt says:

    Thanks for the information. It is helpful. I have just signed up for free SharePoint 2013 site with to explore more about SharePoint. I am just a beginner.

  9. SDF says:

  10. m88 says:

    m88 : offer online sports games Asia, Sports Betting Asia, Sports Betting Sites Asia.

    m88asia :
    Link to M88BET phone: – Register and Open Betting Account and Membership M88BET.

    m88bet :
    MANSION88 the house is one of the largest and most prestigious. Appeared quite early in the Asian market, the so-MANSION88 currently attracts more players.

    link m88 :
    Home the M88 is the official sponsor of the football club in the Premier League
    Wish you happy with the new M88
    m88 casino online :

    Modern Thai restaurant combines outstanding traditional cuisine and a subtle modern decor with a warm welcoming ambience. Thai Restaurants in Brisbane : , traveller reviews of Brisbane Thai restaurants and search by price, location, and more..