NFC Vault

Do you know about these SharePoint Online limitations?

5,000 item - Having a large number of objects in a document library degrades performance to the point where it becomes unusable.
300,000 item - This limits the number of documents users can sync using OneDrive sync client. Performance starts to degrade.
400 Character URL Limit - The URL path for all files and folders can be no more than 400 characters (and no more than 400 characters for a single file or folder name in the URL).

Story #1 - Engineering firm experimenting with SharePoint

An architectural firm in Copenhagen, Denmark, has 3 locations at Denmark and Norway. The file server is currently on site with 7TB of data, but they want to get rid of the file server. There are no official communication channels between the 3 sites, so using a cloud solution to unify the 3 sites makes sense.

They experimented with SharePoint and OneDrive. At first it was good because the integration of OneDrive Windows Explorer makes it easy to access files and folders from SharePoint. Later, however, they ran into problems with the AutoCAD application. One problem is related to file locking, the other to external references within a single file. This is not a SharePoint/OneDrive issue, but rather an application compatibility issue between the CAD and SharePoint applications.

SharePoint storage costs are another issue. If they had put all 7 TB of storage on SharePoint, it would have cost about $1400/month. The company wants less frequently used files to be stored in another system. They want a storage platform/solution that solves the file locking and external referencing problem while providing a way to use lower cost storage services like Amazon S3 and Azure Blob Storage.

Story #3 - Migrate local NAS to SharePoint

An MSP is helping a local customer migrate a local NAS to SharePoint and runs into SharePoint limitations 1. The company was trying to migrate more than 700,000 files from a Synology NAS to SharePoint Online to leverage its Office 365 subscription.

2. The dataset contained very long paths and file names, which prevented some files from migrating.

3. The OneDrive sync client was installed on over 50 laptops.

4. The sync brings their network down for hours at a time.

5. Microsoft pointed out that OneDrive sync performance degrades when there are more than 100,000 items and advised the company to create multiple sites, each with fewer than 100,000 items.

6. The company decided that the cost of restructuring and the uncertainty were too high, and began looking for alternatives that could work with their data.

"Do you want to divide and reorganize the original repository of 700,000 individual files into seven different SharePoint libraries? What about the cost of retraining staff to get used to the new SharePoint online locations?"

SharePoint Online Limitations You Should Know

1 Objects Synchronization and Library Limits

"Although SharePoint Online can store 30 million documents per library, we recommend synchronizing no more than 300,000 files across all document libraries for optimal performance..."

From experience, performance starts to drop after 100,000 items. Whether it's 300,000 or 100,000, in many real-world enterprise environments with more files, the OneDrive sync client has serious performance issues, forcing users to switch to the Web interface.

Compared to the OneDrive sync limitation, the 5,000 view item limit in a library is even stricter. The moment you exceed 5,000 items in a library, it becomes almost unusable.

2 Maximum Name Length Limitations

"The specified file or folder name is too long. The URL path for all files and folders must be 400 characters or less..."

This limit is a common problem when migrating file shares to SharePoint Online. The migration fails for any files that don't meet this requirement. Since this is the upper limit for the relative URL containing the entire path and name of the document library, this happens frequently, resulting in incomplete migrations.

An even more stringent limit is the 256-character limit on Windows PCs when users sync SharePoint Online libraries. Users encounter error messages like: "The file name(s) would be too long for the destination folder."

3 Prohibitive Costs of Data Reorganization

"A list can have up to 30 million items... When a list, library, or folder contains more than 100,000 items, you can't break permissions inheritance..."

Reorganizing permissions becomes a major headache with large datasets. While SharePoint supports removing permissions inheritance, this only works for relatively small data sets. With over 100,000 items, you can't break permissions inheritance on the container, though you can on individual items. This turns permissions management into a data reorganization nightmare to avoid manually overriding inheritance for thousands of items.

How to Overcome SharePoint's Limitations

Alternative solutions for migrating file servers to the cloud

If the SharePoint limitations are holding you back from migrating file servers to Cloud, there is a better way!

Alternative Solution #1 - Lift and Shift

Lift-and-Shift is a migration strategy that creates another set of virtual machines in Azure, AWS, or a regional co-location data center and moves the data on the on-premises file server to the virtual machines in the data centers. Once the data migration is complete, the DNS name for the file server can be quickly switched from the on-premises file server to the file server in the cloud.

In this type of procedure, lift-and-shift is also known as rehosting. It is a relatively fast and cost-effective way to migrate data from on-premises to the cloud, and the best part is that it is backward compatible after DNS redirection.

Alternative Solution #2 - Hybrid Cloud and Local File Server

Lift-and-shift is easier when the Internet in the office is fast. Therefore, a site-to-site VPN between the office firewall and the cloud virtual network acts like part of the local network.

The hybrid cloud file server is a good balance between the local file server and the cloud file server, so employees in the local office can still use the file server over a local network.

Mapped Drive

A mapped drive over the HTTPS channel to the corporate file server is an important feature. Employees are familiar with a mapped drive and no additional training is required.

File Locking

Most file sharing solutions provide manual file locking in the form of "check in" and "check out". NFC Vault provides automatic file locking by detecting requests to open files. When Microsoft Word opens a file, file locking is automatically initiated and automatically terminated when file processing is complete.

Active Directory

Enterprise users already have enterprise identities in Active Directory and the associated Active Directory federated service and SAML single sign-on. They do not need additional credentials to access a file sharing solution.

File Permissions

Finally, integration with Active Directory and NTFS permissions makes it easier for system administrators to set up permission control. The permissions features set Gladinet's solution apart from the competition.

How to Overcome SharePoint Limitations

File Server AS-IS

We add a cloud layer to your existing file server to enable HTTPS access for Active Directory and SMB/CIFS protocols. Your file server has no such restriction as SharePoint's limitations, maintaining full functionality while adding cloud accessibility.

Cloud Storage Services

We leverage highly scalable cloud storage services like Amazon S3 and Windows Azure blob storage. These services are designed for global scalability without the artificial limitations of SharePoint, providing virtually unlimited storage capacity and performance.

Avoid Full Synchronization

100% file synchronization is problematic for enterprise data. The massive data footprint creates inefficiency, and maintaining complete local copies significantly increases security risks by expanding the attack surface. Our on-demand synchronization approach provides better security and efficiency for business use cases.

Here are the features that will help employees get up and running quickly.

Cloud Drive Mapping

Drive mapping is an important feature for online file access. End users can easily drag and drop files and folders from a mapped drive over the Internet. Drive mapping also helps manage external file references.

Global File Locking

File locking is an important feature for online file access and team collaboration to avoid conflicts. End users need to control global concurrent online file access by using file locking to maintain consistency.

Seamless Transition

From Active Directory identities to NTFS file permissions and folder protection, all the things an employee is familiar with remain as if nothing has changed. Similar and consistent user interface approach minimizes the user learning curve.

Productivity

Make it easier for your teams to collaborate with customers successfully:

Outlook Integration

Instead of sending files as Outlook attachments, files and folders can be shared as links via Outlook.

Share Files and Folders

Files and folders can be turned into websites and accessed from web browsers or any mobile client.

Advanced Sharing

Policies such as expiration dates and read/write permissions can be attached to file sharing.

Send Large Files

Enhance large file transfers' performance by only sending the changes that were made instead of synchronizing the entire file.

Receive Files and Folders

Weblinks can be generated for web browser-based upload to receive files and folders.

Desktop Integration

File-sharing can be as easy as right-click on a file from within Windows Explorer.

Security

Secure Data Room

Shared folders have optional secure data room features to enable view-only permissions that disable downloads.

Domain Control

The destination email domain is one of the white list parameters that control who can receive file-sharing invitations.

Granular Folder

Define different permissions for folders at different levels of the directory structure.

IP Address Control

The destination IP Address is another parameter to control who can be the receiver for a file-sharing action.

Do you want to make these features available to your remote workers?

Offline Editing

A traditional VPN requires a stable and active connection to the corporate firewall to function. A disruption in the Internet or an interrupted connection to the firewall interrupts employees' work with unsaved files. With offline editing, remote workers can save and edit documents without an active connection and save the files asynchronously to a corporate file server once the connection is restored.

Always On

A firewall vendor typically offers VPN without an always-on feature. Always-on VPN requires more infrastructure components such as identity servers, authentication servers, compatible clients OS, etc. However, most modern cloud applications are always-on, allowing offline access to files and folders and storing files on a local device before synchronizing them with online servers.

High Performance

Accessing file servers is hardly high-performance, because when a VPN serves as an enabler, file access is done via the SMB/CIFS protocol. First of all, the SMB protocol is not a data streaming protocol with many requests and responses. If we can switch to HTTP streaming for file transfer, performance will improve. Second, HTTP-based file transfer traffic can take advantage of a global content delivery network, so HTTP is faster for cross-continent transfer.

NFC Vault : How to Overcome SharePoint Online Limitations?