Use Case Faq of the Layer2 Cloud Connector

The Layer2 Cloud Connector can integrate data and sync documents between 100+ typically used IT systems and apps without programming. Find answers to frequently asked questions about Layer2 Cloud Connector use cases below. To learn more about specific connectivity options take a look at the Solution Finder.

The Cloud Connector for Microsoft Office 365 and SharePoint connects almost any on-premise data source, e.g. ODBC, OLEDB, OData, Microsoft .NET based providers, Files content (Excel, XML, CSV), File shares, SQL databases like SQL Server, Oracle, MySQL, IBM DB2, IBM AS/400, IBM Informix, Notes, SharePoint, Exchange, Active Directory, Navision, SAP, PowerShell and many more directly to native SharePoint lists and libraries in the Microsoft Office 365 cloud - or any other Microsoft SharePoint on-premise installation - in just minutes without any programming. The step-by-step intro below is about connecting to SQL Server.

You can access your on-premises business data and documents mobile on any device, and also offline with write-back of changes, using Microsoft Office 365, the Layer2 Cloud Connector and harmon.ie Mobile.

​The Layer2 Cloud Connector for Microsoft Office 365 and SharePoint can connect almost any data source including the new Microsoft Access Web Apps in SharePoint Online. For any questions please use the FAQ Web Form or contact [email protected] directly.

The Cloud Connector for Microsoft Office 365 and SharePoint connects almost any on-premise data source, e.g. ODBC, OLEDB, Microsoft .NET based providers, Files (Excel, XML, CSV), SQL databases like SQL Server, Oracle, MySQL, IBM DB2, IBM AS/400, IBM Informix, Notes, SharePoint, Exchange, Active Directory, Navision, SAP and many more directly to native SharePoint lists in the Microsoft Cloud - or any other Microsoft SharePoint installation - in just minutes without any programming. For any questions please use the FAQ Web Form or contact [email protected] directly.

​The Layer2 Cloud Connector for Microsoft Office 365 and SharePoint connects almost any on-premise data source, e.g. ODBC, OLEDB, OData, Microsoft .NET based providers, Files (Excel, XML, CSV), SQL databases like SQL Server, Oracle, MySQL, IBM DB2, IBM AS/400, IBM Informix, Notes, SharePoint, Exchange, Active Directory, Navision, SAP and many more directly to native SharePoint lists and libraries in the Microsoft Cloud - or any other Microsoft SharePoint installation - in just minutes without any programming. For any questions please use the FAQ Web Form or contact [email protected] directly.

It is possible to get to the User Information List, a hidden list containing all the users stored in a SharePoint site. You can get to the data either through CSOM as you would a normal SharePoint list, or you can use the OData web services.Learn here how.

​The Layer2 Cloud Connector for Microsoft Office 365 and SharePoint connects almost any on-premise data source, e.g. ODBC, OLEDB, Microsoft .NET based providers, Files (Excel, XML, CSV), File Shares, SQL databases like SQL Server, Oracle, MySQL, IBM DB2, IBM AS/400, IBM Informix, Notes, SharePoint, Exchange, Active Directory, Navision, SAP and many more directly to native SharePoint lists and libraries in the Microsoft Cloud - or any other Microsoft SharePoint 2010 / 2013 installation - in just minutes without any programming. This FAQ is about connecting the output of PowerShell scripts with SharePoint lists to enable notifications and workflows, e.g. on specific data changes.

While the Microsoft OneDrive for Business document synchronization client is a free tool for end-users, the Layer2 Cloud Connector offers advanced features as often needed to solve typical business requirements with Microsoft cloud data integration, file migration, backup, or synchronization. Find a comparison of the OneDrive Sync Client and the Layer2 Cloud Connector in this fact sheet.

The Layer2 Cloud Connector for SharePoint and Office 365 can sync FileMaker data with cloud-based SharePoint Online / Office 365 or any other native SharePoint on-premise lists - easy to connect, secure and always up-to-date. No coding, changes or installation at FileMaker or SharePoint required.

​You can access almost any corporate data source by your mobile phone using the new Microsoft Office Web Apps and the Layer2 Cloud Connector for Office 365 and SharePoint. Office 365 (or any other SharePoint) acts as a cost-effective gateway for content replication while the Cloud Connector opens it for external corporate data sources.

​You can visualize external list data in SharePoint 2013 or SharePoint Online using the BlackCompass Visualizer to chart together with the Layer2 Cloud Connector for SharePoint and Office 365 for data integration. Lots of common chart types supported with auto-update on data change, support for large datasets etc. Read the below for a step-by-step intro.

​The Layer2 Cloud Connector for Microsoft SharePoint, Office 365 and OneDrive for Business out-of-the-box comes with the Layer2 Provider for Microsoft Exchange. Using this data provider you can connect and sync almost any external data source with Exchange items. See below for a step-by-step example to sync Exchange contacts with a SharePoint contact list. Please note that SharePoint is an example only: You can sync to any SQL database or ERP/CRM etc. in a very similar way.

Microsoft Office 365 Groups offers a completely new way of team collaboration, directly within Office Outlook, Outlook Web Access or mobile apps. You can easily share email, notes, documents, events, and more with your team members. The Layer2 Cloud Connector can help to integrate 100+ external systems and apps like local or cloud-based SQL/ERP/CRM codelessly to notify Group members about any changes in the connected systems.

The Layer2 Cloud Connector runs a Windows Service to migrate, sync or backup documents between local file server and SharePoint on-prem and online, OneDrive for Business or Office 365 Groups. It fixes many common sync issues automatically. Additional tools can be used to be better prepared for the first sync.

​​The Cloud Connector for Microsoft Office 365 and SharePoint connects almost any on-premise data source, e.g. ODBC, OLEDB, OData, Microsoft .NET based providers, Files (Excel, XML, CSV), SQL databases like SQL Server, Oracle, MySQL, IBM DB2, IBM AS/400, IBM Informix, Notes, SharePoint, Exchange, Active Directory, Navision, SAP and many more directly to native SharePoint lists and libraries in the Microsoft Cloud - or any other Microsoft SharePoint on-premise installation - in just minutes without any programming. This article is about integration of the BOX.NET cloud service with SharePoint libraries to increase the value of file sharing with collaboration. For any questions please use the FAQ Web Form or contact [email protected] directly. Please note that you need Cloud Connector Version 4.2 and higher to connect.

​The Layer2 Cloud Connector for Microsoft Office 365 and SharePoint connects almost any on-premise data source, e.g. ODBC, OLEDB, Microsoft .NET based providers, Files (Excel, XML, CSV, Access, FoxPro, DBase), SQL databases like SQL Server, Oracle, MySQL, IBM DB2, IBM AS/400, IBM Informix, Notes, SharePoint, Exchange, Active Directory, Navision, SAP and many more directly to native SharePoint lists in the Microsoft Cloud - or any other Microsoft SharePoint on-premise installation - in just minutes without any programming. For any questions please use the FAQ Web Form or contact [email protected] directly.

The Cloud Connector for Microsoft Office 365 and SharePoint connects almost any on-premise data source, e.g. ODBC, OLEDB, Microsoft .NET based providers, Files (Excel, XML, CSV), SQL databases like SQL Server, Oracle, MySQL, IBM DB2, IBM AS/400, IBM Informix, Notes, SharePoint, Exchange, Active Directory, Navision, SAP and many more directly to native SharePoint lists in the Microsoft Cloud - or any other Microsoft SharePoint installation - in just minutes without any programming. For any questions please use the FAQ Web. Please contact [email protected] directly for more.

​​The Cloud Connector for Microsoft Office 365 and SharePoint 2010 connects almost any on-premise data source, e.g. ODBC, OLEDB, Microsoft .NET based providers, Files (Excel, XML, CSV), SQL databases like SQL Server, Oracle, MySQL, IBM DB2, IBM AS/400, IBM Informix, Notes, SharePoint, Exchange, Active Directory, Navision, SAP and many more directly to native SharePoint lists in the Microsoft Cloud - or any other Microsoft SharePoint 2010 installation - in just minutes without any programming. This FAQ is about Twitter integration.

You can keep documents at your local file server or NAS in sync with SharePoint libraries, such as used in Microsoft Office 365, SharePoint Online or on-premises, OneDrive for Business, Microsoft Teams, Office Groups, and others one-way or two-way without any programming.

If you have the requirement to synchronize calendars from Exchange to SharePoint, there was no way to do that wirth the help of the Layer 2 Cloud Connector.

Learn how to synchronize SharePoint Document Sets.

​The Layer2 Cloud Connector can be used to connect and sync almost any external data source to IBM Lotus Notes and Domino via ODBC codeless. This page gives an example about how to connect and sync Notes data with Microsoft SharePoint or Office 365.

Microsoft Access can be connected and synchronized with almost any other corporate data sources, including Microsoft SharePoint, Office 365 and OneDrive for Business, using the Layer2 Cloud Connector for codeless data integration in just minutes.

​How do you integrate Microsoft Dynamics CRM online or on-premises with SharePoint and Outlook? The Cloud Connector for Microsoft Office 365 and SharePoint connects almost any on-premises data source, e.g. ODBC, OLEDB, OData, Microsoft .NET-based providers, Files (Excel, XML, CSV), SQL databases (like SQL Server, Oracle, MySQL, IBM DB2, IBM AS/400, IBM Informix, Notes), SharePoint, Exchange, Active Directory, Navision, SAP, and many more directly to native SharePoint lists and libraries in the Microsoft Cloud - or any other Microsoft SharePoint installation - in just minutes without any programming.

The Cloud Connector for Microsoft Office 365 and SharePoint 2010 connects almost any on-premise data source, e.g. ODBC, OLEDB, Microsoft .NET based providers, Files (Excel, XML, CSV), SQL databases like MS SQL Server, SQL Azure, Oracle, MySQL, IBM DB2, IBM AS/400, IBM Informix, Notes, SharePoint, Exchange, Active Directory, Navision, SAP and many more directly to native SharePoint lists in the Microsoft Cloud - or any other Microsoft SharePoint 2010 installation - in just minutes without any programming. For any questions please use the FAQ Web Form or contact [email protected] directly.

​The Layer2 Cloud Connector for Microsoft Office 365 and SharePoint connects almost any on-premise data source, e.g. ODBC, OLEDB, OData, Microsoft .NET based providers, File content (Excel, XML, CSV, Access, FoxPro, dBase), SQL databases like SQL Server, Oracle, MySQL, IBM DB2, IBM AS/400, IBM Informix, Notes, SharePoint, Exchange, Active Directory, Navision, SAP and many more directly to native SharePoint lists and libraries in the Microsoft Office 365 cloud - or any other Microsoft SharePoint installation - in just minutes without any programming. For any questions please use the FAQ Web Formor contact [email protected] directly.

​The Cloud Connector for Microsoft Office 365 and SharePoint 2010 connects almost any on-premise data source, e.g. ODBC, OLEDB, Microsoft .NET based providers, Files (Excel, XML, CSV), SQL databases like SQL Server, Oracle, MySQL, IBM DB2, IBM AS/400, IBM Informix, Notes, SharePoint, Exchange, Active Directory, SAP and many more directly to native SharePoint lists in the Microsoft Cloud - or any other Microsoft SharePoint 2010+ installation - in just minutes without any programming. It can also be used to integrate Microsoft Dynamics CRM on-premise with the Microsoft Office 365 cloud. For any questions please use the FAQ Web Form or contact [email protected] directly.

​The Layer2 Cloud Connector can integrate and synchronize IBM mainframe data sources like AS/400 with the Microsoft Office 365 and SharePoint Online cloud, as well as with SharePoint on-premises, in just minutes and absolutely codeless. Bi-directional connections are also supported. It could additionally sync to almost any other systems, like ERP/CRM/CMS or SQL.

​The Layer2 Cloud Connector for Office 365 and SharePoint can be used to migrate user home drives to OneDrive for Business automatically. A PowerShell script helps to provision the user pages, create the connection files and grant the Cloud Connector Service access to each user page.

​The Cloud Connector for Microsoft Office 365 and SharePoint connects almost any on-premise data source, e.g. ODBC, OLEDB, OData, Microsoft .NET based providers, Files (Excel, XML, CSV), SQL databases like SQL Server, Oracle, MySQL, IBM DB2, IBM AS/400, IBM Informix, Notes, SharePoint, Exchange, Active Directory, Navision, SAP and many more directly to native SharePoint lists and libraries in the Microsoft Cloud - or any other Microsoft SharePoint installation - in just minutes without any programming. For any questions please use the FAQ Web Form or contact [email protected] directly.

​The Cloud Connector for Microsoft Office 365 and SharePoint connects 100+ data sources to the Microsoft Cloud, e.g. ODBC, OLEDB, OData, Microsoft .NET based providers, Files content (Excel, XML, CSV), File shares, SQL databases like SQL Server, Oracle, MySQL, IBM DB2, IBM AS/400, IBM Informix, Notes, SharePoint, Exchange, Active Directory, Navision, SAP, PowerShell - in just minutes without any programming. The step-by-step intro below is about connecting to Oracle data queries.

​PostgreSQL, often simply "Postgres", is an open source object-relational database management system (ORDBMS) that can be connected and synchronized with almost any other corporate data sources, e.g. native lists in Microsoft SharePoint or Office 365, codeless and bi-directional via the Layer2 Cloud Connector.

​RSS Feeds are integrated with SharePoint via the Layer2 Cloud Connector for Microsoft Office 365 and SharePoint. It connects almost any on-premises or cloud-based data source, e.g. ODBC, OLEDB, Microsoft .NET based providers, Files (Excel, XML/RSS, CSV, Access, FoxPro, DBase), SQL databases like SQL Server, Oracle, MySQL, IBM DB2, IBM AS/400, IBM Informix, Notes, SharePoint, Exchange, Active Directory, Navision, SAP and many more directly to native SharePoint lists in the Microsoft Cloud - or any other Microsoft SharePoint on-premise installation - in just minutes without any programming. For any questions please use the FAQ Web Form or contact [email protected] directly.

SAP integration into Office 365 and SharePoint is a typical project requirement, but sometimes not easy to solve. It is not only about data migration, it is about permanent integration in a hybrid scenario. And integration is not about displaying data in SharePoint, e.g. using Web Parts or BCS. It's about FULL integration, e.g. in SharePoint search, content categorization, change notifications, workflows to start business processes right in SharePoint in case of external data changes in SAP. This article shows how easy full SAP to SharePoint and Office 365 integration is today using the Layer2 Cloud Connector and the Layer2 Data Provider for OData via SAP NetWeaver without any coding. It just needs a few minutes of configuration.

​You can keep SharePoint or Office 365 list data and documents in sync cross site collections or even cross tenants via the Layer2 Cloud Connector. This could solve typical requirements such as connecting different SharePoint sites, site collections, SharePoint 2010/2013/2016 on-prem installations (local or hosted by providers), and on-premises sites to Office 365, e.g. to publish pre-selected items or documents from intranet to extranet. You can sync one-way, or even two-way. Documents in Office Groups are supported as well as in Microsoft Teams. For any questions please use the FAQ Web Form or contact [email protected] directly.

RM Education Ltd. is one of the leading suppliers of ICT to UK education. RM Unify is their cloud-based web application, now fully integrated with Microsoft Office 365. The Layer2 Cloud Connector can be used to connect to RM Unify, federated with Office 365, and sync almost any external data sources like databases, files or other local or cloud-based organizational data with native SharePoint Online lists and libraries. A great benefit for any school or university.

Ready for the next steps?

Ifoc for free trial product regsitration - Layer2 leading solutions

Register for free download

No credit card required. Register, download and try as long as you want. It's all free.