Share via

Setting Up BCS Hybrid Features End to End In SharePoint 2013

  • Article

For those of you who will be attending SharePoint Conference 2014 (www.sharepointconference.com), 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 https://www.sharepointconference.com/content/pre-post-days.

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 https://blogs.technet.com/b/speschka/archive/2012/12/06/using-odata-and-ects-in-sharepoint-2013.aspx
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:  https://msdn.microsoft.com/library/office/jj163967.aspx
4. Make your ECT file “tenant ready”:  See 1st half of https://blogs.technet.com/b/speschka/archive/2012/12/06/using-odata-and-ects-in-sharepoint-2013.aspx
5. Create a connection to your on premises services:  Follow the tips described here: https://blogs.technet.com/b/speschka/archive/2013/04/01/troubleshooting-tips-for-hybrid-bcs-connections-between-office-365-and-sharepoint-2013-on-premises.aspx
6. Upload your model (.ECT) file to o365 BCS:  Follow the rest of the tips here: https://blogs.technet.com/b/speschka/archive/2013/04/01/troubleshooting-tips-for-hybrid-bcs-connections-between-office-365-and-sharepoint-2013-on-premises.aspx
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

  • Anonymous
    January 01, 2003
    thanks for sharing.
  • Anonymous
    January 01, 2003
    The comment has been removed
  • Anonymous
    January 15, 2014
    First let me point out that I gratuitously co-mingled the terms "BCS" and "BDC" in
  • Anonymous
    January 28, 2014
    *SharePoint Conference 2014
  • Anonymous
    February 01, 2014
    Como estrenamos mes nuevo, toca un nuevo recopilatorio de enlaces sobre SharePoint 2013. Como siempre
  • Anonymous
    March 04, 2014
    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.
  • Anonymous
    March 12, 2014
    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
  • Anonymous
    April 30, 2014
    Thanks for the information. It is helpful. I have just signed up for free SharePoint 2013 site with http://www.cloudappsportal.com/ to explore more about SharePoint. I am just a beginner.
  • Anonymous
    September 18, 2014
    The comment has been removed
  • Anonymous
    January 08, 2015
    m88 : http://m88en.com
    M88.com offer online sports games Asia, Sports Betting Asia, Sports Betting Sites Asia.
    m88asia : http://m88en.net
    Link to M88BET phone: m88en.com. – Register and Open Betting Account and Membership M88BET.
    m88bet : http://www.linkm88vip.com
    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 : http://m88wiki.com
    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 : http://m88free.com

    Modern Thai restaurant combines outstanding traditional cuisine and a subtle modern decor with a warm welcoming ambience. Thai Restaurants in Brisbane :http://www.watersidethainoodles.com.au , traveller reviews of Brisbane Thai restaurants and search by price, location, and more..
  • Anonymous
    February 17, 2015
    Personal trainer brisbane: http://bodybuzz.fitness/
    shade sails: http://accreditedsails.com.au/outdoor-shade-sails/
    catering brisbane: http://aurabar.catering/
    equipment finance: http://www.agmequipmentfinance.com.au/