Skip to main content

Notifications

Customer experience | Sales, Customer Insights,...
Suggested answer

Advice on synchronization changes to local db

(0) ShareShare
ReportReport
Posted on by 5

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

  • Suggested answer
    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,

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Announcing Category Subscriptions!

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,359 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans