SharePoint 2010 BCS features unavailable/missing
I just prepared list of features/functionality which are unavailable in BCS. This can be because of technical issues that comes with implementing External Data features and since data is residing in systems which are not in control of SharePoint. Here is the list which you may find useful while designing systems based on EL and be aware of limitations.
- Workflows cannot be configured on External List.
- Item level Permissions cannot be given on items in External List interface
- Export to Excel feature is not available on External Lists
- Versioning cannot be configured on items in External Lists
- Item History is not available in External Lists
- Datasheet View cannot be used in External Lists
- RSS Feed cannot be configured on External Lists
- Ratings are not supported on in External Lists
- ListData.svc can’t be used for providing REST based access to External List data
- External Data Columns cannot be used as Site Level columns (can’t be consumed in Site Level Content types)