Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Advice Needed RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    CRM 2013

    I have the need to lookup information from two custom entities from an external SQL Stored procedure. In SQL I would normally do a join, however CRM poses a few problems. My first though would be to create a view in the crm database, but before I go headlong into this, would there be any implications within the CRM system ?

    Dont ask me .. i dont know

    Friday, August 29, 2014 11:46 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    You should most definitely not create a new view on the CRM database - that isn't supported and could cause issues with a future update or upgrade.

    A  better option might be to expose the data you need via a webpage you can display with an iframe or expose a web service the CRM code could query for the data.

    Jason Lattimer
    My Blog -  Follow me on Twitter -  LinkedIn

    Friday, August 29, 2014 1:12 PM
    Moderator