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.

How to share pre-selected Intranet documents in a Microsoft Office 365 Extranet?

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.

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 2010, 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 2010/2013, 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 2010, 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 - Specifications

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 codeless and bi-directional 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.

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.

Related Contacts
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

Microsoft Flow Connectors: Layer2 adds 100+ typically used backend systems like SQL/ERP/CRM

The Layer2 Cloud Connector is now able to connect to Microsoft Flow to integrate more than 100 IT backend systems including local SQL, ERP/CRM without programming.

Office 365 Groups Connectors: Layer2 adds 100+ most widely used IT-systems like SQL/ERP/CRM

​The Layer2 Cloud Connector is now available with a new Microsoft Office 365 Groups data provider to notify group members about changes in more than 100 IT systems and apps like SQL, ERP/CRM without programming.
Related Downloads
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

Get in the Cloud – With your corporate data sources connected

Download this step-by-step instruction to connect and sync your corporate or cloud data sources bi-directional to any native SharePoint 2010 / 2013 list or library, including Microsoft Office 365.
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 local SharePoint?

You can replicate selected parts of your SharePoint intranet portal to the Office 365 / SharePoint Online cloud.
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 MS SQL Server

You can sync any Microsoft SQL Server data codeless with SharePoint or Office 365 to make it available for collaboration, search and workflows.
PDF Image

Office 365: How to sync with PowerShell script output?

You can connect PowerShell script output with native SharePoint lists for improved reporting and workflows.
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 with XML data?

Almost any system is able to expose data as XML file or web request. You can simply connect and sync to the Office 365 cloud.
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.
PDF Image

Solutions Flyer: Dynamics AX Data Integration

You can integrate and sync Dynamics AX data with Office 365, SharePoint and 100+ more.
PDF Image

Solutions Flyer: Dynamics NAV Data Integration

Integrate Microsoft Dynamics NAV (Navision) with Office 365, SharePoint and 100+ more codeless via Layer2 Cloud Connector.
PDF Image

Solutions Flyer: Project Online Data Integration

The Cloud Connector can be used to integrate and sync Project Online & Server data with 100+ other data sources.
PDF Image

Solutions Flyer: SQL Server Analysis Services SSAS OLAP Integration

You can integrate and sync SSAS / OLAP data with Office 365, SharePoint and 100+ other systems for better reporting.
Related Links

Cloud Connector @ Microsoft Office 365 Marketplace

Please share your Cloud Connector experience with other customers and rate us at Microsoft Office 365 Marketplace:

 

Microsoft-Office-365-Marketplace.png

 

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.