I'm in the middle of transitioning my company from old SFTP servers to OneDrive, and it's been a bit of a hassle. I often find myself alternating between the OneDrive app and an FTP client to manage my files, which feels unnecessarily tedious. My main task involves pulling files from the SFTP, sorting them into the correct OneDrive folders, and sometimes vice versa. Is there a more streamlined way to handle both connections on a Mac, or is it just typical to juggle two apps for this job?
6 Answers
Quick heads-up: at Couchdrop, we often tackle this scenario. You can connect your SFTP server and OneDrive, then automate the process of pulling files without needing to switch apps. Plus, if you want Finder-style access, OneDrive can be mounted like an SFTP endpoint.
You can actually mount the OneDrive as a network drive and manage everything right in Finder. Or, another option is to connect to the SFTP server directly to your OneDrive folder and organize things from there.
What OS are your SFTP servers running? If possible, you could set up an SMB share for those files. Just a heads-up, though: the Microsoft 365 ecosystem doesn't play nicely with Mac, so a Windows VM might be your best bet for handling this smoothly, potentially using Microsoft's SharePoint Migration Tool.
Thanks for the suggestion! I'll consider setting that up.
Have you considered using Rclone? It's a command-line tool that syncs files to and from various cloud storage services, including OneDrive.
If you're comfortable with command line tools, using bash with rsync could be a solid choice for transferring and syncing files.
Check out Panic Software's Transmit app; it supports both SFTP and OneDrive, making your file transfers more integrated.

Good point! A VM might actually streamline the process for those who are heavy on file transfers.