2019-07-28T07:34:00Z

What needs improvement with SAP HANA?

62

Please share with the community what you think needs improvement with SAP HANA.

What are its weaknesses? What would you like to see changed in a future version?

ITCS user
Guest
2828 Answers

author avatar
Top 20Real User

Because SAP HANA is completely in-memory, it requires the use of bigger systems which have a higher amount of RAM. If the system does go down then coming back up is difficult and can take 30 to 40 minutes. It's a big drawback of the solution and one they ought to solve because the multiple downtimes are a problem.

2021-08-19T11:59:33Z
author avatar
Top 5LeaderboardReal User

The worst thing about SAP HANA is the price; it's very expensive. The licensing cost, implementation cost, hosting cost, and appliance cost are all high.

2021-07-01T21:27:20Z
author avatar
Top 5LeaderboardReal User

Since only some accommodation exists, there is a need to enquire of SAP about which environment would be good. While I know the HANA database on the Azure environment comprises a good solution, for example, it does not easily accommodate SAP. HANA is a new technology which only dates back to 2004 and we must give it adequate time before assessing its room for improvement. This is in contrast to DB2, which has been around for 40 years or more years. Perhaps the flow will be improved. As of now, the technology is too new to properly comment on. The documentation is not an issue and, if anything, a surfeit of it is made available. This is actually one of SAP's stronger points. Capabilities are also not at issue at present. When it comes to how EAP connects with SAP we are looking at a revolutionary paradigm. For now, we could not ask for there to be more features. This area is wonderful. We find the solution to be very helpful, safe, good and secure. Only with the passage of time will we be afforded a proper understanding of where the technology can be improved. This said, it would be nice to know when SAP plans to stop its maintenance of a previous version of SAP ECC ERP because, at this point, anyone utilizing SAP will have no choice but to go on S/4HANA Database. This will be contingent on when SAP will stop doing maintenance for the ECC version 6.0. We saw this with the 4.6 version ECC. Once SAP stopped its maintenance those with SAP were forced to go on the new version.

2021-06-04T19:00:00Z
author avatar
Top 20Real User

The main issue that we are facing is with the connectors. The JDBC connectors are very slow. We have been trying to connect with our SAP HANA database to our customers. It's a simple Java driver and there is no proper documentation available anywhere with clear steps. We have to rely on several documents which creates confusion. The initial setup could be simplified. Also, we don't have to option to pull up the data from the object structure in SAP HANA. We can only pull up certain objects. It doesn't provide you with a comprehensive list. There are limitations in connection with SAP HANA. There has to be a better or easier way to connect the databases with other platforms, maybe using Java code or other types of code. It would be very good to have the documentation on how to connect. I would like to have flexible connecting mechanisms for connection with Java or different types of solutions to SAP HANA on cloud or non-cloud solutions. They could come up with something similar to the SAP HANA Studio type of modeling. I would also like to see the capabilities to extend the API. If they had specific APIs, it would be easy for us to connect.

2021-05-11T23:04:19Z
author avatar
Top 20Real User

The performance and integration with other products are areas in need of improvement.

2021-04-05T19:05:26Z
author avatar
Top 20Real User

There could be better management for faster updates, last year there were some changes in India to the e-invoicing feature. During that time, there was a couple of updates that we had to wait until the release happened before we could do the implementation, this was a time we had to wait. They are pretty good at releasing updates but that time it was not the fastest.

2021-02-19T15:56:58Z
author avatar
Top 20Real User

The current version we are using is lacking some unique features, we are upgrading to the newer version of this solution that has these features, S4 HANA.

2021-02-14T18:20:00Z
author avatar
Top 10LeaderboardConsultant

I'm still researching the features of HANA. In terms of memory, data access and data pitching, HANA has scored a victory, no doubt about that. But when I compare the non HANA architecture with SAP, ERP, the SAP ERP comes in two levels. SAP ECC, which is a non HANA based product, and SAP S/4HANA, which is a HANA-based product. If I compare these two, there are almost around 5,000 to 6,000 tables, which were merged together in HANA, making it a robust architecture. In earlier SAP we used to have fragmented, small-scale architecture. HANA is a robust architecture where one table itself is a behemoth quantity of many, many columns and a lot of redundant data. So my interest in HANA would be how SAP is catering to the demand of reducing the redundancy of data, and at the same time pinning the entire critical tables into the memory so that access to the data is faster. I am researching those factors.

2020-12-23T13:55:00Z
author avatar
Top 5LeaderboardReal User

Compared to Oracle, the licensing could be better. SAP HANA is not strong like Oracle when it comes to finance. They are only strong with the logistic business project.

2020-11-26T19:14:00Z
author avatar
Top 5LeaderboardReal User

The documentation can be improved in the future. In the next release, I would like to see integration with smart devices.

2020-11-10T09:31:12Z
author avatar
Top 5LeaderboardReal User

The product is very demanding on memory requirements. This is a result of it being an in-memory processing product. The choice of the hardware must be done carefully because when subject to other hardware, it gets slow and just crawls. Memory on the other hand is not cheap because you have to buy it from a third-party. The cost of the database is not cheap either, as you have to pay for the runtime for any licenses that you purchase, and that comes each year. Now that is punitive with increasing license requirement.

2020-11-04T09:00:00Z
author avatar
Top 5LeaderboardReal User

They can improve their technology for the CRM subsystem. There are other products that are better and more effective for the CRM subsystem. Its price could be better. It is expensive.

2020-10-30T06:19:27Z
author avatar
Top 5LeaderboardReal User

The price of this product should be reduced. Technical support should be more customer-friendly. We would like to see better CRM functionality in the future because there are other products that are better and more effective.

2020-10-29T12:21:54Z
author avatar
Top 20Real User

I don't think that there is a feature that is lacking. It's quite good as a solution and we're pretty happy with most aspects of the product. I'd just like to see some more improvements done on the training, both on the functional training and technical training sides as a part of the complete solution. Currently, training is assumed to be a separate part of the solution. You have to purchase it separately. This should be a part of the solution's mandatory requirements. Most of the time, people fail to purchase training, and they fall back on it afterward, during implementation, as they realize how crucial it is.

2020-09-21T06:33:00Z
author avatar
Top 20Real User

SAP HANA is a very proprietary tool and there's not as much support available for it as there is for an SQL Server (which is more popular). It requires some internal SAP knowledge to work with the tool and it's a completely graphical modeling kind of a system. You can't come in cold with no knowledge or understanding of the solution and think you can jump in and start working. You have to work with the very few tools that are given to you. It could probably increase its flexibility and there could be more components added, which would make it more versatile. They could improve the solution by adding more components and by making it more feature-rich and including typical features that other more popular tools have. There needs to be better support from the SAP support team. There needs to be more support for other programming languages like high-level C++, Java, or Python. That could be another improvement. HANA needs more integration with open-source tools, and with general reporting and analytics tools that are out there on the market. Once again, more integration on so many levels would be amazing. It's very SAP-centric and very proprietary right now. There are ways to connect SAP HANA with many tools already, however, in particular with open-source tools, if there could be even more integration, that would be helpful. There needs to be more data transformation and more ELT features that can be implemented in the view.

2020-09-21T06:33:00Z
author avatar
Top 5LeaderboardReal User

We use SAP HANA in our projects but it's very expensive for our projects. We need a relational database in-memory that can handle these issues. The solution is very expensive for us. It's hard for us to find test users and sometimes we need them to connect to SAP from Iran, however, this is an issue due to the sanctions against the country.

2020-09-17T08:05:56Z
author avatar
Top 5LeaderboardReal User

Oracle tends to have better features than SAP HANA. They should work to add the kinds of features clients expect from Oracle. With Oracle, you can install their cloud and that enables you to see more of the database and multiple accounts. This is better than what SAP has on offer. SAP could really work on its monitoring capabilities. There's data aging that needs to be dealt with on the solution. It's not ideal. You might have a lot of raw data and aging can really affect it. It would be help if the solution had a graph database. They're lacking that right now. There's an issue in the partition. When you record more than two million records, partitioning does not work well. In Oracle it's easy. SAP must resolve this issue in order to be more competitive with Oracle.

2020-09-16T08:18:29Z
author avatar
Real User

The user experience should be better. Its user interface is not good. I also don't like the transition concept.

2020-09-01T05:25:11Z
author avatar
Top 20Real User

Unlike other databases, it lacks management features that legacy databases like Oracle or SQL servers have. They need to make the solution easier to manage and offer tools that make management more effective. A lot of things you have on traditional databases you have to develop into HANA.

2019-11-28T06:06:00Z
author avatar
Top 20Consultant

The solution needs to improve its integration capabilities. There could be some debugging techniques when the solution goes wrong or if some of the data is wrong. The solution needs to work a little bit faster. When you do a report on a non-SAP platform, you face some compatibility problems.

2019-11-27T05:42:00Z
author avatar
Top 20Consultant

I think that the pricing is high and it needs improvement. In the next release, they could separate the modules from the costing of the database. If they bundle it together with a new affordable price then customers will be ready to purchase it. They need an affordable price to achieve most of the minimum requirement assets.

2019-10-16T06:52:00Z
author avatar
Consultant

The challenge right now is all databases are on S4 HANA architecture. You're running it for HANA, but not all the functionalities are available. If they can speed up getting all the databases on S4 HANA that would help.

2019-10-13T05:48:00Z
author avatar
Consultant

If the developers were to enhance or improve the application logic while processing the transactions, that would be great. For example, if you are accessing a transection, it takes about 10 seconds. So the logic behind the transection usually is part of the development part and a product code is not from the database.

2019-10-03T07:51:00Z
author avatar
Top 20Real User

FI, or the financial module of SAP, has room for improvement. It has to have some better localization for the Middle East, especially in regards to taxes and the letter of a credit cycle. I would like to see better localization from the HCM.

2019-09-23T06:33:00Z
author avatar
Real User

One is the menu. There is a part of the menu where the button should be "reject." The interface is a little bit hard to customize. You almost have to consult the SAP original developer to change it. Now we have to consult SAP just to do some interface changes. You expect it to be easy to get into the menu, but you can't. Instead of changing the console you wanted to reject it, for example, if a tender that does not meet a specific qualification. Basically, the customization of the interface needs to be more friendly. I think we are also going towards mobile technology, so I would like to see the integration of a mobile app.

2019-09-22T06:41:00Z
author avatar
Real User

In terms of improvement, the speed is not as good as we thought it would be. That is why we are trying different solutions that will be built with different technologies. Also, the cost is an issue. SAP HANA is extremely expensive, especially in the cloud. Right now that has changed because you can actually purchase modules of that size but, for example, two years ago when we had a database of 10 terabytes, then we would have to purchase the hardware on our own and then put it in the cloud foreign location of the vendor. It runs on our own software that we have purchased. It's just placed in the same location as the rest of the cloud of the vendor. They should improve the speed and scalability

2019-08-26T06:42:00Z
author avatar
Consultant

The backup solution and time machine should be more accurate, reliable, and comfortable to use. The inclusion of a well-performing Time Machine is vital. If the interface were more comfortable and easy to use then it would be excellent. Sometimes, an incorrect request is taken to production and it will corruption everything in the production database. When there are a large number of records to process in a transaction, it is not any faster than Oracle.

2019-07-29T10:11:00Z
author avatar
Real User

From the deployment-side, I don't have any issues with the solution and haven't heard of any problems from clients. The solution is very expensive, however. The pricing depends on the number of users and many other factors that affect licensing.

2019-07-28T07:34:00Z
Learn what your peers think about SAP HANA. Get advice and tips from experienced pros sharing their opinions. Updated: August 2021.
534,299 professionals have used our research since 2012.