The Layer2 Business Data List Connector for SharePoint can solve many issues that still exist with the SharePoint out-of-the-box external data integration via BCS. It makes it as easy as possible to connect SharePoint lists to 100+ external data sources, codeless, with no-touch and two-way, if required. All SharePoint list features, such as search, change notifications, and workflows, are fully available for the connected list. This product is optimized for SharePoint on-premises. To integrate external data sources with Microsoft SharePoint Online and Office 365 take a look here. Please learn more about the data sources supported and common use cases below.​

SharePoint Data Integration - What do you want to connect today?

Learn more about supported systems and applications for codeless and no-touch SharePoint data integration via the Layer2 Business Data List Connector here:
  • Google Analytics
  • Google BigQuery
  • Google Drive (via File Share)
  • Google Mail (GMail)
  • Google Search
  • Google Spreadsheet
  • Google Talk


Jira by Atlassian [NEW]

  • UDL
  • UniData
  • UniVerse
Please note: All linked connections are carefully verified by our tech support team. ​They have added best practice advice, as well as known issues and possible workarounds. Entries without a link are still not verified, but may also work. In both cases, a proof of concept (POC) makes sense to evaluate the connector with your specific requirements. A list with systems that are known to not work as expected with the connector will soon be available here. ​

Do you have found that it worked great with other data sources as well? Just let us know. Can't find what you are looking for? Please contact [email protected] for any further help.​

SharePoint External Data Integration - BDLC Use Cases

​The Layer2 Business Data List Connector for SharePoint solves a lot of business requirements with SharePoint external data integration:
  • You want to access any external data source automatically up-to-date without any programming as a native SharePoint list of any type (e.g. contacts, tasks, events, custom types).
  • You want to have the full functionality and features of a usual native SharePoint list, e.g. personal views, filter, grouping, calculated columns, custom columns, etc. for external data as well.
  • You have to pull contacts from your CRM/ERP system to a native SharePoint contact list, e.g. for offline synchronization with Outlook – possibly with write-back.
  • You have to pull tasks from your Help Desk, Action Request System or Exchange Server to a native SharePoint tasks list, possibly bi-directional.
  • You have to expose date- or time-based information from external systems in a native SharePoint calendar with different views.
  • You want to provide typical master data of your company (e.g. products, services, departments) centrally for consistent use in portal-wide SharePoint lookups without any manual duplication. You can establish native SharePoint lookups to these lists as usual with SharePoint, without any restrictions.
  • You want to save license costs for external systems while exposing the data within the well-known Office-like SharePoint list user interface, so that everybody that has access rights could easily work with it.
  • You want to subscribe to native SharePoint RSS newsfeeds or email-based notifications to receive a message, in case of external data records are changed.
  • You want to start business workflows (e.g. based on SharePoint Designer, Visio, Visual Studio or Nintex) in SharePoint in case of external data changes without any restrictions.
  • You have to add additional information like social columns, managed metadata or attachments to external LOB data in SharePoint.
  • You want to take any LOB data offline - display only or with with full replication using BDLC connected lists with SharePoint 2010 (Outlook and/or Workspace).
  • You want to make use of the new SharePoint 2010 / 2013 Knowledge Management features to tag external data with managed metadata or enterprise keywords for improved navigation and findability.
  • You want to integrate external data seamlessly with the SharePoint 2010 / 2013 Social Networking, e.g. for ranking, rating, comments, or activity feeds on MySite.
  • You want to make external data available for any kind of SharePoint search, including WSS and Fast.
  • You want to use charts and diagrams based on external data, but won’t directly access the data sources in real-time.
  • You won’t use Web Parts or BCS / External Lists to display external data, because there are restrictions in functionality, security and performance compared to native lists.
  • You want to import connect a native SharePoint List with Excel data and update on a regularly base.
  • You want to present data aggregations or pivot queries in a Business Intelligence (BI) scenario with full list features available.
  • You want to join data from different tables or data sources and provide it as a native SharePoint list.
  • You want to display data from Microsoft Project.
  • You have to pull data from Active Directory, e.g. to create a corporate phonebook with all native list features.
  • You want to fully integrate Microsoft Exchange or Outlook data, e.g. contacts, email messages or public folders.
  • You have to connect two SharePoint lists, e.g. between site collections or cross installations.
  • You want to pull data from the file system via Index Server into SharePoint lists.
  • You have Microsoft Office SharePoint Server 2007, but no Enterprise Version. No Business Data Catalog (BDC) is available.
  • You have to use the free Windows SharePoint Services (WSS 3.0) and no Business Data Catalog (BDC) is available.
  • The Business Data Catalog (BDC) or Business Connectivity Services (BCS) are too complex for a given requirement and you won’t use additional configuration tools.
  • You have to automate regular imports of external data, but don't want to remove / re-insert all items with each run.
  • You have to connect complex or not connected external systems, e.g. with export to CSV or fixed length text files on one side and automatic update of SharePoint lists on the other side.
  • You have to provide data integration solutions that work in the same way for SharePoint 2007, 2010, 2013, and 2016 and are easy to migrate.
  • You want to write-back changes made in SharePoint lists to external data sources with full Create, Update and Delete (CRUD) codeless.
  • You want to configure lots connections to external data sources programmatically per API.
Share this site on Xing
Share this site on Google+
Share this site on LinkedIn

Thanks again for developing a killer product. It is bullet proof. Set and forget.


 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 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

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.