Office 365 SharePoint Integration and Synchronization

Office 365SharePoint, and OneDrive for Business can be integrated and synchronized codelessly with various other data sources using the Layer2 Cloud Connector via the Layer2 Data Provider for SharePoint (CSOM), bi-directionally if required. While structured data like database queries can be synchronized with native SharePoint lists, unstructured data - for example a file share - can be synchronized with SharePoint libraries. Please take a look here for supported systems and applications.​​​

 

Layer2 Cloud Connector Version 6

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:

SharePoint-O365-Integration-Synchronization

​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=http://mydomain.com/mySite; 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. Larger files will be rejected.
  • For other SharePoint restrictions, see Software Boundaries and Limits for SharePoint 2013 and Blocked File Types.
  • Microsoft is about to increase the length of the url path in SharePoint Online and OneDrive for Business to 400 characters: https://support.office.com/en-us/article/Invalid-characters-in-file-or-folder-names-or-invalid-file-types-in-OneDrive-for-Business-64883A5D-228E-48F5-B3D2-EB39E07630FA. That will fix some possible synchronization issues on the SharePoint side, as this limit was lower than the maximum Windows file path length before.
  • 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.
  • 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.

FIND RELATED SOLUTIONS HERE.

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

Ready to go next steps?

Register for free download.

No credit card required. Register, download and try as long as you want. It's all free.

Questions? Contact us.

We are here to help. Contact us and our consulting will be happy to answer your questions.