SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

What are the pros and cons of using the BCS to integrate an external system into SharePoint versus a custom integration.

share|improve this question
You will find a discussion here:… Think its not about "custom" only. Possibly a 3rd party app can do more compared to OOB BCS, especially with SharePoint 2013 or SPO/cloud. 3rd party tools avoid programming, and can offer all native list features, e.g. search, change notifications, workflows - not only displaying external data on SharePoint surface... – user11338 Dec 4 '12 at 12:59
up vote 0 down vote accepted


End User

  • Business Data Web Parts & External List can render data out of the box
  • Enterprise & FAST Search Integration with Managed Property Mapping support
  • User Profile Synchronization
  • Office Integration via External Data Column
  • Office Mapping for Tasks,Contacts and Calendar
  • SharePoint Workspace Support
  • Single Sign on Support
  • Workflow support via External Data Column and External List


  • Visual Studio Tooling Support
  • SharePoint Designer Support
  • Out of the box support for existing SQL Databases & WebServices
  • .Net Assembly Connector can connect to any other datatype
  • Server side API to develop custom web parts against
  • Client Side API to develop custom client integrations against
  • Write once work against any data source controls are possible


End User

  • Out of the Box Web Parts look outdated
  • External Data Column data needs to be refreshed


  • Generation and Maintenance of Model file is time consuming.
  • Data Model does not support subclassing.
  • Writing controls that work against any data source is time consuming.
share|improve this answer

Fabian Williams had a related post about the topic (BCS vs Alternates) a few months ago -

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.