The Layer2 Business Data List Connector (BDLC) can integrate 100+ external data sources directly with native lists in Microsoft SharePoint Server 2007/2010/2013/2016/2019:

A 100% SharePoint- and browser-based solution: the connection setup is realized within minutes. Just click “Connect to external data source” in the SharePoint list settings dialog.

No programming or additional tools required: use the SharePoint features you are already familiar with such as lists, secure store, and timer jobs.

Trigger the data synchronization manually on demand, via API, or schedule it automatically in the background with fl exible settings.


The BDLC provides users with connectivity to external data sources from native SharePoint lists, with the ability for workfl ows to be triggered by external data changes.

Mike Fitzmaurice, Nintex


Supported auto-created SharePoint list columns, auto-mapping, and fi eld/ column mapping customizations. Data type conversions are included.

100+ external data sources supported: ODBC, OLEDB, OData, ADO.NET-based sources, data fi les (Excel, XML, CSV), SQL Server, SQL Azure, Oracle, MySQL, IBM Db2, IBM AS/400, Informix, PostgreSQL, SharePoint, Exchange, Offi ce 365, Active Directory, Navision, Lotus Notes, SAP, ERP/CRM/CMS systems, RSS Feed, XML Web Requests, OData/SOAP Web Services, etc.

Additional opportunity to use and work with Microsoft Flow or PowerApps