question

PythonLearner avatar image
0 Votes"
PythonLearner asked PythonLearner edited

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

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.


azure-functions
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

MughundhanRaveendran-MSFT avatar image
0 Votes"
MughundhanRaveendran-MSFT answered PythonLearner edited

@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://docs.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.


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@MughundhanRaveendran-MSFT
I have a question.
I am trying to figure out how to use my .NET SDK inside Azure Function solution (local machine - using Visual Studio 2019).
I was able to test publishing one Function.cs file into Azure Function (inside Azure Portal).

How do I repo SDK inside Function solution file and eventually publish?
Do I have to publish one cs Function file each time?

Thanks.

0 Votes 0 ·