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 to connect and synchronize native SharePoint lists and libraries with almost any external data source, codeless and bi-directional. All native SharePoint features are available for the connected lists or libraries. Please read more about architecture, installation and setup 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 sources.

Layer2 Cloud Connector for SharePoint & Office 365 - Setup

​Please unzip the distribution and use the installer provided to setup the solution on any client (Windows 7 or 8) or server (Windows Server 2008 / 2012) in your corporate network with Internet connection (via HTTP) enabled and connectivity to your data source (e.g. to a database server) and data destination (e.g. to a SharePoint server). 32-bit systems are supported as well as 64-bit systems. Please select the distribution folder required (you can install 32-bit 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 select carefully 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 customizing required at the data sources or SharePoint servers connected.
 
Run the installer
 

As a next step please 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: Manage your connections here to setup, stop/start, display current status etc. This also includes a Connection Wizard.
    Required.
  • Layer2 Data Provider for SharePoint (CSOM): Required to connect to SharePoint on-premise or Online wie web services..
  • Layer2 Data Provider for OData: Required to connect to OData sources, e.g. Microsoft Dynamics or other.
  • 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 Skydrive, 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 appropiate sample and modify for your requirements.
  • Startmenu Shortcuts: Required to find and start your programs. Works for Windows 8 as well.
  • Documentation: Helpful, goes to the documentation folder of the installation.
  • Developer Sources: Helpful in case any development is required. Normally no development needed to connect.

Please select complete install if unsure.

    Fig.: You can create and manage your connections with the Connection Manager, a Microsoft Windows Management Console application. But XML-based configuration files still exist, so you can manage your connections manually as well.
    To setup a connection please follow the documentation. See FAQs for examples:
    • 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 admin to install, e.g. for Oracle. Client drivers mostly come with the database or other data source software. Please ask sales@layer2.de for drivers available. Export data to Excel/CSV or XML and use ODBC in case no driver is available for your specific system.
    • Enter the connection string: The connection string contains the information required to connect to the data source. See www.connectionstrings.com for more information. You will find many samples for connection strings in 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, e.g. "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 appropiate mapping automatically.
    • Primary Key(s): To update items (rather then delete and re-insert) one or more primary key(s) (PK) is / are required, that means fields / columns that have uniue values, e.g. a customer # or a counter / GUID field. For many providers PKs are automatically set.
    • Scheduling: Updates are 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.
    Name: 
    Company: 
    Country: 
    Phone: 
    E-mail: 
    Yes, I accept the licensing terms and conditions
    How to buy this product

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

    Layer2 Cloud Connector for
     SharePoint, Office 365 and OneDrive for Business
    License List price Buy Now
    FREE Shareware Edition $0.00
    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

    Add to Shopping Card
    1 Annual Software Assurance for
    Enterprise Edition

    $1,290.00

    Add to Shopping Card
    Prepaid Remote Support
    1 Hour
    $176.00 Add to Shopping Card
    You can also order by phone, fax or email:
    Order Service USA
    (Language: English)

    Share-it c/o Digital River, Inc. 10380 Bren Road West Minnetonka, MN 55343, USA Phone from outside the U.S.:
    +1 952 646-5747
    Phone from within the U.S.:
    +1 800 903-4152
    Fax: +1 952 646-4552
    support@us.shareit.com

    Order Service Europe (Languages: German, English, French, Italian, Spanish, Portuguese)

    Share-it - Digital River GmbH c/o
    Digital River Ireland Ltd. Unit 153 Shannon
    Free Zone West Shannon Co. Clare Ireland
    Phone: +49 221 31088-20
    Fax: +49 221 31088-29

     

    More about how to buy see here

    Related Contacts
    Frank Daske

    Frank Daske

    Business Development Manager
    +49 (0) 40 28 41 12 - 30
    sales@layer2.de

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

    News

    Microsoft SharePoint Apps: Layer2 and Ividix Partnership Announced

    Layer2 announces partnership with Ividix Software Solutions to establish Ividix as a regional systems integration provider and reseller for Layer2′s SharePoint Apps.

    Layer2 Delivers Term Set Glossary App for SharePoint 2013 in Newly Launched Microsoft Office App Store

    The newly released Layer2 Term Set Glossary App for SharePoint 2013 helps employees to build a common corporate language and increases findability of SharePoint portal content.
    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 your corporate or cloud data sources bi-directional to any native SharePoint 2010 / 2013 list or library, including Microsoft Office 365.
    PDF Image

    Layer2 Office 365 Customer Case: InnoGames

    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:

     

    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.

    Sign Up for Layer2 Product Newsletter

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