Layer2 Cloud connector

The Swiss Army Knife of data integration tools: The Layer2 Cloud Connector can integrate data and sync documents between 100+ corporate data sources without programming. It is typically used to connect services and apps, local or cloud-based, such as Microsoft Office 365, SharePoint, Teams, Dynamics, Azure, SQL/ERP/CRM, File Shares, and more for migration, backup, or permanent two-way synchronization. This product is optimized for SharePoint Online. If you are on SharePoint on-premises and want to sync structured data, please find a similar product here.

Layer2 Quick Start Presales Service - 30 Minutes free assistance


Join a 30 minutes presales Quick Start Service session to assist you remotely with product installation, setup, and configuration. More value in less time: Get the most out of your new "Swiss army knife" data integration tool. Book our technical consulting online right now:

30 Minutes Quick Start Service (worldwide) | 30 Minutes Quick Start Service (North, Central, and South American time zones)

Features and Benefits

Codeless Sychronization with the Layer2 Cloud Connector

Keep your enterprise in sync codelessly

Connect and sync data and files between 100+ local or cloud-based enterprise IT systems and apps in minutes. Just select a data provider, enter a connection string, query your data and map the data fields. Schedule the sync to automatically run in background - that's it.


Best performance and security

Once connected, only data changes are transferred as configured, one-way or even two-way. You don't have to modify the connected systems. No admin rights required. No need to open your network or modify firewall settings. No 3rd party vendor or cloud involved: All under your full control.


Flexible high-end features

Flexible data or file selection using SQL, XPath, OData, SOAP, and more. You can sync one-way or even two-way, enable or disable specific operations, manage sync conflicts. Dynamic columns can be used to cleanup, transform or translate data across systems, or add your own business logic in C#. 


Cost-effective licensing

The 3 fully-featured product editions are licensed per installation. While the Personal and the Professional Edition are licensed as one-time fees with optional Software Aussuarance, the Enterprise Edition has a subscription-based pricing model. There are no data volume-related costs. The amount of sync items are unlimited (depending on your configurations).

How it works

Forget about complexity: Create a connection based on the templates provided.
Adapt for your needs. Take a look at the screens below to get a first impression.

What do you want to connect today?

Connect your SQL databases to the cloud

Find connectivity options for all SQL databases like SQL Server, Oracle, MySQL, Informix, Db2, Access, QuickBooks, and more to keep it in sync with other systems and apps, local or cloud-based. Many ERP/CRM/CMS can also be integrated directly using the backend RDBMS.

Integrate your enterprise with Microsoft Office 365

Is your Office 365 still a data island? Release the potential benefits and connect your enterprise backend IT systems to whatever you want, such as SharePoint, Exchange, Dynamics CRM / NAV / AX / SL / 365, Project, Azure, Groups, Teams, Flow, Logic Apps, and more Microsoft services and apps.


Keep your local files and documents in sync with the cloud

Migrate local documents to SharePoint, OneDrive, Microsoft Teams or Office Groups. Backup your cloud-based files locally or to Azure for disaster recovery and compliance. Keep your documents in sync two-way to enable better collaboration across sites or clouds.

Find answers in FAQs

Where do I have to install the connector?

The connector is installed centrally, where it could easily reach your data or files: on a separate Windows server or client (or VM) in your local network, or in your Azure Cloud. It runs as a Windows Service to keep your data and documents in sync as configured. It communicates with the connected systems via ODBC, OLEDB, ADO.NET, SMB, HTTP, CSOM, OData, SOAP, REST or others. While SharePoint can be connected, the connector typically is not installed on the SharePoint server.

How to connect to my specific system or app?

First try to find your specific system using the Solution Finder. If it's listed, it will work. If not, that does not mean anything. Does your system come with an ODBC, OLEDB, ADO.NET data provider, just install and select in the provider dropdown. Does it offer generic interfaces like CSV/XML, OData, or SOAP? Just select - it's all included. Are there any 3rd party data providers available? We will definitely work with it. Does it speak REST? You can also code and use your own ADO.NET provider to connect a system for which a provider is not yet available.

Is Office 365 or SharePoint required?

While the connector originally was developed to better integrate Microsoft Office 365 and SharePoint with external data, it is not limited to this specific use case. You can connect and sync all supported 100+ systems and apps directly with each other, without any need for Office 365 or SharePoint.


Too many options for me. Can we talk?

A web site cannot answer all questions. We will be happy to talk with you. Best to use the contact form. That will make it as easy as possible for us to be well-prepared when we call-back. Also note our Quick Start Service: A technical consultant can guide you remotely during installation, setup your first connection and talk about general best-practices, and your specific requirements.

Who is using the Layer2 Cloud Connector?

1000+ clients trust Layer2 to manage their business critical data integration and file sync every day.

WHO Layer2 Clients
Layer2 Client Konica Minolta
Layer2 Client yamaha
Layer2 Client National Security Partners

How Layer2 helps ChemWerth to integrate Office 365 and SharePoint to ERP/CRM

The Layer2 Cloud Connector helps ChemWerth, a US-based full service generic drug development and supply company, to fully integrate their local line-of-business applications, such as SAGE 300 ERP (AccPac), with the Microsoft Office 365 Cloud to allow end-user access to current backend data at any time, from anywhere, and with any device within the well-known Office environment.

How Office 365 was integrated in the Vrije Technische Scholen

The Vrije Technische Scholen (Belgium) was able to keep data and files from several sources, such as file servers, NAS, databases, and web servers, in sync with Microsoft Office 365 to provide up-to-date education schedules, student lists, contact information, forms, reservations, and inventories from their backend systems in the cloud.


Ready for the next steps?

Icon for Product Downloads - Layer2 leading solutions

Download product flyer

Learn more about the Layer2 Cloud Connector in the product flyer (PDF).

Icon for Product Regsitration - Layer2 leading solutions

Register now for free download.

Keep your systems in sync. Download and try the Layer2 Cloud Connector today.