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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / CRM SQL database direc...
Microsoft Dynamics CRM (Archived)

CRM SQL database direct access

(0) ShareShare
ReportReport
Posted on by komisacros 80

Hello,

I have the requirement to provide an web services which retrieves data (about one entity) from CRM. CrmService web service is not an option because it has a quite complex way of retrieving data, meaninng a have to build query objects in which I specify what entitty I am interested in. I need a method like: RetrieveOportunities(..).

 One option I considered is to build this web service over CrmService, but this might not give me the needed performance, because it implies another web service jump.

The only other option I have in mind is to build my web service which directly accesses CRM SQL database and selects needed data from there.

  • Is this posible? If yes how can I achieve this?
  • Do I have other posiblility
  • Is it a good practice?
  • If I do this on CRM 3.0, will I have to do changes when I migrate to CRM 4.0?
  • What do you think about this aproach?
Thanks in advance.

*This post is locked for comments

I have the same question (0)
  • Alberto Gemin Profile Picture
    Alberto Gemin 155 on at
    Re: CRM SQL database direct access

    Hi,

    If you really don't want to use the two web services cascading option for performance reasons you can definitely go directly to the database. CRM 3.0 provides "Filtered Views", which are SQL Server Views that are aware of CRM security permissions (they let you see only those records you are supposed to see) and de-normalize a lot of reference and seed data (so together with the picklist value you will have the display value). Go to the database, look for views whose name starts with "Filtered".
     
    - It is a good practice
    - It is supported in CRM 4.0
    - I think it is a good approach, unless you can live with the CrmService option.
     
  • komisacros Profile Picture
    komisacros 80 on at
    Re: Re: CRM SQL database direct access

     Hello,

    Thank you for the answer. It seems it what I need. This is the approach I will go with. 

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
HR-09070029-0 Profile Picture

HR-09070029-0 2

#1
UllrSki Profile Picture

UllrSki 2

#3
ED-30091530-0 Profile Picture

ED-30091530-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans