Try our new research platform with insights from 80,000+ expert users
reviewer2383002 - PeerSpot reviewer
Senior Engineer at a retailer with 10,001+ employees
Real User
Offers good performance and third-party integrations and sufficed all of our requirements
Pros and Cons
  • "It's sufficed all of our requirements. We primarily needed it to run SAP applications, like NetWeaver or S/4HANA, and it has been really good at that."
  • "The releases need to be more stable. It's surprising to still encounter significant bugs after ten years of the product being available."

What is our primary use case?

Primarily, we used it for reporting and as the underlying database platform for SAP BW solutions.

My experience with SAP NetWeaver is primarily at the database level with SAP HANA. The database is still under development even after its official release over ten years ago. We often see new products with each major release, and there are still a lot of bugs.

How has it helped my organization?

As an in-memory database, expectations for HANA were already high, especially considering the infrastructure investments. 

We've seen reporting performance increase four to five times, which was a substantial improvement. At the end of the day, you expect those improvements when spending significant amounts on a solution.

It's a relatively new technology, and in-memory databases intrinsically require larger servers with more memory. We purchase the HANA license from SAP and the hardware from a vendor like HP or IBM.

Ultimately, as an organization, we aimed to speed up support and enable our executives to generate reports on their screens almost instantly with the click of a button. From that perspective, HANA delivered as a reporting solution.

SAP HANA's in-memory computing improved our operational efficiency. In terms of our overall business operations, I'd estimate a 30-40% improvement. Considering things like ticketing, resource allocation, and issue resolution, it's definitely had a sizable impact.

What is most valuable?

Its performance is one big benefit. 

Reporting is also valuable, but that's standard. I also like SAP HANA's ability to integrate with third-party tools. We can do reporting with tools like Tableau or Power BI by integrating them with HANA for visualization.

It's sufficed all of our requirements. We primarily needed it to run SAP applications, like NetWeaver or S/4HANA, and it has been really good at that. We also successfully integrated it with Tableau for reporting. Overall, it sufficed our needs.

What needs improvement?

The releases need to be more stable. It's surprising to still encounter significant bugs after ten years of the product being available.

In terms of features, SAP seems to be keeping up with its competitors like Oracle. The main issue is that the features they add often have a lot of bugs.

Buyer's Guide
SAP HANA
December 2024
Learn what your peers think about SAP HANA. Get advice and tips from experienced pros sharing their opinions. Updated: December 2024.
831,158 professionals have used our research since 2012.

For how long have I used the solution?

I've been working with it for ten years. I was a customer of HANA for ten years and have since moved on to new technologies.

What do I think about the stability of the solution?

I would rate the stability a seven out of ten. It should be improved. It's not that the system goes down, but there are irritations that affect users.

What do I think about the scalability of the solution?

It's a highly scalable solution. No concerns there. It supports our growing data needs.

I would rate the scalability an eight out of ten. 

We have database-based users and business users. Overall, it would be more than five thousand at my last organization, we had many employees dependent on SAP. However, we were looking to onboard a few more of our business units to SAP. So, we were targeting an increase in usage by 20% to 30%.

How are customer service and support?

There is room for improvement in the following areas:

  1. The response times
  2. The prioritization framework for customers
  3. Reaching the correct expert quickly

So, those areas should be noted for improvement in customer service and support. 

How would you rate customer service and support?

Neutral

How was the initial setup?

I would rate my experience with the initial setup a six out of ten, with ten being easy. 

Because with HANA, it's less about setting up a new system and more about migrating your old system to HANA. The migration experience isn't the same for everyone or for all customers; you can't follow a single runbook. 

You often need external consultants, SAP premium subscriptions, and SAP experts to manage the migration, and sometimes you need external code. So, from that perspective, it's a six.

I have used SAP HANA on the public cloud and on-premise.

What about the implementation team?

There are two ways to think about the deployment stage:

  1. For a Greenfield implementation of HANA, you are building a system from the ground up with SAP, which might take as little as a week. 
  2. For large-scale brownfield implementations, where you're migrating your existing database to SAP HANA, it can take anywhere from five to six months to one year.

What's my experience with pricing, setup cost, and licensing?

The price is on the expensive side, at eight out of ten, with ten being expensive. 

We were premium customers with our HANA boxes. It was part of an enterprise license that wasn’t tied to the number of HANA instances we had. 

What other advice do I have?

I would recommend ensuring you have the proper SAP experts on your team if you plan to go for SAP HANA. 

If you don't have SAP experts, it's better to opt for SAP cloud solutions, which are managed by SAP.

Overall, I would rate it an eight out of ten. 

Disclosure: I am a real user, and this review is based on my own experience and opinions.
Flag as inappropriate
PeerSpot user
Supply Team Engineer at Micron Technology
Real User
User-friendly interface that allows users to fetch data easily
Pros and Cons
  • "SAP HANA's interface is pretty user-friendly."
  • "SAP HANA's long run time to extract data could be improved upon."

What is our primary use case?

We use SAP HANA mostly for fetching data. There are a lot of tables for which we need to do some troubleshooting. For example, if the fill rates are low daily, we examine various factors, such as yield production versions and inventory levels, to understand why it is happening. To assist us in this process, we leverage Blue Yonder ESP, which operates on HANA View. As a supply chain consultant, we use SAP HANA to fetch data from these tables to troubleshoot the issue and find out why the fill rate is dropping. This helps us determine if it is a genuine issue related to supply or something related to the model.

How has it helped my organization?

We have been building a lot of sniffer audits for users. For instance, if a bond structure is not going a particular way, the master data team and the business users can check those audits. These audits, made to assess the data quality, will confirm if it is something we have already identified. So all the data quality audits are built on HANA View.

What is most valuable?

SAP HANA's interface is pretty user-friendly. It is not very difficult to pull out data extract, and even a beginner can fetch data easily. Additionally, data snapshots are available. Also, building upon a more advanced query is not that difficult. In terms of usability, SAP HANA is pretty good.

What needs improvement?

SAP HANA's long run time to extract data could be improved upon. Also, the analytics given in SAP HANA's interface is basic and could be improved upon.

For how long have I used the solution?

I have been using SAP HANA for a year.

What do I think about the stability of the solution?

I rate SAP HANA an eight out of ten for stability.

What do I think about the scalability of the solution?

I rate SAP HANA a seven out of ten for scalability. SAP HANA can be used in the tactical horizon, which for us is 52 weeks. Anything beyond that needs scenario-based planning, which is not possible with SAP HANA.

Around 5,000 to 6,000 users are using SAP HANA because we are a team spread across the globe in places like Boise, the US, Singapore, Japan, Taiwan, and India. The first users are supply chain engineers and IT employees. Business users hardly use it because it is a little complicated for them. Since we are trying to expand our tactical horizon from 12 months to 18 months, the usage of SAP HANA will increase in the future.

How are customer service and support?

SAP HANA's technical support is pretty good.

How would you rate customer service and support?

Positive

Which solution did I use previously and why did I switch?

Before using SAP HANA, we were entirely using SAP APO. We switched to SAP HANA because it is an optimizer and gives better results than SAP APO.

How was the initial setup?

I rate SAP HANA a seven and a half out of ten for its initial setup. The deployment of SAP HANA took around 18 months.

What about the implementation team?

The major part of the deployment was done internally. However, initially, we did use external consultants. So SAP HANA's deployment was partly internal.

The first step in the deployment process is customization, which involves obtaining the solution according to our requirements, including the data we use and the basic tables it provides. Our bond structure was changed to enterprise bonds so SAP HANA could process it. An IT team worked entirely on the data transformation part to ensure the data from other upstream systems could be processed. After that, we went into the design part, the user acceptance testing, and finally went live.

What other advice do I have?

New users of SAP HANA need to have basic SQL coding skills and attention to detail to see data using the solution. It might be complicated for someone, not from a background where they're used to seeing a lot of data.

Overall, I rate SAP HANA an eight out of ten.

Which deployment model are you using for this solution?

Private Cloud
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Buyer's Guide
SAP HANA
December 2024
Learn what your peers think about SAP HANA. Get advice and tips from experienced pros sharing their opinions. Updated: December 2024.
831,158 professionals have used our research since 2012.
Development & ERP Technologies Department Manager at Israel Aerospace Industries Ltd.
Real User
Good solution for SAP-oriented users
Pros and Cons
  • "We are using the solution for the DW system. The primary function of the solution is for the database in memory."
  • "I would like to see improvements in the connectivity of the solution with other BI software. Not every software can connect to it natively."

What is our primary use case?

We are using the solution for the DW system. The primary function of the solution is for the database in memory.

What needs improvement?

I would like to see improvements in the connectivity of the solution with other BI software. Not every software can connect to it natively.

For how long have I used the solution?

I have been using the solution for the past five to six years.

What do I think about the stability of the solution?

I would rate the stability of the solution an eight out of ten.

What do I think about the scalability of the solution?

I would rate the scalability of the solution an eight out of ten. The solution is quite scalable. You can increase the usage if you have enough hardware. There are about 5000 users in our organization.

Which solution did I use previously and why did I switch?

Previously, we used Oracle Database, but we have changed to HANA database now.

How was the initial setup?

The initial setup was not easy since it took a couple of days to install the tool. We had to download it from the internet and follow some processes so that the tool could be integrated into our internal network.

What about the implementation team?

The deployment of the solution was done in-house.

What's my experience with pricing, setup cost, and licensing?

I would rate the pricing of the solution a ten out of ten. The pricing for on-prem SAP HANA is on a yearly basis and expensive. I am not aware of the actual pricing but it is based on 64 Gigabytes. For instance, if you consider $10,000 for 64 Gigabytes, then you can calculate the cost for Terabytes in case you have one. You will have to buy expensive hardware as well which is quite a lot.

What other advice do I have?

I would rate the solution a nine out of ten. There are three SAP-based individuals involved in the maintenance of the solution. This solution is recommended for SAP-oriented users only since it is very expensive as a database.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
George Mukira - PeerSpot reviewer
ICT Consultant at Spring Training & Consulting
Real User
Beneficial interactions with suppliers, reliable, and improves organization
Pros and Cons
  • "The most valuable feature of SAP HANA is the interaction it provides with external suppliers and clients."
  • "When we are using SAP HANA we have some difficulty with the customization. We would like to be able to add and make customized menus."

What is our primary use case?

We have used SAP HANA to do some tendering through the supplier management system. We have our own servers that are hosting the solution.

Primarily we use SAP HANA to manage suppliers, they can upload the tender documents. We are then able to do prequalification based on the preset requirements. We then know who is qualified and who is not. Additionally, it has helped us send notifications to the suppliers.

How has it helped my organization?

Using SAP HANA has reduced a lot of paperwork that we would typically be doing and the communication we have with our suppliers. Additionally, it has improved our organization and approval process.

What is most valuable?

The most valuable feature of SAP HANA is the interaction it provides with external suppliers and clients.

What needs improvement?

When we are using SAP HANA we have some difficulty with the customization. We would like to be able to add and make customized menus.

In a future release, there should be a way to cancel or delete, for example, a tender document. The deleting or canceling of documents is sometimes confusing.

For how long have I used the solution?

I have been using SAP HANA for approximately three years.

What do I think about the stability of the solution?

SAP HANA is a stable solution. 

What do I think about the scalability of the solution?

The scalability of SAP HANA is good.

We have more than 500 people using the solution plus the suppliers we have. We can give suppliers accounts. 

How are customer service and support?

I have used the support from SAP HANA. We have expectations some of our problems should be fixed in 24 hours but they are not fixed for 48 hours. It's not that the support does not know how to do it, but sometimes it takes a little bit longer for them to have our solution.

How would you rate customer service and support?

Neutral

Which solution did I use previously and why did I switch?

I have used previously Oracle and Microsoft Innovation. We switched to SAP HANA because the cost was more favorable than Oracle and it was more user-friendly.

How was the initial setup?

The initial setup of SAP HANA was gradual, it took us approximately six months.

What about the implementation team?

We used consultants, project managers, and our team to do the implementation of SAP HANA. The solution is stable and we do not have to do a lot of maintenance.

What's my experience with pricing, setup cost, and licensing?

There is an annual license to use SAP HANA.

I rate the price of SAP HANA an eight out of ten.

What other advice do I have?

My advice to others is for them to do a lot of research and training before they decided to go live with the solution.

I rate SAP HANA an eight out of ten.

Which deployment model are you using for this solution?

Hybrid Cloud
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
HassanMustafa - PeerSpot reviewer
Senior Data Warehouse Consultant at a consultancy with 1,001-5,000 employees
Consultant
Top 10
Mature and fast with excellent graphical calculation views
Pros and Cons
  • "It's very convenient and very innovative."
  • "You cannot apply mulit-join inside the calculation views, for example, when you are joining tables."

What is our primary use case?

We have a full landscape for SAP. Currently, my customer is using it. We are using the native HANA for the non-SAP sources.

We have our data nodes for different business domains. The data is coming from non-SAP sources. The data is coming from different systems. We have a database warehouse approach.

What is most valuable?

The solution is very fast in terms of memory. It's very convenient and very innovative. It's very good at handling the input and output of the data. There is no lag.

It has become the base of building graphical calculation views. 

It is very convenient when you are working with Postgres or Snowflake. When you have modeled everything correctly, it's easy to translate the model. 

With the way native works, it builds a good platform. It's not just a database. It's much more.

It has an inbuilt smart data integrator which you can use for sourcing, researching, and loading the data. It's included in the web IDE version of the web HANA deployment. 

This is a very mature product. The performance is very good. 

What needs improvement?

I cannot think of any features that are missing at this time. 

In the calculation views, the functions that have been provided to build the graphical views should be enhanced and could be made more flexible. There should be more functionality available.

You cannot apply mulit-join inside the calculation views, for example, when you are joining tables. You have to do it in a four-node. You have to join them one by one instead of joining everything together in one step. 

For how long have I used the solution?

I've been using the solution for six years. 

What do I think about the stability of the solution?

The performance is good. It is mature and stable. I've never experienced any issues like crashing or freezing.

What do I think about the scalability of the solution?

The scalability is very good. I'd rate it 8.5 out of ten in terms of ease of scaling. 

This is a good solution for enterprise solutions. 

How was the initial setup?

In terms of the initial setup, I do not know how to install it on the server itself. I don't handle the technical aspects since I am a consultant. I don't directly handle the setup process. Likely, it is installed on Linux.

What's my experience with pricing, setup cost, and licensing?

While my understanding is the product is likely expensive I do not handle the pricing. I don't know the exact costs. 

Smaller companies may not be suitable as the pricing is quite expensive. Even medium-level companies would have trouble affording a full SAP stack. An enterprise would have the budget to take this solution on.

The cloud may be more affordable, however, on-prem would be very expensive. 

What other advice do I have?

I'm a consultant. 

In terms of relational databases, this is the best option.

If you are going to work with HANA, make sure to use the latest version. It has the latest approaches.

Users should utilize the HANA platform to the fullest extent. Get the most out of it by using all of the tools, as much as possible. Don't just use it as a data model database.

I'd rate the solution nine out of ten. 

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Umair Hassan - PeerSpot reviewer
Database Administrator at Systems Limited
Real User
Top 10
Useful user administration and server management, but lacking user-friendliness
Pros and Cons
  • "As I only worked part-time on SAP HANA, I did not have the opportunity to explore the advanced features of the solution. However, I did work with basic features, such as user administration and access controls for the accounting department. The feature that stood out to me the most was the Single Sign-On and user administration, backup, and server management. My experience with SAP HANA was mainly focused on basic server improvements."
  • "In my limited experience using SAP, the process of granting access to different modules is difficult. Specifically, the requirement to assign roles and key codes to users rather than being able to assign them individually made the process more complex. It would be beneficial if there was a way to assign key codes separately, rather than having to create multiple roles. This would make managing access easier."

What is our primary use case?

In our company, we utilized SAP HANA to manage various types of information, for example, inventory, employee information, and accounting-related tasks, such as billing and employee surveys. The majority of our employee information was stored in SAP HAHA.

What is most valuable?

As I only worked part-time on SAP HANA, I did not have the opportunity to explore the advanced features of the solution. However, I did work with basic features, such as user administration and access controls for the accounting department. The feature that stood out to me the most was the Single Sign-On and user administration, backup, and server management. My experience with SAP HANA was mainly focused on basic server improvements.

What needs improvement?

In my limited experience using SAP, the process of granting access to different modules is difficult. Specifically, the requirement to assign roles and key codes to users rather than being able to assign them individually made the process more complex. It would be beneficial if there was a way to assign key codes separately, rather than having to create multiple roles. This would make managing access easier.

The grid could be made more user-friendly. While it is functional, it is not as user-friendly as other databases or accounts. In particular, I find that SAP HANA is a bit more complex for users to navigate. This could be improved to better serve the user.

For how long have I used the solution?

I have been using SAP HANA for approximately one year.

What do I think about the stability of the solution?

SAP HANA is a stable tool. On and off, there were some issues, but overall the experience was good and we didn't have any sort of trouble using the setup or any other users complaining about anything.

I rate the scalability of SAP HANA a ten out of ten.

What do I think about the scalability of the solution?

We have approximately 70 users using SAP HANA in my company. We had some shared applications which were another approximately 30 users using the solution.

The solution is scalable.

I rate the scalability of SAP HANA a nine out of ten.

How are customer service and support?

We provided support to our clients and we did not resolve ourselves we did not go to the vendor for an answer we looked online at the community support for our needs.

I rate the support of SAP HANA a seven out of ten.

How would you rate customer service and support?

Neutral

Which solution did I use previously and why did I switch?

When comparing SAP HANA to other solutions in the same category, such as MySQL and Denodo, there are several differences. MySQL is more user-friendly than SAP HANA. Additionally, MySQL does not require a license to use, whereas SAP HANA does. However, SAP HANA does have its own advantages, such as being faster than MySQL and it is better suited for applications that require higher processing power. Ultimately, it depends on the specific needs of one's business and what they are trying to accomplish with their database which is the better solution. I find MySQL to be easier to work with than SAP HANA.

What's my experience with pricing, setup cost, and licensing?

There is an annual payment needed to use the solution.

What other advice do I have?

I rate SAP HANA a seven out of ten.

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
DilipRoshantha - PeerSpot reviewer
Head Of Information Technology at Noratel
Real User
Top 5
Has a simple table structure that makes it a high-performance system for customers
Pros and Cons
  • "In comparison with other DMS solutions, it offers good performance."
  • "They should develop and improve the solution's data management system."

What needs improvement?

They should develop and improve the solution's data management system. They should also work on the capabilities and features of their mobile and cloud applications.

For how long have I used the solution?

We have been using the solution for five years.

What do I think about the stability of the solution?

The solution is highly stable once configured. It requires regular garbage collection activity to function smoothly. Also, it depends on the implementer and vendor's services.

I rate the solution's stability as an eight.

What do I think about the scalability of the solution?

I work with an enterprise business client with 500 users using the solution. Based on the requirement, the solution allows us to scale up our capabilities and business processes.

Thus, it is scalable, and I rate the scalability as an eight.

How was the initial setup?

The solution's initial setup is straightforward, but it requires experience for implementation.

On average, it takes six to eight months for deployment. There are some instances where it takes a year when the client wants to combine two solutions together.

We use SAP's new project management model for deployment. It is a complete infrastructure service where we get the hardware from hyperscaler and implement the application.

What about the implementation team?

Our implementation team includes business, functional, and POD consultants.

What's my experience with pricing, setup cost, and licensing?

The solution's licensing is expensive for SMEs and large enterprises alike. There are no additional costs included.

What other advice do I have?

I recommend the solution to others and rate it as a nine. In comparison with other DMS solutions, it offers good performance and is excellent in administration management. It has a simple table structure that makes it a high-performance system for customers. I advise others to select an implementer with knowledge and experience in using the solution.

Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
PeerSpot user
George Pereira - PeerSpot reviewer
Analista de sistemas at Audaces
Real User
Stable, faster than its competitor, and suitable for ERP
Pros and Cons
  • "What I like best about SAP HANA is that it's faster than Microsoft SQL Server."
  • "The SAP HANA interface has room for improvement because it takes more work to manage than the Microsoft SQL Server interface."

What is our primary use case?

We primarily use SAP HANA for ERP in the manufacturing and delivery industries.

What is most valuable?

What I like best about SAP HANA is that it's faster than Microsoft SQL Server.

What needs improvement?

The SAP HANA interface has room for improvement because it takes more work to manage than the Microsoft SQL Server interface.

Nowadays, you'll see more no-code tools in the market with a drag-and-drop feature, and that's what I want to see in SAP HANA in the future.

For how long have I used the solution?

I've been using SAP HANA for six months.

What do I think about the stability of the solution?

SAP HANA is a stable product. Its stability is eight out of ten.

What do I think about the scalability of the solution?

The scalability of SAP HANA is a six out of ten.

Which solution did I use previously and why did I switch?

My company used to work with Oracle Database version 10.2, but migrated to Microsoft SQL Server and now also using SAP HANA because Oracle Database is expensive, plus it requires users with a higher level of experience on Oracle Database.

How was the initial setup?

The initial setup for SAP HANA is so-so. It's not easy, yet it's not so difficult. I'm rating its setup as six out of ten.

The total time it takes to deploy SAP HANA depends on the type of integration. I have a lot of integrations where one integration gets deployed within thirty minutes, while another takes more than two days to deploy.

What's my experience with pricing, setup cost, and licensing?

The pricing for SAP HANA is high. It was expensive. You have to pay a lot, and it's the highest-priced solution in the local market, though when you compare it to other tools in the global market, the price is similar.

You pay a lot for the license, and you also have to pay for some add-ons.

I'd rate SAP HANA licensing fees as two out of ten.

What other advice do I have?

My company uses SAP HANA.

My company has SAP Business One version 9.3 that integrates with SAP HANA, but I haven't worked much on SAP HANA yet.

I'm a user of SAP HANA, not a partner.

Around thirty people, mostly technicians, work on deploying SAP HANA. The solution requires five to six engineers for maintenance.

My company has eighty-eight SAP HANA licenses used mainly by the end-users, for example, managers.

I'd tell anyone looking into using SAP HANA that it's a good tool but expensive for smaller-scale companies.

On a scale of one to ten, I rate SAP HANA as ten because it's a good tool, and I like its technology.

Which deployment model are you using for this solution?

Hybrid Cloud
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user