The SharePoint Business Data List Connector (BDLC) is used to connect any type of SharePoint list (no Web Parts) directly to external LOB data in just minutes using the web browser.

How to propagate SharePoint lists with external data? 

What's new with SharePoint BDLC Version 2.0 (released on 2010-04-19)

With BDLC 2.0 now you can connect any existing SharePoint list to external data. That means, you can now link

  • contacts (e.g. from any CRM)
  • tasks (e.g. from some HelpDesk)
  • events (e.g. from a database to display in a calendar view)
  • surveys
  • news 
  • your own content type based list
or any other kind of SharePoint list (except discussion lists or document libraries) to external data sources. Just start with the list settings dialog.

SharePoint external list connect to external data source

Fig.: Simply go to the General List Settings dialog and chose "Connect to external data source".

There is no need, to create a special custom list type BDLC list anymore. But the BDLC list is still supported for compatibility reasons.

You can take lists offline with Outlook (e.g. contacts) if supported by SharePoint. Changes are made in database are replicated to Outlook as well.

Simply click the additional list settings entry: Connect to external data source.

Action Menu

You can now update the list data using an extension of the "Actions" menu. Simply chose: "Update List Items". You no longer have to go to the settings dialog for update.
Additionally updates per URL are supported (see other FAQs).

SharePoint: Update List items with external data source

Fig.: Now there is a new Action Menu available to sync lists with external data sources (one way with BDLC 2.0, bidirectional with BDLC 3.0 - if data source is supported).

Further Improvements

  • Usage of Access Rights was improved: If you update with action menu, "Add Item", "Delete Item", "Update Item" right is required only. To access the settings dialog, "manage Lists" rights are required. That could prevent users from acess to security relevant information like connection strings or select statemenets.
  • The connection string can be stored in the web.config instead of the settings dialog for security reasons. If you define a term myConnectionString in your AppSettings section of web.config, you can use web.config:myConnectionString as BDLC connection string.
  • You no longer have to use the prefix "bdlc" to create a field mapping to data source fields. Simply chose the same name for data source fields and Sharepoint list columns to map. Use the "Check Mapping" feature to verify that, because sometimes Sharepoint choses unexpected internal field names.
    But the prefix "bdlc" in internal field names is still supported for compatibility reasons.
  • There is no "Create" button anymore, to completely re-create the list structure It is replaced by an "Add Columns" button. Any external data source fields, that are not in the SharePoint list, are added. You have to delete unused columns manually as usual in SharePoint, if no longer required.
  • If list data is updated using the update button, a new warning dialogue is displayed. List data could be changed, with respect to your external data source. Take care, if you connect and update an existing SharePoint list the very first time. If, for example, the data source is empty - all SharePoint list items are deleted.
  • There are some improvements with support of certain data types, e.g. float, yes/no, currency, lookup, text, note etc.

The upgrade to BDLC V2.0 is completely FREE for all customers with Software Assurance (SA).

Known issues

  • Licensing issues in some certain configurations with V2.0.0 are solved in V2.01
  • Until V2.01 all list items are deleted, while adding new columns in SharePoint to the BDLC list. That was changed in V2.02. Now no items are deleted while adding a new column to the BDLC list. The items can be updated after adding a new column to fill data into the newly added column.
Current version: V2.02 (2010-04-30)

Share this site on Xing
Share this site on Google+
Share this site on LinkedIn

"Please support us to improve our products and solutions. Give us your feedback."

Related Contacts
Frank Daske

Frank Daske

Business Development Manager
+49 (0) 40 28 41 12 - 30
[email protected]

Please note that the 011 exit code must be dialed first for all international calls made from the USA , Canada and Australia.

Related News

SharePoint 2016 Data Integration

The Layer2 Business Data List Connector (BDLC) closes many gaps that still exists with Microsoft SharePoint 2016 out-of-the-box external data integration via Business Connectivity Services (BCS).

Layer2 Business Data List Connector V7 Released to Close Gaps with SharePoint External Data Integration

​Layer2 has announced version 7 of their top-rated Business Data List Connector (BDLC) that connects 100+ external data sources with SharePoint lists codeless and closes many gaps that still exist with out-of-the-box SharePoint external data integration.
Related Downloads
NoDoc Image

Business Data List Connector PAD File

This XML-based PAD file offers a product description for resellers to download and publish.
PDF Image

Customer Solution Case Study: WealthVest Marketing Benefits From SharePoint Data Integration Using Layer2 Business Data List Connector

"By using the Layer2 Business Data List Connector for SharePoint app we can provide native SharePoint lists as a simple, easy-to-use, and familiar interface to manage mission critical business data."
PDF Image

Flyer: Layer2 Partner Program

Partner with us as a software distributer, reseller or SharePoint, Office 365 or Azure service provider. We are offering a free Partner Program with up to 30% Discount, free NFR licenses etc. Please download for more.
PDF Image

How to connect ANY external data source directly to native SharePoint lists?

Download this step-by-step introduction to the Layer2 Business Data List Connector (BDLC) for SharePoint.
PDF Image

How to integrate SAP data with SharePoint via NetWeaver & OData

You simply have to enter an URL to the data collection to integrate and sync SAP data with native SharePoint lists.
PDF Image

Product Flyer: Business Data List Connector for SharePoint

SharePoint on-premises external data integration with 100+ sources: Product flyer (PDF) in English for download.
PDF Image

Testimonial: How the US Defense Contract Management Agency (DCMA) integrates SharePoint with Oracle using BDLC

"Layer2 Business Data List Connector (BDLC) software provides a powerful mechanism for surfacing external data through lists, and drastically improves platform stability and development cycles."
Related Links

Are you looking for partners in your region?

Please find a local partner here.

Layer2 BDLC for SharePoint Community Group @ LinkedIn

​Are you already @ LinkedIn? Please join our group to share your experience.

Purchase Layer2 Business Data List Connector via ComponentSource

​ComponentSource has offices in the USA, UK and Japan supporting over 125,000+ Customers, in over 180 Countries. They are also an approved Federal Government supplier through the GSA Schedule.

Sign Up for Layer2 Product Newsletter

We keep you up-to-date about new Layer2 product releases, added features and fixed issues.