do you have python code to specifically load load data from on-premise MySQL database into azure data lake storage?

Question

do you have python code to specifically load load data from on-premise MySQL database into azure data lake storage?

• I am not finding a specific example for MySQL in Azure Data Factory
• preferably Python example

Answer 1

Hello @Alphonse Okossi FT ,

As per my knowledge, I haven't seen anyone using python code to load data from on-premise MYSQL database into Azure Data Lake Storage.

Pushing data from your on-premise mysql database into the cloud can easily be orchestrated with Azure Data Factory. Azure Data Factory is Azure’s cloud-based data integration service that allows you to orchestrate and automate data movement and transformations.

If you are using Microsoft Azure Cloud, using ADF is the way to go:

• ADF takes care of all needed drivers to integrate with Oracle, MySQL or SQL Server; together accounting for +90% of all on-premise databases.
• ADF has a solid way to access data, securely over your firewall through a gateway.
• If your data store is located inside an on-premises network, an Azure virtual network, or Amazon Virtual Private Cloud, you need to configure a self-hosted integration runtime to connect to it.

For more details, refer Copy data from MySQL using Azure Data Factory and Moving Data from an On-Prem Database Using Azure Data Factory.

Hope this helps. Do let us know if you any further queries.

------------

Please don’t forget to Accept Answer and Up-Vote wherever the information provided helps you, this can be beneficial to other community members.