GLUEing an AZURE SQL DB (no server) and external MySQL DBs

Question

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.

Answer

@PdrTechs

The best way we can think of for this as a Database person will be to use Azure Data Factory.

Please go through the connector overview for the ADF here where MySQL is available as source and Azure SQL is available as sink.

If you still want more info about the apps and services that you mentioned, let us know and we can route to our adjacent team for the same.

Regards
Navtej S

1 answer