What things should we consider when choosing between CRM online or on Premise?

It is very important to know that what we should choose between MS CRM Online and MS CRM on premise. In this post we compare the two platforms, look at what is similar, and compare the differences.

The first and very important benefit of on premise we can see and modify CRM Server and SQL Server. Rest of the difference we will go through the below categories-

Storage:

            In case of online it is limited to amount of storage purchased, if you required more than the purchase you have to purchase it with additional cost.

            For on premise it is limited to amount of storage available on your server.

Workflows/Dialogs & custom entities:

            You can create only 200 workflows and 300 custom entities when you are using CRM online.

            In case of on premise there is no such limit to create workflow and custom entities.

Sandbox environments:

            CRM Online provides non production environments as part of your subscription that can be used for dev/test/UAT. The number of organizations received depends on the number of users.

Non production environments can be installed, depending on local server availability when you are using on premise.

Data Integration Options:

Integration options are similar between CRM online and On Premises. Third party integration tools like Scribe Insight and SSIS with Kingswaysoft work with both CRM On Premises and CRM Online.

Integration performance will vary based on the data loaded. Very large data integrations are typically faster with CRM on Premises if the integration server is close to the CRM server as latency is very low.

CRM Online integration performance can be improved by optimizing the integration, using the bulk load API, or by reducing latency to the cloud by running the integration from a Microsoft Azure server.

Mobility:

CRM clients for Tablet, Phone and outlook work exactly same between CRM online and on premise.

Extensibility:

Customizations developed in a supported way for CRM on premise can be moved to CRM Online (and vice versa), and plugins, workflows and any custom extension can be used in either Online or On Premises deployments. Any supported code will work in both CRM online and On Premises.

Migrating:

CRM Online customers can migrate On Premises at any time. SQL database provided to client at scheduled time that can be imported to an On Premises deployment.

CRM On Premises customers can migrate to CRM Online and customization for entities can be imported; however, on premises database cannot be moved to Online data center, so a data migration is required.