Microsoft SharePoint On-Premises Connections

Learn how to create a connection to Microsoft SharePoint On-Premises.


Overview

DryvIQ connections to SharePoint 2013, 2016, and 2019 on-premise platforms can be made by using any valid SharePoint user account with applicable permissions to access content. There are several ways to transfer content; this document outlines each of those situations and how to configure them.

Microsoft SharePoint Supported Versions

  • 2013
  • 2016
  • 2019
 

 

Creating a Connection

  1. Expand the Manage section in the left navigation menu.
  2. Click Connections.
  3. Click Add connection.
  4. Select Microsoft SharePoint as the platform on the Add connection modal.
  5. Enter the connection information. Reference the table below for details about each field.
  6. Click Test connection to ensure DryvIQ can connect using the information entered.
  7. You will see a green "Connected” message at the bottom of the modal when DryvIQ establishes a connection. (If the connection fails, verify the information you entered.)
  8. Click Done.
Add Connection Modal for Microsoft SharePoint On-Premises

 

Field Description Required
Display as

Enter the display name for the connection. If you will be creating multiple connections, ensure the name readily identifies the connection. The name displays in the application, and you can use it to search for the connection and filter lists.

Optional
 
Url Enter the URL for SharePoint, including the site collection where the target document library exists. Required
User name Enter the SharePoint username. It can coincide with the Active Directory Universal Principal Name (UPN). Required
Password Enter the password for the username added in the previous field. Required
Sso provider Only Active Directory Federation Services (ADFS) is supported as an SSO provider for SharePoint at this time.  Optional
Sso url Enter the URL of the configured SSO provider. Optional
Authentication type

Select the authentication method the server uses: Basic, Forms, or NTLM. 

 

You can select the Detect automatically option to have DryvIQ automatically detect the authentication type when testing the connection. This is the default selection. 

Optional
Behavior When Deleting Items

Select the type of deletion DryvIQ should perform when deleting items: Permanent or Soft.

 

Soft delete is the default behavior. A soft delete marks items as deleted. You can still access them to restore or permanently delete the items.

 

Permanent delete is the recommended behavior. A permanent delete removes the items. This deletion is not reversible.

Optional

Features and Limitations

Platforms all have unique features and limitations. DryvIQ’s transfer engine manages these differences between platforms, allowing you to configure actions based on Job Policies and Behaviors. The information below is platform-specific. Use the Platform Comparison‍ tool to see how your integration platforms may interact regarding features and limitations. For more information on SharePoint restrictions, see Microsoft’s official documentation.

Supported Features Unsupported Features
Account Map‍  Mirror Lock Ownership‍ 
Author/Owner Preservation‍   
File Lock Propagation‍   
Group Map‍   
Metadata Map‍   
Permission Preservation‍   
Timestamp Preservation‍   
Tags Map‍   
User Impersonation‍   
Version Preservation‍   

Other Features and Limitations per Version

Features and limitations may vary between SharePoint versions. Refer to Microsoft's official documentation for your specific version of SharePoint for a complete list of supported features and limitations. 

Features/Limitations SharePoint 2013 SharePoint 2016 SharePoint 2019
File Size Maximum‍  2 GB 2 GB 15 GB
Path Length Maximum‍  260 260 400
Segment Path Length‍  128 128 206
Invalid Characters‍  | # { } % & \ ~ + / : * ? < > \\ “ | # % \ \\ / : * ? < > “ | \ \\ / : * ? < >  "
Restrictions
  • Consecutive periods
  • Leading tildes
  • Leading periods
  • Trailing periods before extension
  • Trailing periods after extension
  • Leading whitespace
  • Trailing whitespace before extension
  • Trailing whitespace after extension
  • Non-printable
  • Leading tildes without an extension
  • Trailing periods after extension
  • Leading whitespace
  • Trailing whitespace after extension
  • Non-printable
  • Trailing periods after extension
  • Leading whitespace
  • Trailing whitespace after extension
  • Non-printable

 

Check Out

DryvIQ does not support libraries that require files to be checked out.  

Date Preservation

Date preservation works with SharePoint if you are using author preservation.

Enterprise Keywords

SharePoint doesn't allow duplicate Enterprise Keywords. The longest permitted string in an Enterprise Keyword is 255 characters. 

File Extensions

SharePoint restricts specific file extensions in different versions. Click here for the complete list.

Invalid Characters and Spaces

DryvIQ verifies file and folder names to identify unsupported characters based on the platform. It then replaces invalid characters with an underscore (_) so the files and folders can be transferred. 

The logic includes leading and trailing spaces in file and folder names. DryvIQ replaces the space rather than trimming it because trimming the space could cause duplicate file names. Adding the underscore ensures the name remains unique.

Okta

DryvIQ does not support Okta with SharePoint.

Restricted File/Folder Names

The following are restricted file and folder names:

  • _vti_test
  • _w
  • _t

The following are restricted folder names:

  • Test_files

Folder names cannot end with the following:

  • .files
  • _files
  • _Dateien
  • _fichiers
  • _bestanden
  • _file
  • _archivos
  • _filer
  • _tiedostot
  • _pliki
  • _soubory
  • _elemei
  • _ficheiros
  • _arquivos
  • _dosyalar
  • _datoteke
  • _fitxers
  • _failid
  • _fails
  • _bylos
  • _fajlovi
  • _fitxategiak

URLs

The transformation of URLs into SharePoint can sometimes increase the overall URL length, which can cause either 400 or 414 URL failures. (Spaces are the primary way this can happen.) DryvIQ recommends removing spaces or shortening the URL length to resolve this error.

Versioning

DryvIq supports versioning if versioning is enabled on the library. 

SharePoint 2019 supports version deletes.