Popular 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 popular answers to frequently asked questions below.

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.

​The migration, synchronization, or backup of pre-selected files on local department’s network file shares or user’s home drives is often one of the first steps when companies or organizations are moving to the Microsoft Cloud. However, Microsoft’s free out-of-the-box tool, the OneDrive for Business sync client, is known to have issues and limitations regarding file selection, file name conventions, file types allowed, number of documents supported for sync, and platform availability. The Layer2 Cloud Connector can help to close these gaps with flexible, SQL-style pre-selection queries of local document sets for synchronization.

​You can backup documents in Office 365, SharePoint, OneDrive for Business, and Office Groups to a local file server via the Layer2 Cloud Connector and use your existing backup tool to maintain an archive.

​The Layer2 Cloud Connector connects 100+ on-premises and also cloud-based data sources codeless with Microsoft Office 365, but also directly with each other - codeles, in just minutes without any programming. The data is synchronized automatically as scheduled. See below for known issues and workarounds with scheduling.

​With the Layer2 Cloud Connector, you can make use of your documents and files stored on a local file server or NAS in the Microsoft Cloud, such as Office 365, OneDrive for Business, Office Groups, or Microsoft Teams. But what to do when the number of files you want to use are amounting to 50K or more?

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.

​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.

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.

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.

Version 7 of the Layer2 Cloud Connector comes with a Dynamics Columns feature. This feature allows users to define new data columns in addition to the ones that are returned by a data entity. The values of these columns are calculated at run-time via C# code, and can be based on the content of other columns. This allows for customized calculations, conversions, translations, and formatting of the data to be synchronized between 100+ systems and apps, e.g. Microsoft SharePoint, Office 365, Dynamics, SQL, ERP/CRM and more.

The Layer2 Cloud Connector creates a variety of messages about its activities during synchronization. These messages will at first be filtered by the current global log level. Any message that gets through to this filter will be handed to the logging subsystem NLog. NLog is a free logging framework used by the Layer2 Cloud Connector system to manage its logging activities.

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.

​Integrating your local file server with SharePoint Online could highly increase the benefit of any Office 365 subscription. Below typical questions are answered regarding such a hybrid environment.

​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 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.

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.

The Layer2 Cloud Connector for Office 365 and SharePoint can be used to connect almost any external data source to native SharePoint lists, e.g. SQL, ERP/CRM, XML, ODBC, OLEDB, OData etc. It is made for large scale external data integration scenarios as well and can manage more than 5.000 items without any issues. It helps to overcome the SharePoint limitations with out-of-the-box data integration via BCS using data synchronization.

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.