What's the best Azure service for this?

Question

Hi everyone.

I'm currently working on a couple solutions for 2 different problems and am wondering what would be the most effective way to structure it using the services from Azure. Both of these solutions need to run every day in the morning.

• Solution 1: Use a script (probably Python) to generate .txt files from data currently stored in my Azure SQL Database. I then need to take these files and send them somewhere using either a program installed in a Windows computer, or through an FTP connection.
• Solution 2: Execute a Python script that takes data from the Azure SQL Database and send them somewhere else using API calls.

Thanks in advance.

Answer 1

Hello Sinais,

You can use Azure Function for Python:

https://learn.microsoft.com/en-us/azure/azure-functions/functions-reference-python?tabs=asgi%2Capplication-level&pivots=python-mode-configuration

Azure Automation for Python:

https://learn.microsoft.com/en-us/azure/automation/learn/automation-tutorial-runbook-textual-python-3

---

If this is helpful please accept answer.

Answer 2

Hi Sinais

We will love to discuss directly with you for more details about your environment and requirements, but the scenario described seems to be a good match to our Azure Functions integration with Azure SQL.

 https://devblogs.microsoft.com/azure-sql/using-python-and-azure-functions-to-send-data-from-azure-sql-database/

Could you please send an email to azcommunity@microsoft.com and mention in the subject line ATTN: Oury so I don't miss it.

Regards,

Oury