question

PdrTechs-6962 avatar image
0 Votes"
PdrTechs-6962 asked NavtejSaini-MSFT commented

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

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-databaseazure-functionsazure-logic-appsazure-kubernetes-serviceazure-container-instances
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

NavtejSaini-MSFT avatar image
0 Votes"
NavtejSaini-MSFT answered NavtejSaini-MSFT commented

@PdrTechs-6962

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
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@PdrTechs-6962

Please let us know if you need further help with this.

Regards
Navtej S

0 Votes 0 ·