Azure Services to Extract data from Mysql on on-premises database and store result in a excel file.

Question

Hi All, I am new to azure and I am planning to do a business case study and requirement is to Extract data from Mysql on on-premises database and store result in a excel file.
It looks like ADF does not support to store data in excel format as output. Could you please let me know what are the Azure services that I can use to implement this on cloud. Thanks.

Answer 1

@Mark - Thanks for the question and using MS Q&A platform.

Yes, you are correct that Azure Data Factory (ADF) does not support writing data directly to an Excel file. However, there are other Azure services that you can use to implement this solution on the cloud.

One option is to use Azure Blob Storage to store the output data in a CSV file format. You can use ADF to extract data from your on-premises MySQL database and write it to a CSV file in Azure Blob Storage. Then, you can use another Azure service like Azure Functions or Logic Apps to read the CSV file from Blob Storage and convert it to an Excel file format.

Another option is to use Azure SQL Database to store the output data in a table format. You can use ADF to extract data from your on-premises MySQL database and write it to an Azure SQL Database table. Then, you can use another Azure service like Azure Functions or Logic Apps to read the data from the Azure SQL Database table and convert it to an Excel file format.

In both cases, you can use Azure Functions or Logic Apps to automate the process of converting the data to an Excel file format and storing it in a desired location.

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

---

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Answer 2

can you connect Mysql with client DB driver?If yes,you can try phpmyadmin or navicat to export datas. Or write and run codes by C# or PHP directly.