Advice on synchronization changes to local db

(0) Share

Report

Posted on by MorkAmdo

Hi Experts,

We have a system (lets call it system X) which we have developed ourselves, and in this system, we display data from certain entities in CRM.

Up until now we have used the audit log to detect changes to certain entities, and then synchronized the nessecary tables to our own DB and system X reads the records from here.

I asked the devs why we do not fetch the data directly from CRM and they said that the Web API query times were too slow.

Now, since microsoft has changed the way audit logs work (moved them to azure cosmos DB), our synchronization fails, since the audit logs do not appear in order.

My question is, what would be your solution to this issue? Plugins, kingswaysoft, power automate with custom connector or other?

Is there a faster way to query CRM than to use the Web API or is there a way to optimize these queries?

Any advice would be appreciated. Thank you in advance

Categories:

Development / Customization / SDK

Performance

All responses (1)

Answers (0)

Suggested answer

Gustavo Longo on at

Like (0)

Report

RE: Advice on synchronization changes to local db

MorkAmdo,

Hope you are well.

Would say the best way is Web Api and consume the data directly from Dynamics 365.

If you are facing any issue on it, let's investigate.

So, repro the issue, capture details and raise a ticket with Microsoft Support team.

Regards,