As one of the leading providers of Microsoft SharePoint apps in Europe Layer2 offers several add-ons for SharePoint external data integration for different customer requirements. Please see here a feature comparision of the Layer2 Business Data List Connector and the Layer2 Cloud Connector products.

SharePoint External Data Integration Apps: Feature Matrix

Microsoft SharePoint External Data Integration Tools Feature Matrix

Products and Features

Business Data List Connector

Cloud Connector

​Availability:
SharePoint Server 2007
and WSS 3.0
Yes No
​SharePoint Server 2010 and SharePoint Foundation 2010 ​Yes ​Yes
​SharePoint Server 2013 and SharePoint Foundation 2013 ​Yes Yes​
​SharePoint Server 2016 Yes​ Yes​
​SharePoint Online, Office 365 Yes (but as external data source only) ​Yes
Office Groups, Microsoft Teams ​No Yes​
​Azure Logic Apps ​No Yes​
​OneDrive for Business Yes (but as external data source only)​​ ​Yes
​Architecture:
​Installation on SharePoint required ​Yes ​No
​Additional Installation required No​ ​Yes
​Background Update Yes (SharePoint Timer Service)​ Yes (Windows Service)​
​Write-Back changes to Source Yes (immediately)​ Yes (Scheduled)​
​Native List Support ​Yes ​Yes
​Native Library Support No ​Yes
​Codeless ​Yes Yes​
​API available ​Yes Yes​
​Logging ​Yes (BDLC Configuration List, SharePoint Log) ​Yes (via NLOG to files, SQL, Windows Event Log)
​Alerting (e.g. Email) ​Yes (Workflows) Yes (Windows Event Log)​
​Connections:
​One Side must be SharePoint Yes​ No​
​32-Bit Provider Support No (SharePoint requires
64-Bit)
​Yes (on 64-Bit as well)
​64-Bit Provider Support ​Yes ​Yes
​ODBC / OLEDB Connection ​Yes ​Yes
.NET Connection Yes ​Yes
​SQL Connection ​Yes (almost any database) ​Yes (almost any database)​
​File System Synchronization ​No ​Yes
​OData Connection (e.g. Dynamics CRM, SAP etc.) ​Yes ​Yes
​XML / RSS Connection ​Yes ​Yes
​Active Directory Connection Yes​ Yes​
​Excel / Access Connection ​Yes Yes​
​MS CRM Connection ​Yes Yes​
​SAP Connection ​Yes (via OData/NetWeaver API or ADO.NET, XML/CSV) Yes (via OData/NetWeaver API or ADO.NET, XML/CSV)
​Exchange Connection ​Yes Yes​
​Web Services Connection Yes (SOAP)​ Yes (SOAP)​
​More Connections See here​ See here​
​Features:
​All native SharePoint features, e.g. Views, Search Yes​ Yes​
​Trigger Notifications and Workflows Yes​ ​Yes
​Additional SharePoint-only columns and attachments ​Yes ​Yes
Aggregation from several external sources ​No ​Yes
​"No Delete" Option ​No ​Yes
"​No Insert" Option ​No ​Yes
​"No Update" Option ​No ​Yes
​Managed Metadata Support No​ Yes (.NET 4 version only)​
​Dynamic Colums in C# ​No Yes (.NET 4 version only)​
​Licensing Options:
​via Vendor or Resellers ​Yes Yes​
​Microsoft App Store ​No ​Yes (Free Edition only)
​Per SharePoint Server (WFE/APP) Yes​ No​
​Per Installation No​ ​Yes
​Per User (CAL) ​No No

 

Next Step: Register to download a free trial

​You can download a free Shareware Edition of both products (limited to 25 items per connection) after registration on the product page.
Share this site on Xing
Share this site on Google+
Share this site on LinkedIn

"We have been using the SharePoint Business Data List Connector for several months now, and we really like it so much that we want to stick with your products."

Contact
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

Layer2 now connects 100+ commonly used IT systems with Twitter via its Layer2 Cloud Connector

The Layer2 Cloud Connector is now able to connect Twitter to integrate data to a wide range of IT backend systems including Office 365, SharePoint, SQL, ERP/CRM.

New Microsoft Teams Connectors: Layer2 adds 100+ typically used backend systems

​The Layer2 Cloud Connector is now able to connect to Microsoft Teams to quickly integrate more than 100 IT backend systems including local SQL, ERP/CRM.
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

Cloud Connector Instruction

Download this step-by-step instruction to connect and sync your corporate or cloud data sources bi-directional to any native SharePoint 2010/2013/2016 list or library, including Microsoft Office 365.
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

Feasibility Study: Connecting local SQL Server to SharePoint Online

The study compares different approaches for SharePoint Online data integration regarding performance, features, security and investment.
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

Layer2 Case Study: Cloud Connector helps ChemWerth to integrate the Microsoft Office 365 Cloud

"The Cloud Connector’s interface is easy to understand and use. Anyone familiar with utilities in the Microsoft stack will be productive immediately. Our recommendation: The Layer2 Cloud Connector is a no brainer.”
NoDoc Image

Layer2 Cloud Connector PAD File

This XML-based PAD file offers a Layer2 Cloud Connector product description for resellers to download and publish.
PDF Image

Office 365: How to sync with MS Dynamics CRM

You can sync any CRM data with native lists in SharePoint on-prem or online to make it available offline with Outlook.
PDF Image

Office 365: How to sync with SAP?

You can connect SharePoint and Office 365 with SAP via NetWeaver and OData.
PDF Image

Office 365: How to sync your local file share?

When you are moving to the cloud, there are a lot of reasons to keep your local file system. But you don't have to miss the benefits of the cloud.
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

Product Flyer: Cloud Connector for Microsoft SharePoint & Office 365

Flyer with features, benefits & pricing info for download as PDF.
PDF Image

Product Flyer: SharePoint Online Local File Server Sync

You can centrally migrate, synchronize, or backup your local file server department shares and home drives very flexible with SharePoint Online to close known gaps and overcome limitations of the Microsoft OneDrive for Business client.
PDF Image

Solutions Flyer: Data Integration with SharePoint, Office 365 and 100+

FileMaker can be integrated with 100+ other sources codeless using the Layer2 Cloud Connector.
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.

Layer2 Cloud Connector Community Group @ LinkedIn

​Are you already @ LinkedIn? Please join the Cloud Connector Community Group to share your experience.

Microsoft Partner Story Book for Office 365 about Cloud Connector

​Know more about a Layer2 Cloud Connector customer reference at the Microsoft Office web site.

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.
 
cs-award-top-100-publisher-2014-15-large.gif

Purchase Layer2 Cloud 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.

 

cs-award-top-100-publisher-2014-15-large.gif

Sign Up for Layer2 Product Newsletter

We keep you up-to-date about new Layer2 product releases, added features and fixed issues.