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.

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.

HOW IT WORKS

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

Layer2-Cloud-Connector-Sample-Connection-Settings-1024
Layer2-Cloud-Connector-Sample-File-Settings-1024
Layer2-Cloud-Connector-Sample-Office365-Settings-1024
Layer2-Cloud-Connector-Sample-Mapping-1024
Layer2-Cloud-Connector-Sample-Log-1024

WHAT YOU NEED

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.

FREQUENTLY ASKED QUESTIONS

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.

 

I am thoroughly impressed with your Cloud Connector software. It is an excellent concept, has extremely comprehensive functionality and is easy to configure.
Brent Seeney, ROI Technologies
The Layer2 Cloud Connector works as advertised and fit very well with my customer’s needs. It was easy to install and configure and the support was responsive and on the mark.
Tim Schwartz, President, ProNet Solutions Group, LLC
We really like the ease of use to synchronize SQL Server data and Office365 through the DMZ. It makes it easy to display ERP system data in the cloud and prepares the way for products like Microsoft Power BI Dashboards and Charts in SharePoint.
Levi Lohnes, Buchanan & Edwards
We have used the Layer2 Cloud Connector and it has really impressed the team at MindPoint. We are keen to use this product in our customer solutions.
Jason Firth, Managing Director, MindPoint
The Layer2 Cloud Connector is a flexible tool which enables us to be responsive to the demands and requirements of our customers.  With Layer2 we are able to develop powerful SharePoint business solutions in a fast, efficient and productive manner.
Barry German, Technical Director, Frontline
The Layer2 Cloud Connector for SharePoint Online will allow BTL to take an innovative and market leading solution to our customers. It opens new doors to the situations that Office 365 can be effectively deployed in to.
Phil Evans, Operations Director, BTL Communication
Cloud connector for Office 365 and SharePoint is an easy to install, no coding required, highly effective solution enabling a stable synchronization between ERP data and SharePoint heightening productivity in our development.
Jiha Yi, Marketing Manager,Feelanet Co., Ltd.
Layer2 Cloud Connector is simple to set up, very stable and gives us the necessary connection between our local data and SharePoint Online.
Terje Haug, Serit IT Partner
The Layer2 Cloud Connector and Business Data List Connector helps our clients in unifying their platforms without excessive investments and get the best out of SharePoint, on-premise and online.
Han Beusker, 4i Solutions
​​Layer2 Sharepoint Connector allows our customers to integrate the Sharepoint environment with different data sources. It is particularly appreciated the feature that allows the integration with the file system.
Jessica Prearo, Pentalab Srl.
The Layer2 Cloud Connector helps us to add value to the Microsoft Cloud offerings and create business solutions for E4D customers with seamless external data integration.
Idan Goldshlager, CEO, E4D Solutions LTD
The Layer2 Cloud Connector is the best integration software for local SharePoint Server and also SharePoint Online and Office 365.
Kai Halonen, Pilvilampi Software Oy
We are very excited about the features and flexibility that Cloud Connector provides to our customers, it synchronizes data easy and comfortable.
Michael Trankjær, IT Eksperten ApS
The Cloud Connector has provided us with a robust and code-free mechanism to seamlessly integrate SAP BW, SAP ERP, SQL Server and SharePoint applications.
Rodolfo Bermúdez, Consulting Manager, Intellego
Our clients use the Layer2 Cloud Connector to overcome the shortcomings of Microsoft Office 365 and OneDrive for Business.
Dan Frederick, Claritech Solutions Corp.
We have implemented the Layer2 Cloud Connector for the www.grupoalltech.com.br company to provide line-of-business product data in Office 365 and to seamlessly integrate business processes.
Odair Bourscheidt, Inconnect Tecnologia
Microsoft SharePoint Online ne permet pas de synchroniser les dossiers d’un File Server sur SharePoint. Nous avons donc choisi Layer2 Cloud Connector pour ajouter cette fonctionnalité à nos projets.
Gilles Dedisse, Chef de Projets, Orditech
Our go-to Layer2 Product is the Cloud Connector. It is an extremely flexible and versatile tool that we've incorporated as part of a larger solution for several of our key customers and internally.
Drew Keenan, Director, Total Calibration
The Layer2 Cloud Connector for Office 365 and the Layer2 Business Data List Connector for SharePoint provide rich options for LOB integration and hybrid ‘on-premise’ to ‘Office 365’ connectivity.
John Ackery, Director, Devworkz Pty Ltd
Layer2 Cloud Connector has been an invaluable tool that allows us to provide our clients with a robust, reliable solution to connect SharePoint with external data sources.
Mike Adkins, Director, RSM US LLP

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