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 or database 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 [email protected] for any questions.
What is the App Edition?
For Microsoft SharePoint Server 2013 and SharePoint Online the Layer2 Cloud Connector is additionally available via the Microsoft SharePoint App Store. The free app provides additional support to build the connection string to use with certain lists or libraries in the scope of the app. It is available via the Microsoft App Store only. Note that the Layer2 Cloud Connector (local components) are additionally required for synchronization. It can be used for free (25 items limit) or licensed (no limits).
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? What about change log?
Yes, see Release Notes 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 [email protected] 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 useful 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. The file name, path, type and size restrictions of SharePoint are managed by the Cloud Connector automatically.
What about SharePoint restrictions regarding file names, file size, file path etc.?
Possible restrictions depend on SharePoint / Office 365 version, plan and administrative settings. The Cloud Connector managed these restrictions automatically, e.g. by using different file names on source and destination, shorted file paths, zipping file types that are not allowed etc.
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. But anyway it is a good idea to limit the number of items in a folder below 5.000 for better browsing directories. The Cloud Connector can help you with warnings in this case.
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 address 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. A typical schedule for file sync is 15 to 30 minutes.
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 execute several different connections in any specific order?
You can use a batch of command lines as noted above. 
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 appropriate 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 system files as well, depending on user settings. The Cloud Connector always reports the numer of visible files for sync.
How to abort a running synchronization?
You can click "Abort" in the Connection Manager or simply close the Connection Manager. In case of background sync you can stop the service. In any case the synchronization is stopped and can be continued later on.
Where I can find more technical information and samples?
You can find more information here in FAQs or in the solutions section.
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 [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.

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