Using Azure Functions with .NET SDK (to move data to Azure SQL Server)

Question

I am trying to do the data integration with a third party application called Sage (Sage Intacct).
We are just moving data from Sage into Azure SQL Server for reporting purpose.

Sage provides .NET SDK.
According to their website, this is their system requirements:
https://developer.intacct.com/tools/sdk-net/

• .NET Core >=2.0 or .NET Framework >=4.6.1. The SDK targets .NET Standard 2.0.
• An up-to-date NuGet client:
• NuGet 5.7.0+
• Visual Studio 2019 version 16.0
• dotnet.exe (.NET SDK 2.1.0+)
• JetBrains Rider 2020.2+

Can I fulfill their requirements using Azure Functions?

Eventually, I need to use Azure Data Factory to move data to Azure SQL Server, but for that part, I understand Azure Functions has a connection to Azure Data Factory. So I am not worried.

Thanks.

Answer 1

@KingJava ,

Thanks for reaching out to Q&A.

Yes. Your requirements can be fulfilled by Azure functions, Azure data factory uses a webhook to communicate with Azure functions so http triggered function would be the right choice and if your functions are going to be long running (execution time > 230 seconds), then you can choose durable functions . You can also explore event based approach.

System requirements appears to be fine, you can target .net core 2.0 in Functions and Visual Studio 2019 : https://learn.microsoft.com/en-us/azure/azure-functions/functions-versions?tabs=csharp%2Cv4

I hope this helps! Feel free to reach out to me if you have any further queries.

Please 'Accept as answer' and ‘Upvote’ if it helped so that it can help others in the community looking for help on similar topics.