Microsoft Office 365 Data Integration

Is your new Office 365 still a data island? Connect it to your local or cloud-based enterprise IT apps to keep data and files in sync and fully release the potential benefits. The Layer2 Cloud Connector has become the market-leading tool and some kind of a Swiss-Army Knife of Office 365 data integration and file sync during the last years: 100+ systems can be connected code-free and in just minutes. Take a look below to know more about features and benefits.


Integration is the key to success

Data islands in the cloud can cause outdated and inconsistent information. Not a good starting point for collaboration. Better to keep data and files in sync with your existing IT infrastructure. Make use of Office 365 for collaboration, reporting, data acquisition, and more - securely connected.

Release portential benefits

Increase active usage and end-user acceptance by providing up-to-date information from your backend-systems in the well-known and very flexible Office environment for search, views, lookups, forms, mobile and offline access, change notifications, and workflows on external data change.

Office 365 Document Integration

Simply connect your local Windows File Server, NAS, or SharePoint Server to SharePoint Online document libraries based on easy to use templates and sync your documents two-way. Subfolders are created by default. Metadata can be mapped automatically or manually, if required.

SharePoint List Data Integration

SharePoint Online lists can be connected two-way with 100+ external data sources, such as file content, SQL databases, ERP/CRM systems, SharePoint, Exchange, Dynamics. Use SQL, OData, or XPath to pre-select your desired data, depending on the source system. Map your data fields between source and target system. Keep data in sync with native SharePoint lists without any feature restrictions, compared to BCS/external lists.

Microsoft Dynamics Integration

Data entities in Microsoft Dynamics can be connected to SharePoint lists without programming. All editions are supported: Dynamics 365, CRM, NAV, ERP, AX, SL and more, on-premises or online. No changes on the Dynamics side required. In many cases two-way sync is possible.

Microsoft Exchange Integration

Data in Microsoft Exchange can be kept in sync with SharePoint Online lists, for example contacts, calendar events, tasks, or notes - even email messages. Personal mailboxes are supported as well as public folders.

Microsoft Teams Integration

Team collaboration needs up-to-date information from your backend IT systems. Keep your teams informed about any data changes in 100+ external apps via flexible, bot-like messages. Sync your team documents with local file servers, NAS, SharePoint on-premises, or online. Start enterprise social today.


Office Groups Integration

Office Groups can bring together email and collaboration in one place - including data and documents from 100+ typically used apps. Send template-based messages to groups automatically on any data change. Keep group documents connected and in sync with other enterprise file storage locations, such as local NAS or SharePoint.

Microsoft Azure Integration

Azure can provide distributed scalability and performance across cloud-based apps via Microsoft Flow, Azure Logic Apps, SQL Azure, Azure File Storage, or Azure Table Storage. Make use of Layer2 to connect 100+ typically used enterprise apps to Azure, local ones, and also cloud-based.


Take a look at the screens to get a first impression.



You can make use of the Layer2 Cloud Connector to keep your Office 365 and SharePoint Online data in sync with 100+ other systems and apps.


Which Office 365 Plan do I need?

Layer2 data integration and file sync is not bound to any specific Microsoft Office 365 Plan. It works for any plan. It does not need any installation of apps or configuration changes in the cloud, just read / write access, depending on requirements.

How to integrate my specific app?

The Layer2 Cloud Connector comes with a wide range of common data providers, drivers, and support for standard protocols. It also works with many vendor-specific or 3rd party providers. There are good chances to find your desired system in our solutions directory. If it's not listed: No problem, contact us to add it, if possible.

Can I use it for on-premises?

Generally, yes - you can do. It works for SharePoint on-prem in the same way as for SharePoint Online. But take a look at the Layer2 Business Data List Connector before. It is highly optimized for on-premises use and more easy to manage, depending on requirements.

Where to install the connector?

The connector runs as a Windows Service on top of any Windows OS. It can be installed on Windows Server, clients, or VMs. Install locally in your network if you plan to connect to local on-premises IT systems such as File Server/NAS, SharePoint Server, databases, and similar. You can also install on a Windows VM in the cloud to easily connect any cloud-based services with each other, such as Office 365, SharePoint Online, or Azure File Storage.

Which SharePoint Online features are available?

All SharePoint Online list and library features are fully available for your connected data sets, such as views, lookups, search, forms, managed metadata, change notifications, workflows. There are no restrictions. Even 3rd party tools, such as Nintex Forms, Nintex Workflows, or PlumSail Dashboards are fully supported.

Can I use it with the new Microsoft PowerApps?

Since custom SharePoint list forms are now available with PowerApps , you can create your own business apps based on Layer2-connected SharePoint lists and libraries using PowerApps. Just keep your lists in sync with 100+ data sources using the Layer2 Cloud Connector.


Ready to go next steps?

Ifoc for free trial product regsitration - Layer2 leading solutions

Register for free trial

Download a free trial of the Layer2 Cloud Connector