Previously I have discussed SharePoint’s Business Connectivity Services specifically the External Content Type (ECT) and the External List. Basically an ECT is a mapping of all the data that you want to surface from an external source into SharePoint. An external list is where that ECT is surfaced into once you get it into SharePoint. An external list is very similar to a regular SharePoint List, but some features are not available. Some features that you don’t have include the ability to add or delete columns, quick edit, and most of the social specific features. You can find a complete list from Microsoft here.
Today I am going to illustrate to you how to create an ECT and an external list while making use of the secure store entry I showed you how to create previously. Today’s demo is going to be a completely “no-code” solution. My intention is to illustrate some code based example in a later blog post, but today we are strictly doing this without writing any code.