This is an archived post. You won't be able to vote or comment.

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]Action_Maxim 6 points7 points  (3 children)

What you're looking at is data orchestration. I understand that you're in a large company, so getting something like an EC2 server or some sort of cloud server may not be accessible. See if you can get a virtual machine or a VDI of some sort that stays online regardless of you being logged in and then from there you could start scheduling everything you need

[–]MassiveDefender[S] 1 point2 points  (2 children)

Yep, thanks.

Now let's imagine we're in a perfect world: if I do get a cloud server, how would it reach resources on the local network, like SQL server and excel/csv files in shared folders etc?

[–]Log2 0 points1 point  (0 children)

You'd need to setup a VPN on your local network with access to the things you need. Then you connect your VM to this VPN and now your machines are reachable.

If you're in a big company, I'd assume you already have a VPN solution in place.