OneDrive Synchronization FAQ

Microsoft OneDrive for Business can be connected and synchronized without code and bi-directionally with any local file shares, home drives, etc., using the Layer2 Cloud Connector with very flexible sync options. No issues with syncing more than 5.000 items per library. Database content can be synced as well. See below for a step-by-step intro.

How to sync OneDrive for Business with local file shares, home drives, or other corporate data?

​OneDrive for Business is a new Microsoft cloud offering with 1TB space for any user for the best price available in the cloud market today.

OneDrive-for-Business-Offering-Layer2.PNG 
Fig.: OneDrive for Business as offered by Microsoft starting July 2014.
 
But it's not only about storage. Users also have available almost all the features of a SharePoint MySite - without the costs and the administrative complexity of SharePoint Online.
 
OneDrive-for-Business-Features-Layer2.png 
 

Fig. Microsoft OneDrive for Business features compared to OneDrive for private usage.

Microsoft OneDrive for Business by default comes with a limited sync feature to keep personal files offline, such as on the user's tablet or mobile device. But how to sync corporate data like file shares, home drives, database content, etc., with OneDrive for Business to share in the cloud and access from anywhere on any device?

Prepare Your File System Source to Integrate with OneDrive for Business

For the best initial synchronization experience with the Layer2 Cloud Connector, we recommend you make sure your file system is clean and free of any of the issues/restrictions known for OneDrive for Business. Restricted file names, characters, and other issues are listed here, and this Office Support article also contains a link to Microsoft's free "Easy Fix" tool, meant for fixing your files before you upload them to OneDrive/SharePoint Online.
 
Note that the 5000 Item view limit and the 20000 total limit listed in the Office Support article does not apply to Cloud Connector, only the OneDrive synchronization tool.

Set Up Your File System to OneDrive Connection

This walk-through will be setting up a uni-directional sync from the specified file share location to OneDrive for Business. It can be changed to bi-directional later, if you want to sync contents in both locations to each other. It is also a good idea to wait before enabling scheduling; this can be done after you confirm the connection is working normally with manual synchronizations.

Start with opening the Layer2 Cloud Connector Connection Manager and click "Create New Connection". You can also duplicate an existing example connection as a starting place.

OD4B-Layer2-Connection-Setup.PNG

Fig. Example Layer2 Cloud Connector connection settings in the Connection Manager.

Please note that if there is content already in the OneDrive for Business Documents library, that you will need to enable Overwrite Destination (for initial syncs) in the connection settings.

 

Next step is to configure the Source data entity, which will be the file system location you want to pull files from.
OD4B-Layer2-File-Share.PNG
Fig. Example file system location on the C:\ drive.

 

In the left-hand column, expand the Data Entities node to see the Source and Target nodes. Select the Source node, which is the top one.  Fill out the settings for a file system connection.

  • Data Entity Title: Give your entity a meaningful name
  • Entity Type: Should default to "Source"
  • Data Provider: In the drop-down, select "Layer2 Data Provider for File System"
  • Connection String: Directory=<pathToYourContent>;
    In this example, it will be Directory=C:\Test_Documents;
  • The rest will be left blank/unset for now

Note that you can use other notations for the directory, such as '\\myserver\myshare' or '\\127.0.0.1\C$\Test2'. By default, Integrated Authentication is used to access the file location. You can also give an account to use with the notation:
User=MyDomain\myUser; Password=myPassword;

Verify the connection works by clicking the Verify Connection String blue link, as well as clicking Preview Data in the right-hand menu to see the first 10 objects in the location given.

OD4B-Layer2-File-Source-Setup.PNG

Fig. Example configuration for the file system source.

Next comes the Target configuration to your OneDrive for Business' default Document library. First you need to gather the proper URL to use for the connection string. In a browser, navigate to your OneDrive for Business location. It should be in the new UI style. Click on "Return to classic OneDrive" in the lower left-hand corner.

 

Fig. Finding the link to go back to the 'Classic UI' in OneDrive. 

 

When the older UI reloads, the URL now in the browser address bar is the correct one to use with the Cloud Connector. It should look something like this:
https://company-my.sharepoint.com/personal/myAccount/Documents/Forms/All.aspx

 

Copy that URL to use for the next part. (If you are using a non-default location and need help getting the URL to use, see the "Getting the Correct URL for OneDrive Locations" section of the OneDrive solution page.)

Select the Target node, which is the second one. Fill out the settings for a OneDrive connection, which is actually just a type of SharePoint Online connection.

  • Data Entity Title: Give your entity a meaningful name
  • Entity Type: Should default to "Destination"
  • Data Provider: In the drop-down, select "Layer2 Data Provider for SharePoint (CSOM)"
  • Connection String: url=http://mydomain.com/mySite/myLibrary/Forms/All.aspx; Authentication=Office365; [email protected]; Password=myPassword;
  • The URL=; parameter will be the URL you copied above from the browser.
  • The rest will be left blank/unset for now

Verify the connection works by clicking the Verify Connection String blue link, as well as clicking Preview Data in the right-hand menu to see the first 10 objects in the location given.

 

OD4B-Layer2-OneDrive-Setup.PNG

 

Fig. Example configuration for the OneDrive for Business default Document library.

 

Lastly, comes setting the column mapping. Select the Mappings node from the left-hand column. It should default to have Auto Mapping enabled, which is fine for most file syncs.

 

OD4B-Layer2-Mapping.PNG

 

Fig. Example mapping with Auto Mapping enabled.

 

Configuration is now complete and you can run the initial file synchronization. Click on the main connection node (with the green plug) in the left-hand column to select the connection settings. At the bottom is a Run Now button. Press that to start the sync!

If the sync finishes with errors, check the Logs node for more details. You can increase the log level in the Connection Manager root and run again to receive more detailed information. In most cases, issues are related to known SharePoint limitations regarding file names, sizes and types allowed, path lengths allowed, etc. If you took the recommended steps above to clean your file system first, most issues will be avoided.

 

OD4B-Layer2-First-Sync.PNG
 

 

Fig. Example output from a successful initial sync to OneDrive for Business.

 

Manage Your Files in the OneDrive Document Library

​Now take a look at your OneDrive location. You should see all the files there from the file system.

OD4B-Layer2-Synced-Documents.PNG

Fig. Example of OneDrive library now populated with files from the synchronization.

If you are satisfied with the results, you can enable scheduling in the Connection Manager. It can be set to run every hour, every 10 minutes, or even shorter, depending on your needs.

Please note:
  • All options of OneDrive for Business are fully available, such as file search, versioning, change notifications via RSS or email, workflows etc. You can access your files from any device and location.
  • Files can be updated in background automatically by the Cloud Connector, with it only processing changes to the content. Please check your Connection Manager root for this. You can enable and disable the Layer2 Cloud Connector Windows Service there.
  • Bi-directional connections are supported as well.
  • Cloud Connector has no issues with the 5.000 items list view threshold. Some view options will become unavailable in this case. But you can still use your library with unsorted, ungrouped and unfiltered views or make use of indexed columns or managed metadata navigation. Search can be used without restriction to find files. However, take care to prepare your views before reaching the threshold as you may not be able to adjust them once you reach the limit. Alternatively, you can sync to several different libraries to keep things below the threshold.
  • You can add additional unmapped columns for use only in OneDrive, e.g. managed metadata or feedback columns. Unmapped columns are kept as-is during updates.
  • You can update specific columns with other connections, such as with database content.
  • Folders are fully supported. You can even sync to specific folders of an already existing library.
  • You can filter the data source file share for specific criteria, e.g. file types.
  • You can add additional sync options like "no insert", "no update", "no delete" for specific requirements. Check the Advanced Settings section at the bottom of the data entities to access these.
  • You can sync using the scheduling service, as well as on-demand (with command line).
  • In this walk-through Auto Mapping is used, but you can also map specific columns with certain file metadata manually, if required.

Next steps: Download a FREE shareware edition of the Layer2 Cloud Connector

​​You want to do more? Just ask [email protected] for any specifc scenarios or licensing options. You can start with the free Shareware Edition after registration.
Share this site on Xing
Share this site on Google+
Share this site on LinkedIn

We use the Layer2 connector to synchronize multiple database tables to SharePoint back and forth and from the get go it worked flawlessly. The questions that arose during our evaluation of the tool were always answers swiftly and correctly.

 

 Download & Evaluation

 
Please register now to receive your free personal download link via email to your valid company email address.
Name: 
Company: 
Country: 
Phone: 
E-mail: 
Yes, I accept the licensing terms and conditions
Contact
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.

 

cs-award-top-100-publisher-2014-15-large.gif

Sign Up for Layer2 Product Newsletter

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