The Layer2 Cloud Connector for Microsoft SharePoint, Office 365 and OneDrive for Business connects and syncs almost any on-premise or cloud-based corporate 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, Dynamics, SAP, SalesForce, file shares, home drives or local directories 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 and without any programming. What do you want to connect today?

 

SharePoint and Office 365 Integration via Layer2 Cloud Connector FAQs

Specifications - Layer2 Data Providers

Layer2 Data Provider for Exchange - Specifications

The Layer2 Cloud Connector can be used to connect Microsoft Exchange data in private or shared post offices or public folders to native SharePoint lists and libraries and almost any other data sources.

Layer2 Data Provider for OData - Specifications

​The Cloud Connector can be used to connect almost any external data source to native SharePoint lists, e.g. external OData via web requests. This FAQ gives the full specifications of the Layer2 Data Provider for OData.

Layer2 Data Provider for SharePoint - Specifications

Specifications of the CSOM-based Layer2 Data Provider for SharePoint to connect to SharePoint 2010 / 2013 or SharePoint Online / Office 365 via ADO.NET.

Layer2 Data Provider for SOAP Web Services - Specification

SOAP Web Services can be connected and synchronized with almost any other data sources codeless using the Layer2 Cloud Connector via the Layer2 Data Provider for SOAP Web Services.

FAQs - Layer2 Cloud Connector

Office 365 Cloud Connector for SharePoint - Version History

Read about the Office 365 Cloud Connector version history, known issues & workarounds here.

Office 365 Integration: How to connect local Excel files to the Microsoft Office 365 cloud?

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 PowerShell scripts to native SharePoint lists for notifications and workflows?

How to connect SharePoint lists (on-premise or online) with PowerShell scripts to enable notifications and workflows.

Office 365 Integration: How to connect MS Dynamics CRM on-premise to Microsoft Office 365?

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 & Azure Integration: How to connect a SQL Azure table to native SharePoint lists?

Office 365 or SharePoint Online can link to Azure documents using an Azure-based link list and replication via the Cloud Connector.

Native SharePoint lists as SQL Azure Web Frontend with full CRUD

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

Twitter & Office 365 integration: How to replicate Twitter feeds to native SharePoint lists, e.g. in Office 365

This FAQ is about integrating / replicating Twitter feeds with native SharePoint lists - on-premise or in the cloud.

Salesforce Integration with Office 365, SharePoint and others

​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 with Office 365 and SharePoint Online: Step-by-step

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.

How to push database field content to SharePoint metadata columns (and write back)?

The Cloud Connector can write metadata like Author, Editor, Creation data / time, last modification time to SharePoint. Here is how it works.

SharePoint Cross-Site Collection and Cross-Tenant Data and Document Synchronization

You can keep list data and documents in sync cross SharePoint or Office 365 site collections and tenants via Layer2 Cloud Connector.

How to sync a local file server with Office 365 / SharePoint Online / OD4B?

You can synchronize your local file server with Office 365, SharePoint Online or OneDrive for Business using the Layer2 Cloud Connector.

Office 365: How to sync external XML data with native SharePoint lists?

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.

Office 365: How to sync external SQL data with native SharePoint 2010 / 2013 lists?

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.

Office 365: Active Directory based corporate phonebook in SharePoint Online

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 / Office 365 Preview and Layer2 Cloud Connector

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?

Microsoft Dynamics CRM Integration with SharePoint

How to sync Microsoft Dynamics CRM contacts with native SharePoint and Outlook contact lists. A step-by-step intro with many image examples.

Layer2 Data Provider for XML - Specifications

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

How to integrate any SharePoint library with BOX.NET?

You can connect any native SharePoint library to any BOX.NET folder for bi-directional replication without any coding using the Layer2 Cloud Connector.

SharePoint External Data Integration Apps: Feature Matrix

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.

How To Access Almost Any Corporate Data Source By Mobile Phone

Office 365 or any SharePoint can act as a cost-effective gateway for content replication between almost any corporate data source and mobile phones.

Office 365: How to sync external Text / CSV data with native SharePoint lists?

You can synchronize external text / CSV data with native SharePoint lists on-premise or in the Office 365 cloud using the Layer2 Cloud Connector.

FileMaker Integration with SharePoint and Office 365

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.

SharePoint Online Large Scale External Data Integration

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.

Data Provider for ODBC - Q & A

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.

How to integrate Office 365 and SharePoint with FoxPro

You can connect local FoxPro files to the Microsoft Office 365 cloud or SharePoint using the Layer2 Cloud Connector for Office 365 & SharePoint.

RSS Feeds: How to integrate with Office 365 and SharePoint

You can connect, sync and aggregate RSS Feeds with native lists in SharePoint or Office 365 using the Layer2 Cloud Connector.

How to create, publish and integrate Access Web Apps with SharePoint Online

You can integrate Microsoft Access Web Apps in SharePoint Online via SQL Azure using the Layer2 Cloud Connector.

How to chart external data in SharePoint Online and Office 365

You can chart external data with SharePoint 2013 and Online using the BlackCompass Vizualizer App and the Layer2 Cloud Connector App.

SAP SharePoint and Office 365 Integration via NetWeaver / OData

SAP can be integrated with SharePoint and Office 365 using SAP NetWeaver and OData with the Layer2 Cloud Connector.

Office 365 Mainframe Integration with IBM AS/400 to SharePoint

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.

How to sync OneDrive for Business with local file shares, home drives, or other corporate data?

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.

RM Unify and Office 365 local data integration

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.

How to connect and sync Exchange contacts with SharePoint contacts

You can connect and sync Exchange contacts with SharePoint contacts codeless and bi-directional, on-premises or in the Office 365 cloud.

IBM Lotus Notes Domino External Data Integration and Synchronization

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 Integration and Synchronization with 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: Data Integration with SharePoint and 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.

Layer2 Cloud Connector Logging and Alerting

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.

Office 365 Integration: Migrating User Fileshares to OneDrive for Business

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 Steps for Troubleshooting Scheduled Sync Issues

Basic troubleshooting instructions for when you cannot get the scheduled sync to run on the Layer2 Cloud Connector.

Office 365: How to sync external Oracle data with native SharePoint lists?

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.

Office 365 File Server Migration and Integration FAQs

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.

How to access on-premises data mobile, offline and with write-back via Office 365

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.

Pre-select local documents for SharePoint Online file synchronization using SQL

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.

How to connect Office 365 Groups with 100+ external systems and apps

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.

Layer2 Cloud Connector Dynamic Columns Feature - How does it work

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.

Office 365 document migration: How to assign managed metadata?

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

How to fix sync issues between local file shares and OneDrive for Business

Additional Microsoft tools can be used to be better prepared for the first document sync to the SharePoint or OneDrive cloud.

Backup Office 365, SharePoint, OneDrive, and Groups to local file server

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.

How to sync Document Sets in SharePoint

Learn how to synchronize SharePoint Document Sets.

Accessing the User Information List in SharePoint

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.

Office 365 Authentication Issue: Html input not found: 't' or 'code'

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

Best Practices: How to sync large amounts of local documents with Office 365

While the Layer2 Cloud Connector has no hard limit for the amount of documents to keep in sync with Office 365, there are best practice advises that could help to avoid common issues.

How to upgrade to Cloud Connector 7.8

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.

How to sync All-Day Events from MS Exchange to SharePoint Online calendar?

You can synchronize your Microsoft Exchange All-Day Events with SharePoint Online using the Layer2 Cloud Connector.

Next Steps

Share this site on Xing
Share this site on Google+
Share this site on LinkedIn

The Layer2 Cloud Connector does what every other SharePoint sync software doesn’t, it syncs both ways and works.

Contact
Frank Daske

Frank Daske

Business Development Manager
+49 (0) 40 28 41 12 - 30
[email protected]

Please note that the 011 exit code must be dialed first for all international calls made from the USA, Canada and Australia.

Related News

Layer2 now connects 100+ commonly used IT systems with Twitter via its Layer2 Cloud Connector

The Layer2 Cloud Connector is now able to connect Twitter to integrate data to a wide range of IT backend systems including Office 365, SharePoint, SQL, ERP/CRM.

New Microsoft Teams Connectors: Layer2 adds 100+ typically used backend systems

​The Layer2 Cloud Connector is now able to connect to Microsoft Teams to quickly integrate more than 100 IT backend systems including local SQL, ERP/CRM.
Related Downloads
PDF Image

Cloud Connector Instruction

Download this step-by-step instruction to connect and sync your corporate or cloud data sources bi-directional to any native SharePoint 2010/2013/2016 list or library, including Microsoft Office 365.
PDF Image

Feasibility Study: Connecting local SQL Server to SharePoint Online

The study compares different approaches for SharePoint Online data integration regarding performance, features, security and investment.
PDF Image

Flyer: Layer2 Partner Program

Partner with us as a software distributer, reseller or SharePoint, Office 365 or Azure service provider. We are offering a free Partner Program with up to 30% Discount, free NFR licenses etc. Please download for more.
PDF Image

Layer2 Case Study: Cloud Connector helps ChemWerth to integrate the Microsoft Office 365 Cloud

"The Cloud Connector’s interface is easy to understand and use. Anyone familiar with utilities in the Microsoft stack will be productive immediately. Our recommendation: The Layer2 Cloud Connector is a no brainer.”
NoDoc Image

Layer2 Cloud Connector PAD File

This XML-based PAD file offers a Layer2 Cloud Connector product description for resellers to download and publish.
PDF Image

Office 365: How to sync with MS Dynamics CRM

You can sync any CRM data with native lists in SharePoint on-prem or online to make it available offline with Outlook.
PDF Image

Office 365: How to sync with SAP?

You can connect SharePoint and Office 365 with SAP via NetWeaver and OData.
PDF Image

Office 365: How to sync your local file share?

When you are moving to the cloud, there are a lot of reasons to keep your local file system. But you don't have to miss the benefits of the cloud.
PDF Image

Product Flyer: Cloud Connector for Microsoft SharePoint & Office 365

Flyer with features, benefits & pricing info for download as PDF.
PDF Image

Product Flyer: SharePoint Online Local File Server Sync

You can centrally migrate, synchronize, or backup your local file server department shares and home drives very flexible with SharePoint Online to close known gaps and overcome limitations of the Microsoft OneDrive for Business client.
PDF Image

Solutions Flyer: Data Integration with SharePoint, Office 365 and 100+

FileMaker can be integrated with 100+ other sources codeless using the Layer2 Cloud Connector.
Related Links

Layer2 Cloud Connector Community Group @ LinkedIn

​Are you already @ LinkedIn? Please join the Cloud Connector Community Group to share your experience.

Microsoft Partner Story Book for Office 365 about Cloud Connector

​Know more about a Layer2 Cloud Connector customer reference at the Microsoft Office web site.

Purchase Layer2 Cloud Connector via ComponentSource

​ComponentSource has offices in the USA, UK and Japan supporting over 125,000+ Customers, in over 180 Countries. They are also an approved Federal Government supplier through the GSA Schedule.

 

cs-award-top-100-publisher-2014-15-large.gif

Sign Up for Layer2 Product Newsletter

We keep you up-to-date about new Layer2 product releases, added features and fixed issues.