Let us assume it is my task to establish a bidirectional connection between a SharePoint List and a SQL-database. According to Paolo Pialorsi's Developer Manual for SharePoint 2010, BCS (Business Connectivity Services) is the right thing to use here.

I also came across the Layer2 BDLC (Business Data List Connector). The Vendor claims his Product to be more efficient then BCS due to several Points mentioned in a long list of advantages. One of the main arguments being that BDLC does not require any programming.

My question is, would this kind of thrid party solution really make me solve my task more efficient? Or would I miss any possibilities by not being able to solve things programmatically?

I hope this will not get marked as not constructive as I am very new to SharePoint and just want to get some advice from more experienced members.

  • 1
    I don't know enough about your business requirements for your project, so I can't say whether Layer2's BDLC is more effective, but you can write no-code BCS external content types in SharePoint Designer. Then, you can create an external list off of that external content type. It all depends on what you need to do with the data as to whether a third-party solution is necessary or not. Apr 7, 2014 at 15:07


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Browse other questions tagged or ask your own question.