LAYER2 CLOUD CONNECTOR FAQ

The Layer2 Cloud Connector can integrate data and sync documents between 100+ corporate data sources without programming. It is used to connect services and apps on-premises or cloud-based, such as Microsoft Office 365, SharePoint, Dynamics, Azure, SQL/ERP/CRM, and more for migration, backup, or permanent two-way synchronization. Learn more about specific connectivity options, features and benefits, or find answers to frequently asked questions below.

ALL LAYER2 CLOUD CONNECTOR FAQ

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

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.

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

As one of the leading providers of Microsoft SharePoint apps in Europe Layer2 offers several add-ons for SharePoint external data integration for different customer requirements. Please see here a feature comparision of the Layer2 Business Data List Connector and the Layer2 Cloud Connector products.

This FAQ describes the causes and fixes when getting 'Access Denied' error with connections that use Windows integrated security with the Cloud Connector service.

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.

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

There is no way to define proxy settings within the Cloud Connector itself. Instead, it will use the settings for the user/account as defined on the host machine. Most proxy issues can then be fixed by checking and changing your settings on the host machine. Below are some actions to take to verify you are behind a proxy and what you can do to change your configuration.

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

​The Cloud Connector for Microsoft Office 365 and SharePoint 2010 / 2013 can connect 32-bit and 64-bit ODBC data sources (and almost any other sources) with native list in SharePoint on-premise or online, in just minutes, without any coding, bi-directional if required. This page gives specifications and help about how to use the ODBC Data Provider with the Cloud Connector.

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.

You can highly increase the benefits of any Office 365 plan by external data integration and file sync with 100+ typically local and cloud-based IT-systems and apps.

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.

"We couldn't sync this library." in SharePoint Online is a typical error message to receive if you try to sync document libraries to a local drive using the OneDrive for Business client. This could have many reasons. See below about how to solve all of it using the Layer2 Cloud Connector.

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 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. For any questions please use the FAQ Web Form or contact [email protected] directly.

Microsoft OneDrive for Business can be connected and synchronized without code and bi-directionally with any local file shares, home drives, etc., using the Layer2 Cloud Connector with very flexible sync options. No issues with syncing more than 5.000 items per library. Database content can be synced as well. See below for a step-by-step intro.

If you plan to upgrade to version 7.8, please read the information here. We made some interesting improvements that will need, in some cases, your attention.

The Layer2 Cloud Connector can work with Office 365 Multi-Factor-Authentication! This guide describes how to enable a app password so the Cloud Connector can continue to work even with MFA enabled.

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

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 Cloud Connector for Microsoft SharePoint 2010 and Office 365 takes your local line-of-business data and documents to your cloud-based or any other hosted SharePoint - easy to connect, secure, always up-to-date, and bi-directional, if required. More information and download here.

Know more about Layer2 Cloud Connector editions and licensing.

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.

​The Layer2 Cloud Connector can be used to connect almost any external data source to Microsoft Exchange, on-premises or Exchange Online & Office 365. This page gives the full specifications of the Layer2 Data Provider for Exchange which is included in the Cloud Connector product starting with version 5.

The Layer2 Data Provider for File System can be used to sync local documents with SharePoint libraries including Office 365, Teams, Groups, and more.

​​The Layer2 Cloud Connector for SharePoint can be used to connect almost any external data sources to native SharePoint lists and libraries, for example via the OData protocol as used by many applications, e.g. SAP or Microsoft CRM/ERP systems. This FAQ gives the full specifications of the Layer2 Data Provider for OData that is fully included in the product.

The Layer2 Cloud Connector can be used to keep files and documents in sync between file shares and SharePoint libraries, or between different SharePoint libraries for migration, backup or permanent two-way sync. This FAQ gives the full specifications of the Layer2 Data Provider for Office 365 Fast File Sync that is included with the connector since version 7.9.

The Cloud Connector can be used to connect to almost any data source, even external SharePoint data - on-premise, internally or externally hosted, or in the Microsoft SharePoint Online / Office 365 cloud. This FAQ gives the full specifications of the CSOM-based Layer2 Data Provider for SharePoint that comes with the Cloud Connector.

SOAP Web Services data can be connected and synchronized with almost any other data sources, including SharePoint, Office 365, Exchange, Dynamics, SQL and others codeless using the Layer2 Cloud Connector via the Layer2 Data Provider for SOAP Web Services. The article below gives a short specification and usage samples of the data provider.

The Layer2 Cloud Connector for SharePoint can be used to connect almost any external data sources to native SharePoint lists and libraries, even external XML data, file-based or based on web requests. XPath queries can be used to retrieve the data set required. This FAQ gives the full specifications of the Layer2 Data Provider for XML included in product.

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.

Office 365 authentication error: 'Html input not found' in Layer2 Cloud Connector. There are workarounds for this known issue.

​The Layer2 Cloud Connector can assign managed metadata automatically to documents during SharePoint Online migration from file servers using Dynamic Columns in C#.

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

​The Layer2 Cloud Connector can be used to connect and synchronize Salesforce data with almost any other data source codeless and bi-directional. This step-by-step intro shows how to integrate with native SharePoint lists in the Microsoft SharePoint Online / Office 365 cloud. SharePoint 2010/13/16 on-premise is supported as well. Note that SharePoint is just an example. You can also sync Salesforce to any SQL or other supported data sources.

​The seamless integration of external corporate data is a typical requirement in hybrid cloud-based projects, sometimes not easy to solve. It is not about migration only, it is about integration. And integration is not about displaying data only. It's about FULL integration, e.g. in search, content categorization, change notifications, workflows to start business processes right in the cloud. This article shows how easy full integration is today, e.g. with SAP data and SharePoint Online / Office 365 using the Layer2 Cloud Connector without any coding, just a few minutes of configuration.

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 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. For any questions please use the FAQ Web Form or contact [email protected] directly.

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

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.

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.

LEARN MORE ABOUT THE LAYER2 CLOUD CONNECTOR

Visit the detailed product page

Visit the Layer2 Cloud Connector page to learn more about the product, its main features, benefits, and use cases.

Learn about specific features and benefits

Find a detailed description of the Layer2 Cloud Connector features and benefits on this page.

Find 100+ connectivity options

Find connectivity options to keep 100+ systems and apps in sync via Layer2 Cloud Connector by topic.

Can't find what you are looking for?

A web site cannot answer all questions. Contact us directly to get answers quickly via email or phone.

READY FOR THE NEXT STEPS?

Register for free download

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