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 corporate data source, codeless and bi-directional. All native SharePoint features are available for the connected lists or libraries. Please read more about available editions, plans supported, licensing and specific use cases here.

SharePoint and Office 365 Integration: What do you want to connect today?

Layer2 Cloud Connector for SharePoint and Office 365 - FAQs

​​How the Cloud Connector is licensed?
We are offering a completely free Shareware Edition that can manage up to 25 items. The full version must be licensed per server (where it is installed – not in the cloud, not per SharePoint server).
What is the Personal Edition?
The Personal Edition can manage an unlimited number of items per list, but only a single connection only. A connection could be, for example, a single database query to a single SharePoint list, or a single file system root to a SharePoint library. You can have more than one Personal Edition licensed and installed on multiple computers, if required. With the Personal Edition, one end-point of the connection must be SharePoint / Office 365 / OneDrive for Business; the other one can be whatever you want. Perpetual license, one-time fee.
What is the Professional Edition?
The Professional Edition can manage an unlimited number of items and connections per license. The license is not limited to any specific SharePoint site or database. Starting with January 2015 you can additionally directly connect almost any system to any other - without using SharePoint (formerly available as Enterprise Edition feature). For example you can directly connect and sync Microsoft Exchange data to Microsoft CRM or SQL Server. Perpetual license, one time fee. This is the type of license typically fits for most corporate requirements.

What is the Enterprise Edition?
Starting with January 2015 all Enterprise Edition features are fully included in the Professional Edition (also for the Software Assurance). The Enterprise Edition is no longer offered. Existing customers of the Professional Edition can profit from the enterprise features with a free upgrade. Contact for any questions.
What is the App Edition?
For Microsoft SharePoint Server 2013 and SharePoint 2013 Online the Cloud Connector is additionally available via the new Microsoft Office SharePoint App Store. It offers low-cost licensing (e.g. per user or scope of the app) and provides additional support to build the connection string to use with certain lists or libraries in the scope of the app. It can be ordered via the Microsoft App Store only. Please find out more about SharePoint App Store licensing here. Please also note the limitations of the app store licensing models currently offered via the store. No Software Assurance or reseller discounts can be applied. The Microsoft App Store currently is "work in progress". In case of any issues with the store, payment or license, please consult Microsoft directly. If possible issues cannot be solved with the help of the Microsoft support, we are offering upgrades to the Professional Edition with more flexible licensing for most corporate requirements.
Update 07/2014 about App Edition: Due to ongoing unsolved issues with the Microsoft Store and licensing infrastructure the app now is now available as free trial only (25 items limit) in the Microsoft Store. Please find the Personal Edition, Professional Edition or Enterprise Edition online following the links at the right hand margin of this page (shopping cart). As an existing customer of the Layer2 Cloud Connector App Edition (paid version) please contact for great discounts to upgrade to the Professional Edition. You can continue to make use of the app as a free helper feature to make it as easy as possible to create connection strings for SharePoint. Please also note: The removal of this app from the app store does not uninstall or remove the app from sites to which it has been added. It merely removes the app from the App Catalog, and users cannot add the app to other sites: Learn more here. Please contact the Microsoft support if you have issues with that.
Is there any Cloud Connector non-production license, e.g. for development or QA?
No, there is no specific license or discount for this. Please note that you can generally use the same Cloud Connector installation to connect to your SharePoint production, development and QA environment. Alternatively you can use a separate installation of the Personal Edition or Professional Edition, depending on requirements.
Which plan of SharePoint Online is required to work with the Layer2 Cloud Connector?
The connector works with ALL plans that include SharePoint Online, including OneDrive for Business, and also with all editions of SharePoint Server 2010 / 2013 on-premise, including the free SharePoint Foundation.
Do I have to re-install to upgrade from Shareware to another edition?
No, you will receive a modified license file only to place at the server to upgrade. All settings are being kept.

What is included in the annual Software Assurance (SA)?
Licence holders, who optionally acquire Software Assurance (SA) benefit from future improvements and new features of the licensed product. Software Assurance (SA) enables you to migrate your software from a lower-level software version to a higher-level version. Software Assurance (SA) makes available maintenance, updates, minor and major releases updates or upgrades. The Software Assurance (SA) is valid per 1 license (server) for 1 year from the date of product license purchase. It can be renewed after expiring. Additional services, which may be required for updating or upgrading, are not included.
Where to start to evaluate the features?
Simply setup a very first connection, e.g. a sync of Yahoo News RSS Feed to SharePoint or Office 365.

Is there a version history available?
Yes, see technical FAQs for that.

What's the difference, compared to other EAI offerings?
The Cloud Connector is highly specialized to SharePoint, on-premise and in the cloud. It is based on years of experience with integrating external data sources to SharePoint 2007 and 2010/2013 via the Layer2 Business Data List Connector. SharePoint has very special data types, lookups, user tokens, internal column names and mappings, web services and a great Client Object Model API (CSOM). There is no other EAI solution on the market, that fully supports connections to native SharePoint lists with all list features available in the cloud. One other difference is price and complexity: The Cloud Connector, especially the Professional version, is made for the mass market, definitely for small and medium enterprises. Any administrator should be able to configure a connection in just minutes - without programming or customizing on both sides, SharePoint and data source.

We would offer the connector to our clients as a reseller and / or implementer. Do you have a Partner Program?
Yes, partners receive a 15% - 30% discount on licenses in our online shop, a FREE NFR edition for internal use, partner backlinks at product pages, 2nd level support and valid leads in their regions. Please take a look here at the Partner Program details and find existing partners in your region. Please contact for more details.

Does the connector work with BPOS?
Microsoft has to finish migration of SharePoint Online and BPOS clients to 2013. After migration is completed you can use the Layer2 Connector. You don't have any changes with the migration from to 2013.
Does the connector work with other SharePoint offerings that are hosted externally by any provider?
Yes, so far they are SharePoint 2010 / 2013 based (including Foundation) - but not for 2007.
Can I use the connector for my internal SharePoint to connect external data to native SharePoint lists?
Generally yes. But there are other solutions, that potentially better support this specific scenario, e.g. the Business Data List Connector for SharePoint 2007 and 2010.
Does the connector support my specific data source?
You must have an ODBC, OLEDB, OData or .NET based driver for your data source installed. Such drivers are available for almost any data sources. You can use almost any 3rd party data providers with the tool. Additional providers are included in ditribution, e.g. for XML, Exchange, Web Services etc. If there is no driver available, you can possibly export your data to Excel or Text files (CSV/XML). This format is supported by the connector without any restrictions (uni-directional).
Can I replicate SAP data to the Office 365 cloud, SharePoint Online or any externally hosted SharePoint 2010 / 2013?
Yes, you can sync SAP data directly with SharePoint using the Layer2 OData provider, or you can use any 3rd party middleware for this. Export data to intermediate CSV-Files on a regulary base to connect to cloud could also be an option. Note that your SharePoint users do not need any SAP licenses to access the data.

Which driver versions to use: 32-bit or 64-bit?
Both versions are supported. You have to use the driver version, that fits to your operating system. If no 64-bit driver is available yet, just install the connector 32-bit version at 32-bit or 64-bit Windows.

Can I start notifications and workflows in the cloud when records in my data source are changed?
Yes. If a primary key (e.g. a customer #) is configured in settings, items in the SharePoint cloud are updated rather then deleted and re-inserted. In this case you can start workflows in the cloud, when remote LOB data records are changed or newly created. Additionally ou can use RSS or email list notifications as usual with SharePoint.

Can I write-back changes made in SharePoint in the cloud back to the data source?
Yes, but your data source driver, your query and current access rights must support write access. There are several options available to manage possible replication conflicts, e.g. winner/looser definition on field level.

Can I sync documents or files to the cloud from local server file share, home drive or local SharePoint?
Yes, you can connect SharePoint libraries to other SharePoint libraries or to a local file system as well to replicate documents, bi-drectional if required. OneDrive for Business (1TB!) sync limitations and issues (e.g. with source and destination folders) are completely solved. Optionally you can sync metadata only and link to the files, e.g. to FTP/HTTP. That could save space in case of large file shares and could be usefull especially with the limitations of low-cost Office 365 plans. You will still have all list features available, e.g. views, search, change notifications etc.
Can I use the connector to backup my files in SharePoint Online or OneDrive for Business?
Yes, you can setup an uni-directional connection from a SharePoint library to a local file system to backup your documents. Please note the file name, path, type and size restrictions of SharePoint.
What about SharePoint restrictions regarding file names, file size, file path etc.?
Possible restrictions depend on SharePoint / Office 365 version, plan and administrative settings. Please consult the vendor (MSFT) and your administrator for any specific limitation with your certain plan. There are no known limitations with the connector itself. You can use the error management included to process SharePoint limitations, e.g. stopp after n errors, ignore etc. for invalid files.
What about security while saving connection strings including user name and password?
Please enable encryption for security relevant parts of the connection string file (see checkbox near connection string) to not save the connection string as clear text. You can set access rights to the connection file as well, to improve security. Additionally you can use integrated authentication, if supported by the data provider.
Got the errror message "The number of items in this list exceeds the list view threshold, which is 5.000 items" from Office 365. How to manage large lists in SharePoint Online?
There is a list view limit of 5.000 items for some views in SharePoint Online. Please note that this is not a list item limit. The list item limit is 30.000.000 items or documents per list / library. Please use the default AllItems view (without any sorting, grouping, filtering or any further conditions) to access your list in the SharePoint UI and to connect to the list via Layer2 Cloud Connector for Office 365 in the connection string. This should work in any case. To access your data, you can define views that have a condition on the ID field, e.g. ID > 5,000 and ID < 10,000. Or you can index any specific column. One other idea is to configure a metadata-based navigation so that you can access all the list's contents based on metadata assigned (e.g. a register A to display all items with title starting with A). To enable metadata-based navigation, follow the "Enable Metadata Navigation and Filtering" and "Configure Metadata Navigation" sections of the following Microsoft website. Please note that you can always use SharePoint search as usual to access your synced data at any time above the list view threshold.
Got the error message "Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key".
Your table needs a primary key defined to enable dynamic SQL generation. You can use any unique column (e.g. a customer number), a counter or GUID. The primary key must be included in query. It must not be included in SharePoint (but it could be for better understanding what happens in case of sync).
Got the error message: "The provider 'System.Data.SqlClient' marked the row '1' as erroneous: Dynamic SQL generation is not supported against multiple base tables." Where to go next?
The message describes a limitation of your data provider 'System.Data.SqlClient' that is not able to update the specific type of query you have connected (e.g. join). It is not related to the Cloud Connector. It would occur in the same way, if you would query a local SQL server with this query and try to update. To overcome the issue you have to simplify your query in a way that it becomes updatable.
To overcome the issue a typical approach for SharePoint is to connect several simple tables with several lists and lookup between, to simulate table relationships via foreign keys. You can, e.g. establish the lookups using SharePoint workflows, based on the foreign keys. An approach for SQL is to implement the business logic (e.g. modify several tables at once) using SQL triggers and stored procedures.
The Cloud Connector cannot reach my SharePoint Online / Office 365 site via proxy / firewall. Do we need specific setttings?
Please take a look here for Office 365 URLs and IP adress ranges. In case other data sources are connected, check requirements as well. The Cloud Connector itself does not have any specific requirements regarding firewall settings.
Got the error message „Sorry something went wrong“ while placing the App Edition on my SharePoint page.
Please check the language / culture of your site and of the app. It must be exactly the same. English (Canada)‚ English (United Kingdom) and English (United States) is definitely not the same and ends in this error. See here for more about this known SharePoint issue.
Whats an appropriate scheduling interval for sync?
An appropriate scheduling interval depends on amount of data, amount of changes, configuration, bandwidth etc. It makes no sense to enter an interval, shorter as the time typically needed for sync. You will have instant sync in this case. Please start with one hour (as advised), take a look at duration and decrease if possible. Take care that changes are synced only. If this is not the case (means all items are updated with each sync), please check for possible mapping or data conversion issues. Please consult our support if you need help.
How to sync on demand instead of on schedule?
You can execute a single connection as a command line in case of any specific event that requires a sync:
Layer2.Data.Synchronization.Service.exe -execute MyConnection
You can also embedd the command line into any command batch to do other steps, like e.g. replacing some CSV file, rewrite a connection file etc. Please do not use copy / paste of the command line from here because of special chars. Enter command line manually in case of any issues.
How to setup the background update to sync automatically?
Please make sure that your Layer2 Cloud Connector Windows Service is running. You can verify this at the root node of the Layer2 Cloud Connector Connection Manager. In case the Backend Serice State is "Stopped" please start using the Action Menu (right hand side). Also make sure that in your specific connection scheduling is enabled and interval / next run has appropiate values (see connection settings).
How to add specific business logic to my synchronization?
You can add logic on both sides, SharePoint and the external source. For example complex fields in Sharepoint like lookups, person or group picker, managed metadata etc. can require further processing. Here is how it works.
Cloud Connector reports wrong number of files for sync. Why?
The Cloud Connector does not count or sync any hidden or system files. Windows Explorer can count hidden or sytem files as well, depending on settings. The Cloud Connector always reports the numer of visible files for sync.
Where I can find more technical information and samples?
You can find more information here in FAQs.
Share this site on Xing
Share this site on Google+
Share this site on LinkedIn

This tool fills an open gap with SharePoint integrating external data sources. I've tried - Oracle, MS SQL, and others. And it's really fast! A must-have for any SharePoint implementation, whether standalone or Office 365. You can't live without.


 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.