Automatically pull external files into Sharepoint folder

%3CLINGO-SUB%20id%3D%22lingo-sub-2635996%22%20slang%3D%22en-US%22%3EAutomatically%20pull%20external%20files%20into%20Sharepoint%20folder%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2635996%22%20slang%3D%22en-US%22%3E%3CP%3EMy%20company%20has%20a%20process%20that%20produces%20reports%20pulled%20from%20MySQL%20%2F%20Sql%20Server%20databases%20and%20the%20files%20are%20written%20to%20a%20local%20drive%20of%20a%20server.%20We%20need%20to%20pull%20those%20reports%20into%20a%20SharePoint%20Folder.%20I%20know%20we%20can't%20use%20a%20mapped%20drive%2C%20as%20Microsoft%20does%20not%20support%20this%20and%20also%20the%20account%20won't%20stay%20logged%20in.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20are%20my%20best%20options%20to%20automate%20this%20process%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2635996%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMySQL%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESQL%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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.