The Layer2 Business Data List Connector (BDLC) integrates almost any external data source directly with SharePoint 2007/2010/2013/2016 lists.

100% SharePoint-based, codeless, browser-based solution: Connection setup within minutes. Just click “Connect to external data source” in the SharePoint list settings dialog.

Auto-mapping and manual field/ column mapping supported including data type conversions.

Optional use of write-back to data sources feature in real-time, full CRUD (Create/Update/Delete).

Add additional “SharePoint-only” columns, e.g. for ranking, rating, tagging, comments or file attachments. Take external data offline.

No programming or tools required.

Almost data source supported: ODBC, OLEDB, OData, ADO.NET-based providers, files (Excel, XML, CSV), SQL Server, SQL Azure, Oracle, MySQL, IBM DB2, IBM AS/400, Informix, PostgreSQL, OneDrive, SharePoint, Exchange, Office 365, Active Directory, Navision, Notes, SAP, ERP/CRM/CMS systems, RSS Feed, XML Web Requests and Web Services, etc.

Known SharePoint BCS issues completely solved: ALL SharePoint list features available now.

Large data sets supported with high performance. No problems with SharePoint List View Threshold.

Data synchronization manually on demand or automatically in background using timer jobs with flexible settings for scheduling.

Data Provider for OData (Dynamics, SAP etc.), CSOM (SharePoint/Office 365), Exchange, XML/RSS included. Others can be connected via 3rd party.

Start SharePoint list workflows or send RSS / email notifications on external data change.

Save license costs for LOB systems while using native SharePoint lists to expose enterprise data.


Layer2 is one of the leading providers of apps and solutions for Microsoft Office 365, SharePoint, and Azure in Europe.

Takes your local line-of-business data to SharePoint Online - easy to connect, secure, and always up-to-date.

Encourages knowledge workers to take advantage of the new SharePoint 2010 / 2013 / 2016 collaborative knowledge management and social features.

Connect native SharePoint on-premises lists to almost any external business data sources in just minutes.

Layer2 have major focus on SharePoint external data integration, Office 365 / SharePoint Online migration, integration and synchronization, SharePoint collaborative knowledge management and social networking.


Discuss your next project with ES Systems