Skip to main content

Notifications

Microsoft Dynamics 365 | Integration, Dataverse...
Suggested answer

Payroll Calculation - Azure function or Console App?

(0) ShareShare
ReportReport
Posted on by 873

Hello,

I want your suggestions and the most appropriate approach to the technology that we should use to implement the following requirements:

We have around 2500 employees and we plan to build a payroll calculation process on PowerApps model-driven.

Per employee, it will take approximately 12 records to generate his full salary.

So in total 30-40K records will be created when the calculation is over. Not to forget the other GET API operations to check the setup tables etc.. (Huge number of API calls)

I would like to know which product we should extend to handle this process and I thought about the following:

Using Azure Functions or the Console App with Dataverse.

We want to choose wisely as the product should be very stable and we want to avoid any timeout or delay issues during the calculation process.

Your advice and explanation of why we should use it and the pros and cons would be greatly appreciated.

Thank you,
EBMRay

  • Suggested answer
    Bipin D365 Profile Picture
    Bipin D365 28,964 Super User 2024 Season 1 on at
    RE: Payroll Calculation - Azure function or Console App?

    Hi,

    Execute multiple request can be used for batching

    learn.microsoft.com/.../execute-multiple-requests

    You can increase default 2 mins timeout value in CrmServiceClient.

    Please read below article

    ramontebar.net/.../

    You can use paging in fetchXml and query expression to retrieve more than 5k records

    learn.microsoft.com/.../page-large-result-sets-with-fetchxml

  • EBMRay Profile Picture
    EBMRay 873 on at
    RE: Payroll Calculation - Azure function or Console App?

    Hello Bipin Kumar ,

    Thank you for your suggestion.

    I will determine which option is best for us.

    Can you provide some documentation regarding the best practices to handle timeout, CRUD operation with batches (pagination), and If I missed anything please feel free to provide it.

    Awaiting your response.

    Best regards,

    EBMRay

  • EBMRay Profile Picture
    EBMRay 873 on at
    RE: Payroll Calculation - Azure function or Console App?

    Hello Guido Preite ,

    Thank you for your input.

    We need to test both products as we need to check which one is more performant. This is because we have a lot of API calls to read from dataverse to fetch the related information for the employee and the setup tables etc..

    We tried to calculate one employee using an Azure function (not durable) and it took around 5 minutes to calculate his salary which is a LOT of time.

  • Suggested answer
    Bipin D365 Profile Picture
    Bipin D365 28,964 Super User 2024 Season 1 on at
    RE: Payroll Calculation - Azure function or Console App?

    Hi,

    You can use azure function with premium plan which has unlimited timeout period

    The following table shows the default and maximum values (in minutes) for specific plans:

    Plan                   Default Maximum

    Consumption plan 5 10

    Premium plan       30 Unlimited

    Dedicated plan 30 Unlimited

    You can also create console application and host it on azure web jobs which can run on schedule

  • Suggested answer
    Guido Preite Profile Picture
    Guido Preite 54,087 Super User 2024 Season 1 on at
    RE: Payroll Calculation - Azure function or Console App?

    that amount of data can be orchestrated with a durable azure function but is not an easy task.

    easier way will be to create a console application

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Announcing Category Subscriptions!

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,359 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans