​The Cloud Connector for Microsoft Office 365 and SharePoint connects almost any on-premise 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, SAP and many more directly to native SharePoint lists and libraries in the Microsoft Cloud - or any other Microsoft SharePoint on-premise installation - in just minutes without any programming. For any questions please use the FAQ Web Form or contact [email protected] directly.

SharePoint 2013 / Office 365 Preview and Layer2 Cloud Connector

​SharePoint 2013 and the new Office 365 Preview have a lot of new options to connect to external data sources. Why the Layer2 Cloud Connector for Office 365 and SharePoint on-premise is still the most efficient, easy and secure way to connect?

Key changes in SP15 for BCS

These are the key changes and improvements with external data integration for SharePoint 2013: 

  • OData Support as data source: oData is an important protocol for services that was not previously supported by BCS. BCS can now access oData sources OOB just like WCF or SQL data sources.
    Visual Studio comes with support for automatically generating BDC Metadata Models from an oData source. OData is also supported in SharePoint Designer. OData can be used to access for example SharePoint 2010, SQL Azure, Azure Data MarketPlace and SQL Server Reporting Services.
  • Eventing Framework for external notifications: BCS provides alert capability for external lists as well as support for SharePoint Apps. BCS models are now scoped for app level, not to farm level. The framework needs programming and corresponding web services.
  • External list enhancements: Performance improvements, Data Source Filtering, Sorting, Export to Excel, CSOM API.

BCS now allows writing complex data management applications that can act bi-directional, based on custom programming using external event receivers, apps (e.g. Azure hosted) and web services.

Why using the Cloud Connector with the SharePoint 2013 and Office 365 Preview

​The Cloud Connector perfectly works with SharePoint 2013 because it was built on the Microsoft CSOM API from the beginning. Why using it with SharePoint 2013 / 2016?

  • External data is not only displayed, but fully integrated as list or library. BCS displays data only by default.
  • All features of native lists and libraries are completely available, no restrictions: Personalized views, search, lookups, out-of-the-box workflows, notifications, attachments, social features e.g. Like It or rating, metadata like terms and tags, etc.
  • No programming required: BCS requires modeling and / or programming on SharePoint side to connect.
  • No customizing required. Not on data source side, not on SharePoint side.
  • Setup of connections in just minutes: You can use a simple Connection Manager or Connection Wizard with a few configuration fields only, no Visual Studio or SharePoint Designer.
  • Virtually any on-premise data source supported: SQL databases like SQL Server, Oracle, DB2, Informix, AS/400, MySQL, file shares, ERP / CRM / ECMS or other legacy platforms and on-premise applications like Dynamics, SharePoint, Active Directory, SAP etc.
  • Many cloud or web-based data sources are supported via XML or 3rd party providers (e.g. SalesForce, Google, Facebook, Twitter).
  • Additional providers included out-of-the-box: OData, CSOM, RSS, XML (via XPath query) etc.
  • Simple architecture - Highest performance: End users are working with native SharePoint lists and libraries as some kind of high performance cache for the external data. No connection to corporate data is required for usage, only for replication (e.g. one a hour or daily).
  • Highest Security - No access to corporate network required from outside: The connector runs safely within the corporate network as a windows service to push and pull data as required using CSOM web services (SSL encoded via HTTPS).
  • Highest compliance - No data is transferred to any 3rd party or vendor: No external app - e.g. somewhere in Azure or externally hosted - required to sync your data.

The Cloud Connector can be used to setup a connection between your existing Applications and your SharePoint 2013 evaluation in just minutes. You can replicate existing data to more efficiently evaluate the SharePoint 2013 features.

Cloud Connector - Sample Data Source

Fig.: SQL Table as sample data source to connect to SharePoint 2013. Please note, that you can connect bi-directional as well without any programming and access to corporate network from outside.

Cloud Connector - Sample Data Destination

Fig.: Native SharePoint 2013 / Office 365 Preview list as a sample data destination connected via Cloud Connector. Please note, that you can connect bi-directional as well without any programming and access to corporate network from outside.

Next Steps: Free registration and download

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

"The Cloud Connector is built on the Microsoft CSOM API, means it works in the same way for SharePoint 2010 and 2013, on-premise or online in the cloud"

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.



Sign Up for Layer2 Product Newsletter

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