Automatically pull external files into Sharepoint folder

Copper Contributor

My company has a process that produces reports pulled from MySQL / Sql Server databases and the files are written to a local drive of a server. We need to pull those reports into a SharePoint Folder. I know we can't use a mapped drive, as Microsoft does not support this and also the account won't stay logged in. 

 

What are my best options to automate this process?

1 Reply
PowerShell can be used to upload files into a SharePoint folder. You could create a script and run it on a schedule to do this. I have an example script for uploading files on my blog
https://steveknutson.blog/2021/03/16/migrating-m-files-to-sharepoint/

The other option would be to Sync the SharePoint library using OneDrive and copy the files into the local (sync'd) folder for the library.