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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Inserting records to C...
Microsoft Dynamics CRM (Archived)

Inserting records to CRM from outside source

(0) ShareShare
ReportReport
Posted on by Pete_N 1,703

CRM2016 On Premises

I'm just exploring all possibilities. Currently I'm importing data into CRM from a live legacy system's SQL database using a third party  piece of software or a CRM custom workflow. I'd like to look at the possibility of writing the records directly to CRM from a Web Application or application fired from a SQL server

1. is there a supported means of doing this

2. has anyone done anything like this and what advice / pitfalls to be aware of

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    gdas Profile Picture
    gdas 50,091 Moderator on at

    Hello ,

    - Build a WCF service (REST/SOAP) which communicates to CRM using SDK and expose the service in the WEB so that external system can access the API to insert the data.

    In addition if you are in on-premise ,using AD user authentication you can directly access CRM Web API if the web application hosted in same network.

  • Kenneth Heiman Profile Picture
    Kenneth Heiman 45 on at

    You can always write code using the SDK / WebAPI, but in this case you might consider using Flow/Logic Apps using a SQL trigger that writes data to the CRM connector. You can use an on-premise data gateway to connect to an on-premise sql server, and 'fire' your flow/logic app when SQL records are created and/or modified, then map the fields from your SQL database right into a CRM record.

  • Suggested answer
    Adrian Begovich Profile Picture
    Adrian Begovich 1,027 Moderator on at

    Hi PeteN,

    SQL Server Integration Services (SSIS) is a great ETL tool for implementing this.

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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