Automatically pull external files into Sharepoint folder

[dpimental]

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?

[#2]

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.