Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / Will a Plugin get trig...
Customer experience | Sales, Customer Insights,...
Answered

Will a Plugin get triggered from a SQL update?

(0) ShareShare
ReportReport
Posted on by jrothlander 35

I see a lot of questions around this, but nothing directly answers the question. I'm trying to find a Microsoft reference that answers this, but not having any luck.

I'm trying to figure out if a custom plugin will fire when SQL updates are made outside of CRM. So if there's a plugin that is trigged on a given field update, will that plugin fire if the SQL is updated directly via some other process outside of CRM, or will it only fire if the update uses the CRM SDK, rest services, or from within CRM?

Just based on experience, the plugins do not fire if an update is made outside of CRM. But I want to make sure I am not misunderstanding something here. 

  • jrothlander Profile Picture
    jrothlander 35 on at
    RE: Will a Plugin get triggered from a SQL update?

    Thanks for the reply and confirmation of this.  It would be nice if I could get a plugin to fire directly from a SQL update but I can use the SDK or Rest services to update a single field in CRM and fire off the plugin after the SQL finishes. So I can work around it.

    It doesn't take long when working in CRM to find things you need to do that are not supported. We hired Microsoft and PowerObjects to build an integration service for us. But it was taking over 7-hours to integrate about 10,000 records (very large records so you expect it to be slow) but we needed it to run in about 5-minutes. So we tossed that and rewrote it to hit SQL directly and it ran in about 15-minutes. We've redesigned it a few times over the past few years to get it near real-time. So for us, using the supported features and a 7-hour option, really wasn't an option. But over time we depend less and less on unsupported features and more and more on supported features. But for a few of our data intensive integrations, we are still dependent on hitting the SQL directly.  

  • Verified answer
    Roberto Ilidio Profile Picture
    Roberto Ilidio on at
    RE: Will a Plugin get triggered from a SQL update?

    Hi Jon,

    Yes, you are right, plugins will not be trigged if you execute a SQL update directly into database.

    Indeed there is no Microsoft documentation with explicit  statement regarding this because SQL updates applied directly against the database is not supported.

    However the most closely documentation to understand it would be this one: docs.microsoft.com/.../event-framework

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

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Daivat Vartak (v-9davar) Profile Picture

Daivat Vartak (v-9d... 225 Super User 2025 Season 1

#2
Muhammad Shahzad Shafique Profile Picture

Muhammad Shahzad Sh... 106

#3
Vahid Ghafarpour Profile Picture

Vahid Ghafarpour 82 Super User 2025 Season 1

Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans