Hi there,
I'm looking for advice and best practices concerning setting up an integration or even an integration framework between Dataverse and external system(s). Our Dataverse should be seen a the source system which should feed one or more other external systems. We can make the assumption all child systems have REST API available.
To give an example:
- When a record is added to Dataverse entity A it should also be created in System X
- When a record is updated in Dataverse entity A it should also be updated in System X
Basically all create, update and delete actions should reflect to the downstream systems.
Now I'm looking for best practices to set this up in a mature, and scalable way. I know Power Automate provides triggers which can achieve this, but to me this doesn't really qualify as mature and scalable. As monitoring and error handling is still rather limited. Next to this the whole licensing model can be rather cumbersome when we onboard more and more systems to this.
I was looking in the direction of putting messages on Azure Service Bus (Walkthrough: Register an Azure-aware plug-in using the Plug-in Registration tool (Microsoft Dataverse) - Power Apps | Microsoft Learn) and handle the messages from there using Logic Apps, Azure Functions or somethings else. But, there must be best practices, what would you recommend?
