Did you know the BDC only queries the data?

That it actually does NOT import everything but just pulls the data in on demand? You probably just answered yes you already knew that. So why am I playing the role of Captain Obvious? Well, because possibly if the only thing you ever learned about the BDC prior to this was post was from me you might have gotten the above questions wrong. Brad H. from my Boston admin class emailed me today thinking he had misunderstood me. Nope. He heard me correctly, the problem was I was wrong. I will not rehash what I said wrong but will try to say things correctly from now on.

  • You use the Business Data Catalog (BDC) to connect MOSS Enterprise to business data sources (such as PeopleSoft, SAP, Seibel, etc)
  • You can display that data using the business data web parts
  • You can use the data as metadata in lists or libraries
  • You can setup custom actions on the displayed data to interact with it
  • You can make the BDC a content source for search, creating full indexes of the data (this is what cause my confusion)
  • The BDC is defined and administered at the SSP level (Shared Services Provider)
  • The BDC is a MOSS 2007 Enterprise feature only

For more information check out this great full feature information from my buddy Sahil http://blah.winsmarts.com/2007-4-SharePoint_2007__BDC_-_The_Business_Data_Catalog.aspx or the official Microsoft scoop at http://blogs.msdn.com/sharepoint/archive/2006/04/18/business-data-catalog.aspx

Anyway my apologies for the miss-information.


Shane – SharePoint Consulting

6 Comments so far

  1.   Todd Klindt on January 28th, 2008          Reply

    I still love you buddy.


  2.   Paul Galvin on January 29th, 2008          Reply

    Congrats and good for you for posting this. It’s darn hard to write posts like this one. That’s the risk of putting yourself “out there” in the public domain with blogs or writing on forums, etc.

    –Paul Galvin

  3.   Brad Hilton on January 29th, 2008          Reply

    Apology unnecessary – your class was excellent, Shane. Thanks for posting the clarification.


  4.   tbaggs on January 29th, 2008          Reply


    This is a good post from a very technical perspective. However, someone reading this may get the impression that using the BDC as a content source does not leak data from their LOB system into MOSS. This could be a big issue for some companies if they don’t have controls in place to prevent even small leaks of data. I do agree with you that the BDC does not technically store data, however the BDC can be inadvertently used to facilitate the storing of data by other SharePoint technologies. When we look at data security issues, we try to look at the entire surface, not a single point, as such MOSS has the ability to store LOB data depending on how you configure certain knobs.

  5.   Shane on January 29th, 2008          Reply

    Excellent information in “tbaggs” post. He is one of the BDC superstars (and a friend of mine) and makes some good points.


  6.   Adonica on May 13th, 2011          Reply

    HHIS I should have touhght of that!

Leave a Reply