web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

Writing to a CRM SQL Server database

(0) ShareShare
ReportReport
Posted on by 175

I'm interested in updating a field in an existing record in a custom entity in a CRM database using a stored proc in a non-CRM database. I know you have to be carefull with things you do to CRM databases outside of CRM, so I reviewed the Unsupported Customizations page in the MSDN library. It seemed to say you couldn't make any physical schema changes outside CRM, but it didn't say anything about reading and writing data to a CRM database using external functions.

 Is it okay with Microsoft for me to read and write CRM data from outside CRM? If I'm not supposed to add or delete records, can I at least update a field in an existing record?

*This post is locked for comments

I have the same question (0)
  • Mitch Milam Profile Picture
    on at

    John,

    There is nothing wrong with reading from the database using SQL, we do that all the time, and it's pretty much supported.  However, writing to the database using SQL is not.

    While nothing will prevent you from performing update, you will be doing so at your own risk.  You just need to weigh the cost/benefits of a solution vs. supportability.

    The only officially supported method of writing to the CRM database is through the CRM webservices.

    Mitch

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans