The Layer2 Cloud Connector for SharePoint and Office 365 solves many issues that still exist with SharePoint out-of-the-box external data integration, especially in the cloud. It makes it as easy as possible simple to connect and synchronize native SharePoint lists and libraries with almost any external data source, codelessly and bi-directionally. All native SharePoint features are available for the connected lists or libraries. Please read on to learn more about architecture, installation, and setup.


Layer2 Cloud Connector for SharePoint & Office 365 - Architecture

Office 365 / SharePoint 2010 - Cloud Connector Architecture 
Fig. The Layer2 Cloud Connector runs within the corporate network as a Windows Service to push and pull data from/to native SharePoint lists and libraries in Microsoft SharePoint Server 2010 / 2013 or the Microsoft SharePoint Online / Office 365 to connect with almost any other corporate data source.

Layer2 Cloud Connector for SharePoint & Office 365 - Setup

​Please unzip the distribution file and use the installer provided to setup the solution on any client or server in your corporate network. The client should have an Internet connection enabled and connectivity to your data source (such as a database server) and data destination (such as a SharePoint server).

Supported Platforms

  • Client: Windows 7 /8
  • Server: Windows Server 2008 / 2012

 32-bit and 64-bit systems are both supported. Please select the distribution folder required (you can the install 32-bit version on 64-bit systems, if required). Please note that your drivers must be 32-bit / 64-bit, respectively.

Select Release


Fig. Please carefully select the release to be installed, x64 (64-Bit) or x86 (32-Bit). In case you have to connect to 32-Bit drivers or 32-Bit ODBC, please select x86. This can be used on 64-Bit systems as well.
There is no installation or customization required at the connected data sources or SharePoint servers.
Run the Installer

Next, run the installer as administrator, accept the license agreement, and select the setup type.

Fig. Layer2 Cloud Connector installer.

The following components are available for installation:

  • Base Components: Includes the Connection Service - a Windows service that operates in background to push / pull data as scheduled. Required.
  • Connection Manager: Used for managing your connections as well as to setup, stop / start, display current status, etc of those connections. This also includes a Connection Wizard.
  • Layer2 Data Provider for SharePoint (CSOM): Required to connect to SharePoint on-premises or Online wie with web services.
  • Layer2 Data Provider for OData: Required to connect to OData sources, such as Microsoft Dynamics.
  • Layer2 Data Provider for RSS Feeds: Required to connect to RSS. Can be used to aggregate RSS Feeds in native SharePoint lists. Source code provided as a sample for developers.
  • Layer2 Data Provider for File System: Required to connect to local file system or file shares. You can sync your files server to server or with SharePoint libraries. Works similar to OneDrive, but without the known limitations.
  • Layer2 Data Provider for XML: Required to connect to XML via file or HTTP. Often used to export information from legacy systems as XML and connect the file to SharePoint.
  • Cookie Manager: Required in case cookies used for authentication (not recommended).
  • Sample Connections: Required to have a good starting point for setup. Just copy an appropriate sample and modify for your requirements.
  • Start Menu Shortcuts: Required to find and start your programs. Works for Windows 8 as well.
  • Documentation: Helpful user documentation.
  • Developer Sources: Helpful in case any development is required. Normally, no development  is needed to connect.

Please select "Typical" install if unsure.

    Fig. You can create and manage your connections with the Connection Manager, a Microsoft Windows Management Console application. There are also XML-based configuration files, if you wish to manage your connections manually.
    Here is the basic information needed to set up a connection. See the FAQs for provider-specific instructions:
    • Select a connection provider: The connection provider is the driver layer to use, e.g. ODBC, OLEDB, OData or any other .NET based driver. The connector comes out-of-the-box with a Layer2 CSOM Driver (for SharePoint 2010 / 2013 lists and libraries), a Layer2 OData Driver (for any OData protocol compatible sources) and a Layer2 XML provider to connect XML files and web requests. If no driver present, ask your admininstrator to install, e.g. for Oracle. Client drivers mostly come with the database or other data source software. Export data to Excel/CSV or XML and use ODBC in case no driver is available for your specific system. Please ask for drivers available.
    • Enter the connection string: The connection string contains the information required to connect to the data source. See for more information. You will find many examples of connection strings on the Intenet, at your database vendor's web pages, or in our FAQs.
    • Enter the data query: The data query contains the information required to reference your data selection (for example, "Select * from myTable" for databases). You can give aliases for field names here, call views, or stored procedures and use any functions that are supported by your data source and the provider / driver layer.
    • Field Assignment: Any field in your data source can be associated with a column in the SharePoint list or library. Please think about different field types used on both sides (e.g. String, Integer). Name-based auto-mapping can be used to establish an appropriate mapping automatically.
    • Primary Key(s): To update items (rather than delete and re-insert), one or more primary key(s) (PK) are required. These are fields / columns that have unique values, like a customer number or a counter / GUID field. For many providers, PKs are set automatically.
    • Scheduling: Sets updates to be pushed at specific dates / times or intervals, e.g. 4:00 AM daily or every 15 minutes. Updates are processed in background using the Windows service of the connector via web services.
    Share this site on Xing
    Share this site on Google+
    Share this site on LinkedIn

    This is an owesome tool that allowed us to sync SQL Server and SharePoint data to Office 365 with ease. We were also able to retrieve data from Active Directory into SQL Server in a snap. Their support team is amazingly fast responsive.


     Download & Evaluation

    Please register now to receive your free personal download link via email to your valid company email address.
    Yes, I accept the licensing terms and conditions
    How to buy this product

    With the free editions you can manage a limited number of items per connection. To order a license for the full version please click the shopping cart below.

    Layer2 Cloud Connector
    License List price Buy Now
    FREE Shareware Edition * $0.00
    FREE App Edition *
    App Store only
    $0.00 Go to App Store
    Personal Edition
    1 Single Server
    $499.00 Add to Shopping Card
    1 Annual Software Assurance
    for Personal Edition
    $99.00 Add to Shopping Card
    Professional Edition
    1 Single Server
    $1,407.00 Add to Shopping Card
    1 Annual Software Assurance for Professional Edition $281.00 Add to Shopping Card
    Enterprise Edition **
    1 Single Server


    1 Annual Software Assurance for
    Enterprise Edition **


    Prepaid Remote Support
    1 Hour
    $176.00 Add to Shopping Card
    Please contact in case you want to order directly via Layer2 based on quote, invoice and bank transfer.


    * The Shareware Edition and App Edition is limited to 25 items.

    ** Starting with January 2015 all features of the Enterprise Edition are already included in the Professional Edition.

    More about how to buy see here.

    Related Contacts
    Frank Daske

    Frank Daske

    Business Development Manager
    +49 (0) 40 28 41 12 - 30

    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 Cloud Connector Pro Edition Now Available With Enterprise Features To Simplify Cloud Data Integration

    ​Originally developed for Microsoft SharePoint and Office 365 external data integration, the Layer2 Cloud Connector now allows to connect and sync almost any systems directly with each other codeless.

    Layer2 Cloud Connector V5 Simplifies Data Integration With Microsoft SharePoint, Office 365, Exchange And Dynamics

    Layer2 has announced version 5 of the Cloud Connector for Office 365 and SharePoint integration. The “Swiss-Army Knife” of external data integration and synchronization closes many gaps that still exists with Microsoft’s out-of-the-box cloud offerings.
    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 Office365 Case Study: InnoGames GmbH

    Layer2 led InnoGames to discover Microsoft Office 365, a cloud-based suite of calendaring and productivity tools with anywhere access to email and 24/7 support.
    PDF Image

    Office 365: How to sync with 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

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

    Productflyer: Cloud Connector for Microsoft SharePoint & Office 365

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

    SharePoint Cloud Connector PAD File

    This XML-based PAD file offers a Cloud Connector product description for resellers to download and publish.
    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:




    Layer2 Cloud Connector Community Group @ LinkedIn

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

    Sign Up for Layer2 Product Newsletter

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