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.
SQL VS. HANA
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’.