FAQs - Layer2 Cloud Connector
Read about the Office 365 Cloud Connector version history, known issues & workarounds here.
You can connect local Excel files to the Microsoft Office 365 cloud using the Cloud Connector for Office 365 & SharePoint 2010. A sample connection configuration file is given.
How to connect SharePoint lists (on-premise or online) with PowerShell scripts to enable notifications and workflows.
You can connect your local on-premise Microsoft Dynamics CRM to the Microsoft Office 365 cloud using the Cloud Connector for Office 365 & SharePoint 2010. A sample is given.
Office 365 or SharePoint Online can link to Azure documents using an Azure-based link list and replication via the Cloud Connector.
It's easy to connect native SharePoint 2010 lists to SQL Azure tables and queries codeless and in just minutes. Optionally the connection can be bi-directional with two-way data replication.
This FAQ is about integrating / replicating Twitter feeds with native SharePoint lists - on-premise or in the cloud.
Salesforce Integration: Data can be connected and synced with almost any external data sources, including native SharePoint lists without any programming in a few minutes.
SAP integration in Office 365 and SharePoint Online is explained step-by-step. Native SharePoint lists are connected to SAP data with all usual SharePoint list features available, e.g. change notifications and workflows.
The Cloud Connector can write metadata like Author, Editor, Creation data / time, last modification time to SharePoint. Here is how it works.
You can transfer pre-selected documents automatically from your local on-premise SharePoint document library to your SharePoint Online / Office 365 cloud-based extranet using the Cloud Connector.
You can synchronize your local file server with Office 365, SharePoint Online or OneDrive for Business using the Layer2 Cloud Connector.
You can synchronize external XML data e.g. file or web requests with native SharePoint lists in SharePoint, Online or Office 365 using the Cloud Connector.
You can synchronize external SQL data e.g. SQL Server, Oracle, MySQL etc. with native SharePoint lists in SharePoint on-premise, Online or Office 365 using the Cloud Connector - bi-directional, if required.
You can synchronize external Active Directory data with native SharePoint contact lists in SharePoint on-premise, Online or Office 365 using the Cloud Connector and sync to Outlook clients for offline usage.
SharePoint 2013 and the Office 365 Preview have a lot of new options to connect to external data sources. Why the Cloud Connector is still the most efficient way to connect?
How to sync Microsoft Dynamics CRM contacts with native SharePoint and Outlook contact lists. A step-by-step intro with many image examples.
The Cloud Connector can be used to connect almost any external data source to native SharePoint lists, even external XML data, file-based or based on web requests. This FAQ gives the full specifications of the Layer2 Data Provider for XML.
You can connect any native SharePoint library to any BOX.NET folder for bi-directional replication without any coding using the Layer2 Cloud Connector.
As one of the leading providers of SharePoint add-ons in Europe Layer2 offers several add-ons for SharePoint external data integration for different customer requirements.
Office 365 or any SharePoint can act as a cost-effective gateway for content replication between almost any corporate data source and mobile phones.
You can synchronize external text / CSV data with native SharePoint lists on-premise or in the Office 365 cloud using the Layer2 Cloud Connector.
The Layer2 Cloud Connector for SharePoint and Office 365 can sync FileMaker data with native cloud-based or any other SharePoint 2010 or 2013 lists - easy to connect, secure and always up-to-date.
You can integrate SharePoint Online lists with external data sources with more than 5.000 items (list view throttling limit) without any issues by data synchronization via the Layer2 Cloud Connector.
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.
You can connect local FoxPro files to the Microsoft Office 365 cloud or SharePoint using the Layer2 Cloud Connector for Office 365 & SharePoint.
You can connect, sync and aggregate RSS Feeds with native lists in SharePoint or Office 365 using the Layer2 Cloud Connector.
You can integrate Microsoft Access Web Apps in SharePoint Online via SQL Azure using the Layer2 Cloud Connector.
You can chart external data with SharePoint 2013 and Online using the BlackCompass Vizualizer App and the Layer2 Cloud Connector App.
SAP can be integrated with SharePoint and Office 365 using SAP NetWeaver and OData with the Layer2 Cloud Connector.
The Layer2 Cloud Connector for Office 365 can integrate and synchronize IBM mainframe data sources like AS/400 into the Microsoft Office 365 and SharePoint Online cloud, as well as with SharePoint on-premise, in just minutes codeless.
OneDrive for Business can be connected and synchronized codeless and bi-directional with any local file shares, home drives etc. using the Layer2 Cloud Connector.
The Layer2 Cloud Connector can be used to integrate the UK-based RM Unify cloud of Microsoft Office 365 with almost any local data sources.
You can connect and sync Exchange contacts with SharePoint contacts codeless and bi-directional, on-premises or in the Office 365 cloud.
The Layer2 Cloud Connector can be used to connect almost any external data source to IBM Lotus Notes Domino via ODBC codeless. This page gives an example about how to connect and sync Notes data with Microsoft SharePoint or Office 365.
PostgreSQL can be connected and synchronized with almost any other corporate data sources, e.g. Microsoft SharePoint or Office 365, codeless and bi-directional via the Layer2 Cloud Connector.
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.
The Layer2 Cloud Connector can log to various targets including log files, Windows Event Log, SQL databases, and send email notifications using the NLog framework.
You can migrate local user home drives to OneDrive for Business using the Layer2 Cloud Connector. A PowerShell script helps to provision the user pages, create the connection files and grant the Cloud Connector Service access to each user page.
Basic troubleshooting instructions for when you cannot get the scheduled sync to run on the Layer2 Cloud Connector.
You can synchronize external Oracle data with native SharePoint lists in SharePoint Server, Online or Office 365 using the Cloud Connector - bi-directional, if required.
Integrating a local file server with SharePoint Online could highly increase the benefit of any Office 365 subscription. Typical questions are answered regarding such a hybrid environment.
You can access your on-premises business data like SQL, ERP or CRM via Office 365 mobile on any device, and also offline with write-back of changes.
The Layer2 Cloud Connector can help to close known gaps of the Microsoft OneDrive for Business client with SQL-style document pre-selections for data synchronization with SharePoint Online.
Microsoft Office 365 Groups offers a completely new way of team collaboration. The Layer2 Cloud Connector can help to integrate 100+ external systems and apps like SQL/ERP/CRM codelessly to notify Group members about any changes in the connected systems.
The Dynamic Columns feature allows users to define additional data columns. The values of these columns are calculated at run-time using C#, and can be based on the content of the other columns originating from the data entity.
The Layer2 Cloud Connector can assign managed metadata automatically to documents during SharePoint Online migration from file servers using dynamic columns in C#.
Additional Microsoft tools can be used to be better prepared for the first document sync to the SharePoint or OneDrive cloud.
You can backup pre-selected 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.
Learn how to synchronize SharePoint Document Sets.
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.