Layer2 Cloud Connector - The Swiss Army Knife of Data integration

The Layer2 Cloud Connector can integrate data and sync between 150+ corporate data sources without programming. It is used to connect services and apps on-premises or cloud-based, such as Microsoft Office 365, SharePoint, Dynamics, Azure, SQL/ERP/CRM, and more for migration, backup, or permanent two-way synchronization.






Layer2 Cloud Connector funktion and connection icon: a blue square connected to 4 smaller suqares.

One tool for data and document migration, file backup, and permanent data sync. Use the tool to connect your local apps with the cloud, local to local, or cloud to cloud.

Layer2 Cloud Connector sync benefit icon: 2 blue and grey arrows in a square, one behind the other.

Connect and sync 150+ systems and apps in just minutes without any programming. Select the data provider, enter a data query and a primary key, map the fields - done.

Layer2 Cloud Connector market leader icon: 4 figures with a check.

The "Swiss-Army Knife" of Microsoft Cloud Data Integration & Data Sync: Office 365, SharePoint, OneDrive, Dynamics, Exchange, Azure, Office Groups, Microsoft Teams, Flow...


All kind of SQL databases supported: Oracle, Db2 via ODBC, OLEDB, ADO.NET, ERP/CRM, Microsoft Office Access / Excel, XML, CSV, OData, SOAP and 3rd-party ADO.NET data provider.

Layer2 Cloud Connector efficiency icon: a chart with an arrow moving upwards on a blue computer screen.

Flexible and cost-effective licensing: The 3 fully-featured product editions are licensed per installation. Just select the license model that suits your business needs.

Layer2 Cloud Connector security icon: a blue lock.

As a Windows Service, your data resides today, locally, or in your cloud. No changes in the connected systems required, no administrative access rights. Direct and secure connections.

Layer2 business data list connector - expert in SharePoint on-prem data integration

The Layer2 Business Data List Connector for SharePoint solves many issues that still exist with Microsoft SharePoint data integration. It connects SharePoint on-premises lists to 100+ external data sources without any programming to keep the data in sync. All the great SharePoint features are supported for connected lists.







No programming skills needed: Just go to SharePoint "List Settings", click "Connect to External Data Source". Enter a few settings, create automatically and map your data fields - that's it. Your list will be connected and always up-to-date.



Use the SharePoint features you are already familiar with: Keep settings in the Secure Store. Cache external data in SharePoint lists. Use Timer Jobs, Ribbon Buttons, or the SharePoint API to keep your list data up-to-date in minutes.



Connect SharePoint to almost any SQL/ERP/CRM via ODBC, OLEDB, or ADO.NET. Integrate via Excel, Access, XML, CSV/TXT. Sync data via Web Services like OData or SOAP. Pull data from Active Directory, Exchange, Dynamics, SharePoint, or Office 365.


Provide all the great SharePoint list features for your external data without any restrictions: Views, filters, lookups, search, forms, change notifications, workflows on external data change.


Extend SharePoint forms and workflows to external systems for better collaboration and reporting. Process data changes in SharePoint and write-back results to external systems in real-time. Integrate external systems with Flow or PowerApps.


Integrate your SharePoint-based portal. Providing pre-selected data sets for easy access increases end-user acceptance and helps to release the potential benefits of your existing SharePoint portal.