Connect existing SharePoint 2007 / 2010 lists directly to ANY external data in just minutes

SharePoint data integration made easy: The Layer2 Business Data List Connector for SharePoint solves many issues that still exist with SharePoint external data integration. It makes it simple to connect native SharePoint lists to almost any external data source, codelessly and two-way, if required. All native SharePoint features are available for the connected lists, including views, search, managed metadata, lookups, offline and mobile access, change notifications, and workflows.

The Layer2 Business Data List Connector is the market leading add-on to easily connect SharePoint on-premises lists to almost any external data source. If you are looking for Office 365, SharePoint Online, or OneDrive data integration and document sync, please take a look here.




SharePoint Integration Layer2 Customers 

Fig. Selected Layer2 BDLC customers. All trademarks cited here are the property of their respective owners.

SharePoint Integration: Layer2 Business Data List Connector (BDLC)

The fast, easy, and complete integration of external data sources is a common requirement in the use of Microsoft SharePoint technology. Solutions, such as the Business Data Catalog (BDC) for SharePoint 2007 or the Business Connectivity Services (BCS) for SharePoint 2010/2013, are complex, require additional tools or programming, have serious limitations, and are available for certain SharePoint editions only. The  and are available for certain SharePoint editions only. The Layer2 Business Data List Connector for SharePoint completely solves those issues.

The SharePoint connector offers "external lists" by connecting 100% NATIVE SharePoint lists (native contacts, news, tasks, events, or custom lists) to almost any external data source in just minutes, directly in the SharePoint list settings. No SharePoint Web Parts, no BCS necessary! The desired data can be populated to the list and presented without restriction, with the full functionality of common native SharePoint lists. Changes made in SharePoint can then be written back to the external data source, if desired. Please see SharePoint integration features and benefits or view common SharePoint integration use cases.
SharePoint Integration - Step by Step Intro @ Slideshare  
Fig. To see the product presentation full-screen please click the image. In case of technical issues while using SlideShare, download the presentation file here.
Whether you are an end-customer, systems integrator, or service provider, with the Layer2 Business Data List Connector you can dramatically reduce project costs, simplify your SharePoint architecture, improve SharePoint reliability, performance, productivity, and increase end-user acceptance.

SharePoint Business Data List Connector - Availability

​The SharePoint Business Data List Connector is available for Microsoft SharePoint Server 2007, 2010, 2013 and 2016 as well for the free Windows SharePoint Services 3.0, and Microsoft SharePoint Foundation 2010 / 2013. To connect your external data to the SharePoint Cloud (e.g. SharePoint Online, Office 365, OneDrive for Business, or any other externally hosted sandbox) please see the Layer2 Cloud Connector for SharePoint and Office 365 product with similar features but different architecture.

SharePoint Business Data List Connector - How Does It Work?

​​The SharePoint Business Data List Connector (BDLC) provides the complete read-only or optionally write-back (CRUD - Create / Update / Delete) features of any native SharePoint 2007/2010/2013/2016 list for almost any external Line-of-Business data sources in just a few simple steps:
SharePoint External Data Integration 
Fig. Simply click "Connect to external data source" in the General List Settings to synchronize any native SharePoint list with almost any external data source automatically.
  1. Create a native list of any type to host the data and simply click "Connect to external data source" in the list settings dialog.
  2. In the BDLC settings dialog choose from the installed connection providers and enter the appropriate connection string (e.g. OLEDB, ODBC, .NET, OData, or custom) and validate it. Please note that you can hide security-relevant settings in the SharePoint secure store later on.
  3. To select the desired data, please enter a query statement as supported by your external data source and validate it. Check the result in preview mode and enter the primary key(s) - some unique columns - to safely update only changed SharePoint list items.
  4. Create the SharePoint list structure by adding required columns automatically, check the field / column mapping, and update the list first time using the command buttons with one click. If a primary key is available, this can be used to cause only modified data to be updated in the list later on later synchronizations which improves performance (background batch update via timer job).
    • You can optionally activate write-back to external data source using CRUD features (if supported by the driver, access rights and query).
    • You can use update on-demand via the list action menu / ribbon button, URL, or API, or you can activate the background update to run a scheduled timer job.
SharePoint external data integration setup 
Fig. A sample configuration of the Layer2 Business Data List Connector to expose the SQL Server categories table of the Northwind demo database as a native SharePoint list and update each hour automatically. No other settings required to connect and keep current. Connection strings can be hidden and centrally managed in the SharePoint Secure Store, if required.

Free Registration & Download

With the free Shareware Edition of the Layer2 Business Data List Connector for SharePoint (BDLC) you can manage up to 25 items per list. To manage more items the full licensed version is required. Please register to download the evaluation / shareware version for free now. Use the registration form on the top-right of this page or contact [email protected]

How to Buy This Product

​To buy a license for this product, please click the shopping cart symbol on this page. The product is licensed on a per SharePoint server basis (perpetual license, one-time fee). No additional clients licenses (CALs) are required. If you have several WFE servers (e.g. in a farm scenario), all WFE servers have to be licensed. Application servers have to be licensed if automatic background updates are used. Infrastructure servers, e.g. for database, indexing, or search, don't require a license. You can upgrade an evaluation / shareware version to a licensed version at any time without a new installation. For more information about licensing, please check our FAQs or contact [email protected] directly.
Share this site on Xing
Share this site on Google+
Share this site on LinkedIn

Of all the tools I've bought to make our SharePoint environment more user friendly, the Layer2 Business Data List Connector is my favorite. It is really well done, and the service from the publisher is top drawer.


 Download & Evaluation

Please register 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 or service 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.