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. You will find the Layer2 Cloud Connector User Documentation here.

SharePoint-Online-Integration-Layer2.png

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 / 2012 R2

 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

 

Office-365-Cloud-Connector-Distribution.PNG
 
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.

Office-365-Installation-Connector-1.PNG 
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.
    Required.
  • 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:
    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.
    Name: 
    Company: 
    Country: 
    Phone: 
    E-mail: 
    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
    License
    $499.00 Add to Shopping Card
    1 Annual Software Assurance
    for Personal Edition
    $99.00 Add to Shopping Card
    Professional Edition
    1 Single Server
    License
    $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
    License

    $6,390.00

    1 Annual Software Assurance for
    Enterprise Edition **

    $1,290.00

    Prepaid Remote Support
    1 Hour
    $176.00 Add to Shopping Card
    Please contact [email protected] 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
    [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 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 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.”
    PDF Image

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

    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

    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:

     

    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.

    Sign Up for Layer2 Product Newsletter

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