how to insert records into custom entity from sql server Database Procedure

(0) Share

Report

Posted on by CRM Dynamics Extension

HI,

We have a MS Dynamics CRM on Promises. I created a new custom entity and wrote a new database procedure in the CRM Database. This procedure is doing a lot of calculations. I want to insert the output records that resulted from these calculations in the custom entity from the same DB procedure.

Please Help.

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

a33ik 84,331 Most Valuable Professional on at

Like (1)

Report

RE: how to insert records into custom entity from sql server Database Procedure

Hello,

My recommendation - don't insert data to your CRM using SQL. You can do queries/calculations using SQL procedures but when it's coming to creates/updates/deletes - you should use supported approach and it's either home grown app that will connect and do required data manipulations or SSIS + adapter for CRM (I recommend KingsWaySoft adapter).

Good luck.

Was this reply helpful? Yes No