locked
What is the difference between external content type and data source. RRS feed

  • Question

  • Hi,

    What is the difference between external content type and data source in sharepoint designer.

    Since we were able to connect to SQL DB using both options.What is the advantage and disadvantage of these options.

    Thanks,

    Sudan

    Thursday, January 10, 2013 3:28 PM

Answers

  • Hi Sudan,

    External Content type is a SharePoint Content type which you use to connect other systems. External content types are created and managed by BCS, You cannot change or  add columns in external content type without redefining the BCS model. External content types cannot be used in or attached to ordinary lists. BCS can be used to connect any data source to present the business data as SharePoint content. 

    Best Regards.


    Kelly Chen
    TechNet Community Support

    Friday, January 11, 2013 7:54 AM