SAP HANA Room for Improvement

Database Consultant at a pharma/biotech company

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.

View full review »
Software Engineer - Data at a energy/utilities company with 10,001+ employees

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. 

View full review »
Managing Director at a consultancy with 51-200 employees

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.

View full review »
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.
Senior Engineering Manager at a tech services company with 1,001-5,000 employees

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.

View full review »
Development & ERP Technologies Department Manager at a transportation company with 10,001+ employees

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.

View full review »
CEO at a tech services company with 51-200 employees

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. 

View full review »
Head IT at a healthcare company with 51-200 employees

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.

View full review »
Chief Executive Officer at Redment

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.

View full review »
Group General Manager-ICT at a consumer goods company with 501-1,000 employees

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.

View full review »
Chief Executive Officer at Redment

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.

View full review »
Vice President at StarTek

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.

View full review »
CEO at a financial services firm with 1,001-5,000 employees

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.

View full review »
Consultant at a mining and metals company with 5,001-10,000 employees

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.

View full review »
Section Head at a energy/utilities company

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.

View full review »
Technical Department Manager at Direcbusiness Technologies, Inc.

The documentation can be improved in the future.

In the next release, I would like to see integration with smart devices.

View full review »
Senior Consultant at a consultancy with 5,001-10,000 employees

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.

View full review »
Consultant Application Manager at a energy/utilities company with 5,001-10,000 employees

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.

View full review »
SAP Basis Consultant at a energy/utilities company with 1,001-5,000 employees

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. 

View full review »
Process Mining Data Scientist (CELONIS) at a consumer goods company with 10,001+ employees

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

View full review »
SAP Technical Consultant at a tech services company with 1-10 employees

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.

View full review »
CEO at a financial services firm with 1,001-5,000 employees

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.

View full review »
Assistant Vice President at a energy/utilities company with 10,001+ employees

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.

View full review »
Java Software Engineer at a tech services company with 10,001+ employees

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.

View full review »
Project Manager at a logistics company with 11-50 employees

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

View full review »
Datawarehouse Lead | Data Engineer at a manufacturing company with 1,001-5,000 employees

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.

View full review »
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.