Office 365 SharePoint Integration and Synchronization

You can integrate and synchronize without any coding Office 365, SharePoint, and OneDrive for Business with various other data sources using the Layer2 Cloud Connector via the Layer2 Data Provider for SharePoint (CSOM). Also in both directions. Synchronize structured data like database queries with native SharePoint lists, and unstructured data - for example a file share - with SharePoint libraries.


Office 365 Specific Integration Settings

To connect to SharePoint lists and libraries the data source or destination entity must be configured as follows in the Layer2 Cloud Connector Connection Manager:


​Please note the following specific settings.


  • Select the Layer2 Data Provider for SharePoint (CSOM) to connect. The provider is part of the Layer2 Cloud Connector ADO.NET provider package and should be already installed. You will find a SharePoint Data Provider specification here.
  • You can use a connection string like this to connect:
    url=; List=MyList; View=MyView; User=myUser; Password=myPassword; Authentication=myAuthentication;
  • Chosing the right authentication method is very important. Windows, Office365, ADFS and others are supported. See specification linked above for more details.
  • Data queries are not supported. Please make use of views to select your data.
  • In case of SharePoint libraries, files are synchronized as well as metadata. List are for metadata only, attachments are not supported at this time.
  • You can map your data fields to specific external fields in the Layer2 Cloud Connector. Please take care about data types (simple type conversions are supported). If fields are not available, please check your view.
  • The primary key will be set automatically to the SharePoint item ID.
  • You can use the connection for uni- or bi-directional synchronization. In case of inserts (full CRUD) via external systems please take care of the primary key.
  • No installation or changes are required at the data source or data destination, e.g. on SharePoint or Office 365.
  • Data synchronization can be started manually in the Connection Manager, per command line or scheduled in background by the Layer2 Cloud Connector Windows Service. Only data changes are processed (no delete / bulk import).
  • No programming required for setup a connection and sync.
  • No need to open your local network for access from outside.

SharePoint Integration - Known Issues and Workarounds

  • Microsoft SharePoint Server 2007 and earlier is not supported.
  • Synchronization to or from a SharePoint Asset Library is not supported.
  • SharePoint list attachments are not managed at this time and are not supported.
  • SharePoint Online/ Office 365 supports files up to 2GB (via CSOM). Larger files will be rejected. Choose the Layer Fast File Sync Provider for up to 10GB files.
  • For other SharePoint restrictions, see Software Boundaries and Limits for SharePoint 2013 and Blocked File Types.
  • While this will fix some issues on the SharePoint side, it could possibly cause new issues on the Windows side of a file sync due to lower path length limitations there.
    Microsoft is about to increase the length of the url path in SharePoint Online and OneDrive for Business to 400 characters: That will fix some possible synchronization issues on the SharePoint side, as this limit was lower than the maximum Windows file path length before.
  • Editor, Author, Created, Modified, ContentType, and HtmlFileType field can only be written to by a site administrator. If you get errors that these fields are read only and the account being used is a site administrator, it may be due to a known SharePoint issue where it denies acess if "AddAndCustomizePages" is set to Deny for the user. To fix this you must explicitly give "AddAndCustomizePage" permissions to the account. For more information, see this article.


Learn more about similar solutions for data migration, backup, integration, and synchronization by vendor and topic.

Get a free trial version here!

Icon for Product Regsitration - Layer2 leading solutions

Layer2 Cloud Connector free trial

Keep your systems always in sync with the Layer2 Cloud Connector.

Contact Us Icon for Layer2 leading solutions


Write us an email with your inquiry, and we will be happy to help.