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.

All responses (1)

Answers (0)

Suggested answer

a33ik 84,323 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.