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

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
JS-09031509-0 Profile Picture

JS-09031509-0 3

#2
AS-17030037-0 Profile Picture

AS-17030037-0 2

#2
Mark Eckert Profile Picture

Mark Eckert 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans