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) / Connect CRM 2013 to p...
Microsoft Dynamics CRM (Archived)

Connect CRM 2013 to pre-existing Sql tables?

(0) ShareShare
ReportReport
Posted on by peter cli 730

Is it possible to map  CRM 2013 On-Prem  to  existing SQL tables?

For example, if sql had a table called X, could I create  CRM entity called X, and have the CRM UI making changes to the entity which are reflected back to the sql table ?

Thanks,Peter

 

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    jlattimer Profile Picture
    jlattimer 24,564 on at

    Not directly - you'd need to write some code to handle this or use an ETL tool to move data from a corresponding CRM entity to the external DB.

  • peter cli Profile Picture
    peter cli 730 on at

    Hi Jason,

    I don't want to replicate data.

    I am looking at an iframe in a existing CRM entity form.

    Any gotcha's with that ?

    Thanks, Peter

  • Aileen Gusni Profile Picture
    Aileen Gusni 44,524 on at

    Hi Peter,

    You can use IFrame to show your external app that will update your external database from CRM, but if you don't create the table X in CRM, you can only show or CRUD data from CRM through external application, not directly from CRM, update CRM DB then will auto update entity X, you cannot use certain features available in CRM, such as Goal Management or Marketing List Criteria that calculate or get data from table X. If you want to duplicate the data, you can use SSIS, the advantage is you have to maintain both sides, but advantage is you can use to manage your data in entity X (now becoming entity X in CRM DB) to be used in CRM features. It might be little bit different from SharePoint you can use External Data Source as the SP List.

    Thanks.

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!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
Varsha deshpande Profile Picture

Varsha deshpande 5

#2
JS-09031509-0 Profile Picture

JS-09031509-0 3

#3
Ciprian P Profile Picture

Ciprian P 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans