Layer2 Cloud Connector FAQ

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 sales@layer2solutions.com 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 sales@layer2solutions.com 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 sales@layer2solutions.com 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.

In some cases it is necessery to wipe everything about the Layer2 Cloud Connector from your host machine. This guide goes into detail where remnants of the software can be found.

When in contact with Layer2 Support, you often are asked by us to send us a support files package. Learn here how to set the trace level and create the package.

​The Layer2 Cloud Connector for Microsoft Office 365 and SharePoint 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.

Learn here about the differences, limitations and benefits of the Layer2 SharePoint provider and the new Layer2 Office 365 Fast File Sync.

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.

Integrate cloud data from Microsoft Teams in a local backup solution easily with the Layer2 Cloud Connector.

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

Learn how to use the Layer2 Cloud Connector to connect Microsoft Access with SharePoint.

Learn how to use the Layer2 Cloud Connector to connect Acquia MySQL with SharePoint

Learn how to use the Layer2 Cloud Connector to connect Act! CRM with SharePoint

Learn how to use the Layer2 Cloud Connector to connect Active Directory with SharePoint

Learn how to use the Layer2 Cloud Connector to connect ActiveCampaign with SharePoint.

Learn how to use the Layer2 Cloud Connector to connect Amazon Redshift with SharePoint

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

Learn how to use the Layer2 Cloud Connector to connect Apptivo with SharePoint.

Learn how to use the Layer2 Cloud Connector to connect Authorize.NET with SharePoint

Learn how to use the Layer2 Cloud Connector to connect files in the Azure file storage with SharePoint

Learn how to use the Layer2 Cloud Connector to connect the Azure table storage with SharePoint

Learn how to use the Layer2 Cloud Connector to connect CentralStationCRM with SharePoint

Learn how to use the Layer2 Cloud Connector to connect Citrix ShareFile with SharePoint

Learn how to use the Layer2 Cloud Connector to connect CiviCRM with SharePoint

Learn how to use the Layer2 Cloud Connector to connect CosmosDB with SharePoint

Learn how to use the Layer2 Cloud Connector to connect Couchbase with SharePoint

Learn how to use the Layer2 Cloud Connector to connect CouchDB with SharePoint

Learn how to use the Layer2 Cloud Connector to connect CSV with SharePoint

Learn how to use the Layer2 Cloud Connector to connect Dropbox with SharePoint

Learn how to use the Layer2 Cloud Connector to connect Dynamics 365 Business Central with SharePoint.

Learn how to use the Layer2 Cloud Connector to connect Elasticsearch with SharePoint

Learn how to use the Layer2 Cloud Connector to connect Excel Online with SharePoint.

Learn how to use the Layer2 Cloud Connector to connect Excel with SharePoint Online.

Learn how to use the Layer2 Cloud Connector to connect File Server with SharePoint.

Learn how to use the Layer2 Cloud Connector to connect Finance and Operations with SharePoint

Learn how to use the Layer2 Cloud Connector to connect Freshservice with SharePoint

Learn how to use the Layer2 Cloud Connector to connect FTP Server with File System

Learn how to use the Layer2 Cloud Connector to connect Gmail with SharePoint

Learn how to use the Layer2 Cloud Connector to connect Google Analytics with SharePoint

Learn how to use the Layer2 Cloud Connector to connect HubSpot with SharePoint.

Learn how to use the Layer2 Cloud Connector to connect Insightly with SharePoint.

Learn how to use the Layer2 Cloud Connector to connect Jira to a SharePoint Online List in Office 365.

Learn how to use the Layer2 Cloud Connector to connect Jive with SharePoint

Learn how to use the Layer2 Cloud Connector to connect Knack with SharePoint

Learn how to use the Layer2 Cloud Connector to connect Magento with SharePoint

Learn how to use the Layer2 Cloud Connector to connect Mailchimp with SharePoint.

Learn how to use the Layer2 Cloud Connector to connect MariaDB with SharePoint

Learn how to use the Layer2 Cloud Connector to connect MariaDB with SharePoint using ODBC

Learn how to connect Microsoft Dataverse with SharePoint using the Layer2 Cloud Connector

Learn how to use the Layer2 Cloud Connector to connect Microsoft Dynamics CRM with SharePoint by using the Dynamics CRM (Layer2) Provider.

Learn how to use the Layer2 Cloud Connector to connect Microsoft Dynamics CRM with SharePoint by using the OData (Layer2) Provider.

Learn how to use the Layer2 Cloud Connector to connect Microsoft Graph with SharePoint

Learn how to connect Microsoft Planner with SharePoint using the Layer2 Cloud Connector

Learn how to use the Layer2 Cloud Connector to connect Microsoft To-Do with SharePoint

Learn how to use the Layer2 Cloud Connector to connect MongoDB with SharePoint

Learn how to use the Layer2 Cloud Connector to connect data in the MongoDB On-Prem with SharePoint

Learn how to use the Layer2 Cloud Connector to connect Nextcloud with SharePoint.

Learn how to use the Layer2 Cloud Connector to connect Nimble with SharePoint

Learn how to use the Layer2 Cloud Connector to connect NTFS extended attributes with SharePoint.

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.

Learn how to use the Layer2 Cloud Connector to connect OneDrive to a Network-attached storage (NAS). We will be synchronizing data stored in OneDrive.

Learn how to use the Layer2 Cloud Connector to connect OnePageCRM with SharePoint

Learn how to use the Layer2 Cloud Connector to connect Open Exchange Rates with SharePoint

Learn how to use the Layer2 Cloud Connector to connect Pipedrive with SharePoint

Learn how to use the Layer2 Cloud Connector to connect PipelineDeals with SharePoint

Learn how to use the Layer2 Cloud Connector to connect PostgreSQL with Flow.

Learn how to use the Layer2 Cloud Connector to connect PostgreSQL with SharePoint

Learn how to use the Layer2 Cloud Connector to connect Quickbooks online with SharePoint

Learn how to use the Layer2 Cloud Connector to connect Salesforce with SharePoint.

Learn how to use the Layer2 Cloud Connector to send SharePoint data to Microsoft Teams

Learn how to use the Layer2 Cloud Connector to connect Smartsheet with SharePoint

Learn how to use the Layer2 Cloud Connector to connect SQL Binary Large Object Fields with SharePoint

Learn how to use the Layer2 Cloud Connector to connect Square with SharePoint

Learn how to use the Layer2 Cloud Connector to connect the SugarCRM with SharePoint

Learn how to use the Layer2 Cloud Connector to connect SuiteCRM with SharePoint

Learn how to use the Layer2 Cloud Connector to connect SCCM with SharePoint

Learn how to use the Layer2 Cloud Connector to connect Twitter with SharePoint

Learn how to use the Layer2 Cloud Connector to connect vtiger with SharePoint

Learn how to use the Layer2 Cloud Connector to connect WebDAV IIS with SharePoint.

Learn how to use the Layer2 Cloud Connector to connect WebDAV on Apache with SharePoint.

Learn how to use the Layer2 Cloud Connector to connect Wrike online with SharePoint

Learn how to use the Layer2 Cloud Connector to connect XML with SharePoint

Learn how to use the Layer2 Cloud Connector to connect ZappySys with SharePoint.

The Transport Layer Security (TLS) in version 1.0 will soon be deprecated and no longer available. Read here how to enable TLS 1.2 on your machine running the Cloud Connector to prevent synchronization downtimes.

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 sales@layer2solutions.com 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 sales@layer2solutions.com 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 sales@layer2solutions.com directly for more.

​​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), 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. 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 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 sales@layer2solutions.com 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.

Learn how to configure the Layer2 Cloud Connector to synchronize data to and from Microsoft Lists in Microsoft Teams

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

If you receive this error: "There is a problem with this Windows Installer package. A program required for the install to complete could not be run." find a resolution here.

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 for Microsoft SharePoint 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.

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 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), 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 on-premise installation - in just minutes without any programming.

This guide explains how the "Not well formatted JSON stream" error is caused

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 sales@layer2solutions.com directly.

​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), 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 on-premises 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.

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

​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 sales@layer2solutions.com 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 sales@layer2solutions.com 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 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.

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.

With the Layer2 Cloud Connector you can use SharePoint add-in (formerly app) credentials to authenticate your SharePoint list or library connection.

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

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.

This guide explains the reason for throttling related error messages and explains how to avoid throttling in the first place.

A client side network issue can cause a 404 error when trying to upload files larger than 300MB to SharePoint Online. Read more about a solution here.

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.