
i have need to update records in Dynamics 365 (real time integration) from on-premise system . I prefer not to call Dynamics 365 API directly in onpremise system . I would like to provide a middle layer which onpremise system can trigger and that middle layer should call Dynamics 365 API. What is the best approach to give a middle layer in cloud ?
Hey.
You can use LogicApps/PowerAutomate. You can trigger this on a schedule (every 8 hrs for example) or upon a specific condition (when a record is created). The LogicApp/PowerAutomate can connect to SQL, retrieve the data, and connect to dataverse.
Regards,