Hi Experts,
I have already set up the Dataverse connection with Business Central successfully.
Right now, I can synchronize data, but it only works with manual synchronization (job queue).
What I want is to achieve automatic, real-time bidirectional synchronization between Dataverse(Power App) and Business Central, so that whenever I perform a CRUD operation (Create, Read, Update, Delete) in either system, the changes should be reflected immediately in the other system.
For example:
- If I create a new Account in Dataverse, it should create a corresponding Customer in Business Central automatically.
- If I update the Customer name in BC, it should update the linked Account in Dataverse in real time.
- If I delete the Customer in BC, the Account should also be deleted in Dataverse (and vice versa).
I am looking for a way to make it real-time and automatic, mainly for standard tables (Customer/Account, Contact, Product, etc.), and later I may extend it for custom tables as well.