Hello Everyone,
I am working on to integrate BC and CE for some of its core entities like customer, vendor, contact and Sales order. Out of various options I narrowed down to Azure Function and Azure LogicApps. I need you expert opinion to further refine the approach based on following points:
1. The integration is fairly straight-forward (not too many business rules or computation), therefore all this mapping and syncing can be achieved in real-time using Azure Logic Apps without requiring to call Azure Function.
Good: It uses declarative approach so easier to maintain with little technical ability.
Bad: Logic Apps charges for each action and therefore as it increases the cost increases. Also as the number of requests/transactions going to increase in future the LogicApps is turning out to be expensive.
2. Use Azure Function only: Run the function on a schedule (twice a day) basis to pull/push records from CE/BC
Good: Can accommodate code and conditions very smooth as we get a good control through C# code. Less cost (compute time) as compared to LogicApp
Bad: As the function need to pull lot of records as compared to one record in RealTime sync, therefore compute time increases because of which i have to split into multiple functions. This results in around 5 functions running for around 5-8 minutes and therefore ultimately increasing my cost. In case I have to increase the runs in a day this cost rises drastically.
Both the above approaches are having their own pros/cons where I am seeking your expert advice.
Any help is much appreciated.
Thanks,
Neeraj
