locked
Read/Write capability in BCS RRS feed

  • Question

  • Can someone tell me what exactly does "Read/Write Capability" means in Business Connectivity Services for SharePoint 2010?

    I read it somewhere that this is a new feature in 2010 which was not present in 2007. But as far as I know, BCS was present in 2007 so I wonder how can BCS work without Read capability at least in 2007 because it doesn't look like a new feature to me.

    Sunday, March 17, 2013 10:02 AM

Answers

  • Hi,

    BDC in SharePoint 2007 has capability to only read data from external sources but now in SharePoint 2010/2013 BCS has capability to Read and Write data from/to external sources.

    http://msdn.microsoft.com/en-us/library/ee557658(v=office.14).aspx


    Regards,
    Fadi Abdulwahab, SharePoint Consultant
    http://blogs.msdn.com/b/fabdulwahab
    http://sqlgoogler.blogspot.com/

    Sunday, March 17, 2013 12:16 PM
  • BCS Application Definitions in 2007 only implemented a Select command by default.  That means that they were limited to Read Only Operations.  In 2010 Application Definitions were expanded to allow for Select, Update, Insert, and Delete commands (or there equivalent in non-SQL systems).  So in 2010 if you provide the appropriate commands it can be fully Read/Write.

    Paul Stork SharePoint Server
    MVP Principal Solutions Architect: BlueChip Consulting Group
    Blog: http://dontpapanic.com/blog
    Twitter: Follow @pstork
    Please remember to mark your question as "answered" if this solves your problem.

    Sunday, March 17, 2013 12:16 PM

All replies

  • Hi,

    BDC in SharePoint 2007 has capability to only read data from external sources but now in SharePoint 2010/2013 BCS has capability to Read and Write data from/to external sources.

    http://msdn.microsoft.com/en-us/library/ee557658(v=office.14).aspx


    Regards,
    Fadi Abdulwahab, SharePoint Consultant
    http://blogs.msdn.com/b/fabdulwahab
    http://sqlgoogler.blogspot.com/

    Sunday, March 17, 2013 12:16 PM
  • BCS Application Definitions in 2007 only implemented a Select command by default.  That means that they were limited to Read Only Operations.  In 2010 Application Definitions were expanded to allow for Select, Update, Insert, and Delete commands (or there equivalent in non-SQL systems).  So in 2010 if you provide the appropriate commands it can be fully Read/Write.

    Paul Stork SharePoint Server
    MVP Principal Solutions Architect: BlueChip Consulting Group
    Blog: http://dontpapanic.com/blog
    Twitter: Follow @pstork
    Please remember to mark your question as "answered" if this solves your problem.

    Sunday, March 17, 2013 12:16 PM