I am very new to Sugar CRM. When I am going through questions in community I often see terms on-demand and on-site. Can some one clearly tell the difference between them.
On demand is when the code is hosted by SugarCRM and managed by them. E.g. you're on yourcompany.sugaropencloud.eu. On site is when you get the code from SugarCRM and put it on your own servers and manage running it/upgrading it yourself.
There are various advantages and disadvantages of both. E.g. it's harder to make customisations (you have to make a module loadable package instead of just dropping in the files), you can't edit core sugar code with on demand instances (although you shouldn't edit core sugar code unless it's an emergency), and in general customising it is more difficult. But on the other hand, you *can* customise it, you also don't have to worry about whether your servers go down, about security, upgrades etc - Sugar take care of that for you.
When starting out or for small instances, I'd recommend on-demand. If you have very bespoke demands (e.g. you're going to use the API a lot and think you'll be under heavy load and will require a big deployment plan) then I'd recommend onsite.
On-Demand mean that your instance is hosted on SugarCRM servers, and you do not need to worry about server software, updating sugarcrm version, security and so on.
Contrary on-site mean that you download SugarCRM software and install on server of your choice. For some companies that have some strong security policies this is only way.
To Alan's point, I would also add that the OnDemand platform also does not permit you direct access to the database. Thus, if you need it for some reason (usually for an integration), it wouldn't be available. The same is true for changes to the environment, such as adjustments to the PHP settings or addition of PHP extensions.
Lastly, our Support team can assist you with problems you are having with an instance on OnDemand or OnPremise, but they will assist you with problems with the Sugar application only. Problems that are related to your server or supporting technologies used by Sugar become your responsibility if you deploy OnPremise, hence the comments about you assuming management over the servers.
Retrieving data ...