Hi Folks,
We have implemented Third Party Application integration with MS flow.
Fully Cycle: 3rd Party Tool -> Azure DB -> MS Flow -> D365FO
Current Scenario:-
1. 3rd party tool pushes a single record to AZURE DB ( 2 seconds)
2. AZURE DB pushes that record to MS FLOW ( more than 30 seconds)
3. MS FLOW pushes it to D365FO ( 20-25 seconds - Not very consistent with timings sometimes it take 5 or 26 seconds)
4. D365FO - Received record will get processed.( 20 seconds)
The entire process is completed in more than a minute and few seconds more.
But expected completion time is 30 seconds only.
Problem:-
2nd step ie AZURE DB to MS flow is taking more than expected time.
It should not take more than 2-3 seconds.
Approaches:-
1. can we optimize MS flow to reduce timings ?
2. if we can not optimize MS flow, can we replace 2nd and 3rd step with direct AZURE DB connection using x++
(I am clueless how can we establish connection with AZURE DB)
3. I am using Trace options of D365FO to optimize the performance but I feel it wont be of much help since it will trace only at the 4th stage.
4. any other optimal way of accomplishing this ?
This integration is GO-LIVE stopper for us, if we can not achieve this in 30 seconds.
GO-LIVE could be on halt.
.
It would be really great help if someone can guide about this process.
Thanks in advance.
