If your company is in the process of evaluating an ERP or have already implemented SAP Business One in your company, then this article is for you.

In this post, we aim to explain the differences between the SQL and HANA versions of SAP Business One, which will help you choose or upgrade to a better solution for your company.


The fundamental difference between the two is the database technology. The SQL version is based on an approximately 60 years old disk storage technology using relational databases whereas the HANA is an in-memory, i.e. RAM, technology. For HANA, the data is loaded on the memory of the server and as there are no physical moving parts to retrieve the data the speed at which it retrieves, inserts or updates data is much faster.

Is the speed/processing power the only reason to choose HANA over SQL?

NO. The real benefit from the increased speed is support of applications and functions that require a lot of processing power. So effectively, functions that are or can be made available on HANA simply cannot be made available on the MS-SQL or any other old technology of disk based databases.

To help you with the comparison, we have listed some frequently asked questions.

HANA is not a new technology. It was first released in 2010 for the higher end SAP systems and the technology was ported to the SAP Business One application in 2012. The technology is past the evangelical phase and there are now 16,300 HANA customers world-wide.

The SAP user license fees for both versions are the same. The database licenses for SQL and HANA are comparable. In fact, the SQL licenses at the enterprise level can be a lot more expensive than the HANA database.

Contrary to what some may say, Business One on HANA is an affordable solution and does not require a super-computer to run! There are many SAP certified HANA hardware which includes brands like Fujitsu, Dell, HP and Lenovo. The price for the HANA server is only slightly higher than the SQL server as it needs more RAM memory.

Yes. Depending on your needs, Inecom offers 2 flavours for your business to run Business One on HANA

  • Perpetual SAP licensing with on-premise server
  • Perpetual SAP licensing with Inecom-AWS data centre hosting


  • Customer has the flexibility to choose a region-specific hosting provider and also run Business One on HANA in a Private cloud environment

With minimal price difference between the SQL and HANA versions, there is no reason why you should invest in the SQL version now. In addition, SAP has announced in 2015 that all R&D will be focused on the HANA technology.

Designed with simpler user experience in mind, the HANA version has workbench functions to reduce expensive training and handover costs when new staff joins. The continuous development of machine learning in HANA will also make the software more intelligent and automate labour-intensive transaction processing.

If that is not enough reasons, the below features are only available on HANA. These functions below are examples of functions that require extensive processing which simply makes it impossible to work on MS-SQL:

  • Enterprise search – a free-style search engine that helps uses retrieve information quickly without opening many programs.
  • Forecasting functions like cash flow forecast; inventory forecast based on historical data/ trends.
  • Advanced delivery schedule management
  • Analytics function
  • Sales mobile application
  • Chat Bot (machine learning capability, to be released soon) – supports natural language query like ‘Help me to analyze my sales data’.

HANA is not just a reporting tool. It is a platform that supports functions that require high processing power like forecasting, MRP, scheduling and many more.

The HANA solution is already pre-packaged with over 40 dashboards and 20 KPIs. In addition, the Excel-based Interactive Analytics lets users slice and dice their business data; change grouping/pivot table/sorting sequence on-the-fly and the ‘reporting format’ is not fixed.

Application migration to HANA from SQL is a project by itself and Inecom has got a good amount of experience in moving customers from SQL to HANA satisfactorily. The timeline depends on the custom components like business specific addons, integrations to third party systems and customized crystal reports and layouts and SSP addons if any. If the company is using SAP B1 on SQL with standard out of box functions, then we are looking at a minimum timeline of about 10 to 15 days excluding the number of days required for hardware migration.

In case you have more questions on HANA or SAP Business One in general, contact us now.

To know more about how Inecom can help you in implementing enterprise solutions like SAP Business One, SAP Business One on SAP HANA, Infrastructure Solution such as Microsoft Azure, SAP Add-ons like Quality Management System, Warehouse Management System and Web-Portals etc. please reach out to us at enquiries@inecomworld.com or talk to our SAP expert.