The Layer2 Business Data List Connector for SharePoint solves many issues that still exist with SharePoint out-of-the-box external data integration. It makes it simple to connect native SharePoint lists to almost any external data source, codelessly and bi-directionally. All native SharePoint list features are available for the connected list. This product is optimized for SharePoint on-premises. To integrate Microsoft SharePoint Online and Office 365 take a look here. Please read on to learn about features and benefits.

SharePoint Business Data List Connector - Features & Benefits

Fig. Simply create a new SharePoint list and click "Connect to external data source" in the general list settings to connect to 100+ external data sources like SQL/ERP/CRM and more.

The Layer2 Business Data List Connector for SharePoint has the following features and benefits:

  • No additional tools or programming required: The connection can be configured easily directly in the SharePoint list settings with only a few configuration settings. Every SharePoint admin can do this in minutes.
  • Connected data is always up-to-date: The connected data updates automatically in background (via timer job), or alternatively, on-demand (Action Menu / Ribbon Button, URL, workflow, API). Only changed data is transferred. Each list optionally can run it's own timer job, if required.
  • Optional bi-directional connection: Write-back the changes made in SharePoint to external data sources automatically with full CRUD (Create / Update / Delete) functionality.
  • All existing ODBC, OLEDB, OData and .NET based 3rd party ADO.NET data providers are supported: You can connect to SQL Server, SQL Azure, MySQL, Exchange, Active Directory, SharePoint, MS Office Excel, Access or CSV text files, XML, EDI, Oracle, IBM DB2, Informix, AS400, Cache, ERP/CRM systems (such as MS Dynamics CRM / NAV / AX, SAP,, Twitter, Google, Facebook, QuickBooks, Peachtree, HL7, Virtual Store, general Web Services, .NET or COM+ objects, and many more.
  • Additional data provider included: SharePoint 2007 / 2010 and 2013 (CSOM, on-premises, and cloud-based), OData (e.g. MS CRM), XML (file or web request), and RSS.
  • Known BCS issues and limitations are completely solved: All list features are to you. Views, sorting and grouping, filters, calculated fields, search, enterprise metadata, and lookups can be created as normal.
  • Workflows and notifications on external change: List workflows (SPD-, VS-, and Nintex-based) and change notifications per RSS or email can be used to take business actions in SharePoint, if external business data records are changed.
  • High Security - Easy to maintain: SharePoint Secure Store can be used to store security relevant configuration information safely in one central place.
  • All list types are supported: Contacts, tasks, events, custom lists, etc. You can take the external data offline via Outlook and / or Workspace.
  • You can add additional SharePoint-only columns or attachments to the external data: Documents, comments, ratings, enterprise metadata, or other Web 2.0 content.
  • Flexible update options: You can optionally disable list item deletes, inserts, updates, if required.
  • Application logging, reporting, and notifications: SharePoint lists can be used to store settings and log information. SharePoint item versioning and workflows can be used to manage reporting and notifications. Direct notification per email in case of errors is supported as well.
  • Programming not required - but possible via API: Connect lists to external data sources completely automatically and update on-demand via API (see code samples included with the product).
  • Easy SharePoint migration to higher versions: SharePoint 2007/2010/2013/2016 supported. All settings are maintained during update. Free upgrade for all customers with Software Assurance (SA).
  • Knowledge Management and Social Networking features for external data: The BDLC makes any external data source available for SharePoint Enterprise Metadata Management (Managed Metadata / Term Store) to use with the SharePoint Knowledge Management and Social Networking features without any restrictions. The Layer2 Auto Tagger can be used to automatically assign managed metadata terms on list item data change.
Share this site on Xing
Share this site on Google+
Share this site on LinkedIn

Ease of use. No major configuration, creation of connections or anything like that. Just install and it works. I was able to create a connection to a test MSSQL db in a matter of minutes, including updating. Very nice product.


 Download & Evaluation

Please register now to receive your free personal download link via email to your valid company email address.
Yes, I accept the licensing terms and conditions
How to buy this product

With the free Shareware Edition you can manage a limited amount of list items. To order a license for the full version please click the shopping cart.

Layer2 Business Data List Connector for SharePoint 2007/2010/2013/2016
License List Price
Free Shareware Edition $0.00
1 Single Server
$1,065.00 Add to Shopping Card
1 Annual Software Assurance
$225.00 Add to Shopping Card
Prepaid Remote Support
1 Hour
$176.00 Zum Warenkorb hinzufügen


You can also order by phone or fax:

Order Service USA
(Language: English)

Share-it c/o Digital River, Inc.
10380 Bren Road West
Minnetonka, MN 55343, USA

Phone from outside the U.S.:
+1 952 646-5747
Phone from within the U.S.:
+1 800 903-4152

Fax: +1 952 646-4552
[email protected]


Order Service Europe
(Languages: German, English,
French, Italian, Spanish,

Share-it - Digital River GmbH
c/o Digital River Ireland Ltd.
Unit 153
Shannon Free Zone West
Shannon Co. Clare

Phone: +49 221 31088-20
Fax: +49 221 31088-29

More about how to buy see here. For more information about licensing please check FAQs or contact [email protected] directly.

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 of the Layer2 Business Data List Connector (BDLC) for SharePoint on-premise.
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.