SFTP/FTP for Microsoft Office 365 SharePoint and OneDrive

SFTP (or FTP) is not supported by the Microsoft suite (SharePoint and OneDrive) natively. Incredibly, even though SFTP (FTP) is such a legacy protocol, it is still widely used and required in this modern day. SFTP is primarily for file sharing between organisations, but also for workflow automation and backups.

To summarise this article, the steps to configure SFTP/FTP for O365 SharePoint and OneDrive are:

  • Create a Couchdrop account
  • Connect your SharePoint or OneDrive and specify the root directory
  • Create additional users with granular permissions and directory access
  • SFTP/FTP using the credentials created via sftp.couchdrop.io or ftp.couchdrop.io
SFTP/FTP for Microsoft Office 365 SharePoint and OneDrive
Couchdrop — virtual file system fabric for cloud storage

There aren’t many products out there that enable you to turn your OneDrive or SharePoint into an SFTP/FTP server where external users can send and receive data. One solution to this is Couchdrop. Couchdrop is the only SFTP/FTP server that integrates with all the major cloud storage providers by default, enabling you to turn them into your SFTP endpoint. Other features include granular security and permissions, the ability to restrict users to specific folders, a branded portal which can be used as a file system and a fully featured API (and webhooks) that you can use to automate and into build workflows.

SFTP/FTP for Microsoft Office 365 SharePoint and OneDrive
An example of a branded Couchdrop portal

To configure your Microsoft storage as an SFTP/FTP server takes less than a minute. As mentioned earlier, all you need to do is create an account and connect your storage using OAuth. Follow below on a more detailed guide.

Create an account

Navigate to Couchdrop to register

SFTP/FTP for Microsoft Office 365 SharePoint and OneDrive
Create a Couchdrop account

Connect your storage

We will connect to SharePoint for this guide. Head to your storage tab and select SharePoint. You can specifically enter a document library URL, otherwise you can leave it blank to connect all your document libraries, you can filter user access to specific libraries by their root path later on.

Connecting SharePoint for SFTP

Create additional users (optional)

You can create additional users here. Additional settings you have are permissions, firewall to restrict IP access, limit protocol access (disable FTP) and restrict the user to a specific folder as their root directory.

Creating additional SFTP users for SharePoint

SFTP/FTP

Now you can SFTP/FTP into your Microsoft storage by connecting to sftp.couchdrop.io and using the user credentials above.

Connecting to SharePoint via SFTP

For other guides and more detailed walkthroughs check out community.couchdrop.io or reach out to the Couchdrop team.

Related Posts

This blog is part of SharePoint Week. For more great content, click here

About the Author:

CEO of Movebot and Couchdrop and who has a passion for making cloud storage simple and accessible

Reference:

Bartram, J. (2021). SFTP/FTP for Microsoft Office 365 SharePoint and OneDrive. Available at: https://medium.com/couchdrop-io/sftp-for-microsoft-office-365-sharepoint-and-onedrive-634a68c0bf51 [Accessed: 7th September 2021].

Share this on...

Rate this Post:

Share:

Topics:

SharePoint