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.