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

PdrTechs 1 Reputation point
2021-02-17T17:58:09.96+00:00

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.

Azure SQL Database
Azure Container Instances
Azure Container Instances
An Azure service that provides customers with a serverless container experience.
635 questions
Azure Functions
Azure Functions
An Azure service that provides an event-driven serverless compute platform.
4,239 questions
Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
2,839 questions
Azure Kubernetes Service (AKS)
Azure Kubernetes Service (AKS)
An Azure service that provides serverless Kubernetes, an integrated continuous integration and continuous delivery experience, and enterprise-grade security and governance.
1,853 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Navtej Singh Saini 4,216 Reputation points Microsoft Employee
    2021-02-19T03:24:23.923+00:00

    @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