Advice Needed RRS feed

  • Question

  • 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


  • 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