
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)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