5
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.
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,558
Super User 2024 Season 2
#2
Martin Dráb
228,647
Most Valuable Professional
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (
