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

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.