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) / Display data from anot...
Microsoft Dynamics CRM (Archived)

Display data from another database

(0) ShareShare
ReportReport
Posted on by SamCRM1 247

Hello All,

I am trying to display some data on CRM form using external SQL server database. When user enters the SSN of a customer, I want to query the SQL DB and display all the policies that are assigned to that SSN (either in lookup or optionset or some kind of grid). I have all that customer and policies information in a separate SQL server DB and not in CRM. I think I can use webresource but not sure how. Please help!

Thanks

Sam

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Joe Griffin Profile Picture
    Joe Griffin 1,254 on at

    Hi SamCRM1,

    You are correct that a HTML Web Resource would be one way of doing it, however I do not know if there is a way of querying a SQL Server DB in JScript that would prevent against an SQL injection attack or similar.

    Do you have an SSRS instance connected to your SQL Server DB? I have been able to get SSRS reports embedded in a IFrame previously, passing parameters from a CRM field to a report. This would only be a read-only version of the data, however.

    Another option could be to setup a SSIS package that populates a custom entity in CRM with the data you need from the database on a regular basis, and then just query entity data instead from within CRM. KingswaySoft have some tools that can help with this.

    Hope this helps.

    Thanks

    Joe

  • Verified answer
    Zohaib Uddin Khan Profile Picture
    Zohaib Uddin Khan 2,822 on at

    Hi,

    You can achieve your requirement as mentioned below:-

    Approach # 1

    1. Create a WCF Service: It will fetch the data from the external SQL Server DB based on the SSN.
    2. On the Form_Onload: Call the WCF Service, it will return the data and populate that on the fields placed on the form.

    Approach # 2

    1. Create a WCF Service: It will fetch the data from the external SQL Server DB based on the SSN.
    2. Create a Custom Asp.Net page: It will call the WCF Service and show the data on the Asp.Net form.
    3. Create IFrame on the Form: Which will call the Custom Asp.Net page.

    Thanks.

  • SamCRM1 Profile Picture
    SamCRM1 247 on at

    Got it working. Thanks

  • Chris Sherwin Profile Picture
    Chris Sherwin on at

    Hi SamCRM1 how did you got it worked? Im working on same issue. Could you please the steps to display external database values into crm subgrid without saving the data into crm

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