Skip to main content

Notifications

Microsoft Dynamics CRM (Archived)

What are the drawback of MS Dynamic CRM online and on premises version ?

Posted on by Microsoft Employee

What are the drawback of MS Dynamic CRM online and on premises version ?

*This post is locked for comments

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: What are the drawback of MS Dynamic CRM online and on premises version ?

    When comparing the CRM Online (OL) to CRM On-Premise you will find a lot of theory as already posted here. If you were looking at it from a practical point of view, here are some highlights:

    • Consider the business requirements, will you have integrations to worry about. CRM Online is out with a common data model, giving you options to use Flow and PowerApps with very little development.

    • CRM On-Prem has been at time performing better than CRM OL with less latency, due to local network traffic and an isolated instance that does not shared resources with another companies globally.

    • Then we should look into database size, online storage can be considered more expensive than buy hard drives for your local server

    • The number of custom entities in the CRM OL instance is limited to 300. Do you require more? If so, look into the design of your solutions and see if you can accommodate the limitation.

    • The CRM OL version has the automatic rollups, patches scheduled and are published sooner than the CRM On-Prem installations

    • Will you be using your CRM over the internet, with IFD configurations?

    • What mobile requirements are needed in your deployment?

    • The setup of CRM On-Prem takes longer than CRM OL, thus increasing implementation time and resources

    • What corporate governance will be required by your company? Will POPI and ISO certifications be required in your country?

    There are many moving parts to a CRM deployment. Discuss them with you team and see which instance best suits your needs.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: What are the drawback of MS Dynamic CRM online and on premises version ?

    For me major difference is in reporting.IN On Premise, we can write SQL Queries. SQL Queries are quite flexible and better in making complex reports than FetchXML(CRM Online).

  • Thomas David Dayman Profile Picture
    Thomas David Dayman 11,323 on at
    RE: What are the drawback of MS Dynamic CRM online and on premises version ?

    For me personally:

    CRM Online has regular updates such as fixes and new functionality. But  you have no direct access to the SQL Database. If anything happens in the back end you will have to contact Microsoft and get them to fix it.

    CRM On Premise has a direct access to the SQL Database. If anything happens in the back end you can quickly address the issue. But any bugs already existing in CRM wont get patched.

    Its a small example of the differences but its one of the main differences I found to affect me the most.

  • Suggested answer
    ScottDurow Profile Picture
    ScottDurow 50,177 on at
    RE: What are the drawback of MS Dynamic CRM online and on premises version ?

    Herr are the features available compared in the official documentation -www.microsoft.com/.../dynamics-365-online-vs-on-premises-features-faq.aspx

    I would say that Online has the advantage since it has more azure integrated services. The only significant drawback is the sandboxing of plugins and ssrs but with the introduction of the data export service this isn't so much of an issue. See msdn.microsoft.com/.../gg334752.aspx and technet.microsoft.com/.../dn531138.aspx

    Hope this helps

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans