What is our primary use case?
The main use case for SAP HANA is that I mainly support the S/4HANA system, which is SAP's ECC successor to the Enterprise Resource Planning Software. Apart from that, it is used in Business Warehouse, so these are the main uses.
What is most valuable?
The most valuable SAP HANA features are that, compared to Oracle, there is less administrative work and less complex work to handle, making it very straightforward. The tool itself takes care of the backend work.
The main benefits SAP HANA provides to users include its architecture, which combines both column store and row store capabilities. Some places find the row feature important, whereas others find column store important. It allows some tables to be stored in a column base, others in a row base, and the In-Memory functionalities are mostly the highlight of SAP HANA, especially compared to disk-based memory users. This was the main reason SAP HANA was introduced initially.
What needs improvement?
Based on my experience, SAP can improve SAP HANA in terms of customer preferences. Many customers still prefer Oracle, possibly due to cost or familiarity, despite SAP mandating that they have to go to SAP HANA. I have recently seen some newer implementations where customers are still happy with their current SAP and Oracle combination, and they are moving to SAP HANA only because their Oracle support will be ending soon.
For how long have I used the solution?
I have been working with SAP HANA for more than five years.
What was my experience with deployment of the solution?
The initial setup for SAP HANA is simple, too simple.
What do I think about the stability of the solution?
I would rate the stability of the product at eight because recently we faced some issues in SAP HANA replication. However, I do not believe it is a SAP HANA issue. It could be the tool managing the replication that might be at fault, though we are not sure because the root cause is not yet confirmed. We believe that the issue is likely with the Pacemaker Linux cluster managing the replication, since we recently faced customer data loss during the cluster handover or failover fallback.
What do I think about the scalability of the solution?
The scalability for SAP HANA is generally rated as either a ten or a nine issue.
How are customer service and support?
I would rate technical support from SAP as somewhat unsatisfactory compared to other peers. For instance, when we raise a ticket for AWS or Azure issues, we find their support is very proactive, while SAP's support is quite passive. We often do not know when our ticket will be handled or who is handling it, and we can wait from one to four days for a reply, which is unexpected.
How would you rate customer service and support?
Which solution did I use previously and why did I switch?
When I compare SAP HANA to Oracle, I find that SAP HANA is better and easier to manage. However, Oracle has released a newer version called 19C, which I have never used because now SAP promotes SAP HANA. I see that Oracle is also starting to catch up with Cloud or other new technologies, so in time, they will have additional features that are competitive.
How was the initial setup?
The initial setup for SAP HANA is simple, too simple.
What about the implementation team?
I recommend SAP HANA mainly for large companies. I believe the licensing cost is on the higher side, but for those companies whose performance is crucial, it does not matter as much at the cost of high pricing. Other alternatives might be possible for smaller companies.
What's my experience with pricing, setup cost, and licensing?
I would rate the price for SAP HANA as high.
What other advice do I have?
Real-Time Analytics capabilities in SAP HANA are mostly used by the development team, not as an administrator or support team. I believe Real-Time Analytics is beneficial mostly because of the development team; however, I don't have any exposure to their analytics capabilities.
Regarding analysis and ML features, I do not have experience with predictive analytics.
When it comes to how SAP HANA supports both structured and unstructured data, I am unsure about what is meant by unstructured data. However, I think there are other databases that also support this kind of data. I don't find anything unique in that regard because, for example, Oracle also has File Store or something for PDFs; unstructured data has been common for ages.
I cannot recommend this product to users. I feel that SAP's approach of mandating customers to go with SAP HANA is not a good point; they should make SAP HANA so good that customers willingly choose it. Since SAP HANA was introduced, SAP seems to be forcing a monopoly by not giving options, leading customers to have to choose between staying with SAP or moving away entirely. Thus, I rated it eight out of ten; otherwise, it would have been a ten.
Which deployment model are you using for this solution?
On-premises
Disclosure: My company has a business relationship with this vendor other than being a customer. Partner