What are the drawback of MS Dynamic CRM online and on premises version ?
*This post is locked for comments
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.
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).
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.
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,240 Super User 2024 Season 2
Martin Dráb 230,149 Most Valuable Professional
nmaenpaa 101,156