designing a process flow like this in our CloverETL Designer (which is a visual tool for designing data transformations) is quite straight-forward and is only a matter of adding and linking 2 components and configuring the connections to both AWS and SQL Server. Furthermore, our CloverETL Server which is a runtime platform for automation and orchestration of such process flows will easily enable you to schedule the data loads to run on a regular basis or get triggered upon various kinds of events. More information about these tools can be found on our website
where you can also easily download a 45-day trial to see if Clover is what you are looking for. Just click on the DOWNLOAD 45-DAY TRIAL button, fill in a simple form and you are good to go with trying out Clover.
Once you start CloverETL Designer you will be welcomed with a tutorial which will guide you through the basics of how to use it and will provide you with many simple, yet useful examples in the section Help > CloverETL Examples. If you stumbled upon any issue during the trial feel free to reach out to us either here on the Forum or by shooting us an email to [email protected]