Search This Blog

Loading...

Monday, January 9, 2012

Business Connectivity Services Limitations

Even though BCS is great and can do wonders when you want SharePoint 2010 to interact with your external systems or other LOB applications, it has its own limitations. Understanding these limitations will help you build good BCS solutions.

Below are some/all of the BCS/External Lists limitations:
  1. Workflows cannot be associated with external lists
    • However, you can use the external data columns and manipulate the external lists in a workflow.
  2. No RSS feed support for external lists.
  3. No REST based access for external lists
  4. LINQ to SharePoint spmetal.exe does not support external lists
  5. Cannot configure alerts for external lists
  6. Cannot export external list items to Excel (Export to Excel feature)
  7. Item-Level permissions is not available for external lists
  8. Versioning cannot be configured on external lists
  9. Item History is not available on external lists
  10. Datasheet view cannot be used in external lists
    • XSLT is supported though
  11. You cannot create a site column of type ‘External Data Column’
    • External data columns can be created only as list based columns and cannot be consumed in site level content types
  12. No Write support for BLOB
    • You cannot write back to BLOB fields using BCS unless you write your own method
    • You can access BLOB columns by defining a StreamAccessor method and presenting the external data via the BCS Data List web part by checking the Display stream fields property
  13. Ratings feature is not supported for external lists
  14. Metadata based navigation is not supported for External Lists
Some of the limitations are quite obvious as the data does not reside in SharePoint and it is not SharePoint’s responsibility on how the data behaves. SharePoint is here to just present the external data. That said, I do think some are not limitations, but Microsoft just didn’t have time to implement, like:
  1. RSS feed support
  2. External data site columns
  3. Export to Excel

7 comments:

  1. Hi! Would you mind if I share your blog with my facebook group?
    There's a lot of folks that I think would really enjoy your content. Please let me know. Thanks

    my website ... mybookmarkingblog.com

    ReplyDelete
  2. I love your blog.. very nice colors & theme. Did you design
    this website yourself or did you hire someone to do it for you?

    Plz reply as I'm looking to design my own blog and would like to find out where u got this from. many thanks

    Feel free to visit my weblog; local white page listings

    ReplyDelete
  3. It's actually a cool and helpful piece of info. I am happy that you simply shared this useful information with us. Please stay us up to date like this. Thank you for sharing.

    My web-site: local zenith television store

    ReplyDelete
  4. Hello there! I could have sworn I've visited your blog before but after going through many of the articles I realized it's new
    to me. Regardless, I'm definitely pleased I came across it and I'll
    be bookmarking it and checking back often!

    My page - research paper citations

    ReplyDelete
  5. I'm truly enjoying the design and layout of your website. It's a very easy on the eyes which
    makes it much more enjoyable for me to come here and visit more
    often. Did you hire out a designer to create your theme?
    Outstanding work!

    Look into my web page ... pfister 806-dy11

    ReplyDelete
  6. Hi i am kavin, its my first time to commenting anyplace,
    when i read this piece of writing i thought i could also create comment due to this good
    article.

    My web page - sell broken computers Charlotte

    ReplyDelete
  7. I'm impressed, I have to admit. Seldom do I encounter a blog that's both educative and entertaining,
    and let me tell you, you have hit the nail on
    the head. The problem is something that not enough people are speaking intelligently
    about. I am very happy that I came across this during my search for something regarding this.


    Also visit my web blog; free essay proofreading

    ReplyDelete

ShareThis