Asking an architectural question:
What are possible strategies to build a simple ETL process that regularly calls few external MySQLs and then drop obtained data into a Azure SQL DB??
(prefer not to have a full SQL server to manage external connections and so on)
on a fully linux machine I could make a cron with a bash script with mysql and sqlcmd utils and few lines of code, but that seems unnecessary
I see on Azure:
Azure Logic Apps
Azure functions (even in python)
A Container / Kubernete
Azure Scheduler (which seems outdated)
I presume each of them will be sufficient for our needs?
Just asking what path start going, new to Azure, and new to so many tools and functionalities.