SAP Technical Architect at a pharma/biotech company with 1,001-5,000 employees
Real User
Top 5
Great database that saves data easily and good reliability
Pros and Cons
  • "We can save data very easily."
  • "The pricing is expensive."

What is our primary use case?

The solution is mainly for in-memory computing and past data processing, both columns or databases. It's a very good database.

What is most valuable?

The solution offers very good in-memory computing.

We can save data very easily.

It is easy to set up. The implementation process is quite straightforward for us. 

The solution is stable.

What needs improvement?

There are limitations on tables. There is a two billion record limitation on a table. We'd like it if there could be more. If a table passes two billion records, SAP goes down.

The pricing is expensive. 

For how long have I used the solution?

I've dealt with the solution since 2012. It's been about ten years or so. We've used it for around a decade now. 

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

What do I think about the stability of the solution?

It's very stable. We've been using it for almost ten years and haven't had any issues. There are no bugs or glitches. It doesn't crash or freeze. 

How was the initial setup?

The solution is very straightforward and simple. It's not overly complex or difficult. 

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

It's quite a costly product. It is expensive. I'd rate it four out of five in terms of the level of expense. 

What other advice do I have?

I'd rate the solution ten out of ten. It's one of the best databases in the world. 

Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
PeerSpot user
SAP manager at Pakistan Telecommunication Limited
Real User
Top 20
Along with an easy setup phase, users can opt for the multiple deployment models it offers
Pros and Cons
  • "The product's initial setup phase was really easy."
  • "The high price of the product is an area of concern where improvements are required."

What is our primary use case?

SAP S/4HANA recently established communication with SAP HANA database. No other database can be used with SAP S/4HANA application.

SAP HANA can be used for real-time analysis and resolving queries. It has an in-memory database that uses RAM instead of hard drive disks, making it a very fast tool compared with any other relational database.

What needs improvement?

Actually, SAP HANA has a different application for each purpose. If you want a better UI experience, SAP has its own application. If a user wants to manage an application, SAP has another application. If a user wants to use the baseline command, SAP has its own tool for it where one can manage it. There is always room for improvement in every field, but right now, I can't think of any area.

The high price of the product is an area of concern where improvements are required.

For how long have I used the solution?

I have experience with SAP HANA.

What do I think about the stability of the solution?

Stability-wise, I rate the solution a nine to ten out of ten.

I have barely faced any issues with the product in the last two or three years.

What do I think about the scalability of the solution?

The product offers scalability options. The tool offers two to three scalability options. If you are stuck on the upgrade part and you want to expand the disk space at RAM or storage levels, you can easily upgrade your hardware or networks.

How was the initial setup?

The product's initial setup phase was really easy. A user just has to choose the pre-configuration options, and the tool will prompt with every option to help what one should choose, after which the product can be installed within ten to twenty minutes.

The solution is deployed on the cloud and in the on-premises model. Depending on what a user wants, it offers an on-premises data center deployment option. People can also choose between the SAP Cloud and the public cloud options. In SAP Cloud, there are other products offered, and the cloud also helps manage the DBMS application.

What was our ROI?

Speaking about the value and benefits a company can experience from the use of the solution, I would say that if an organization plans to implement an ERP solution in their company, then it should be SAP S/4HANA as it will be very beneficial. SAP HANA provides a free database to users, but it has very limited functionality. If a company wants to get full advantage from SAP application, then they must go with SAP HANA.

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

The tool is expensive compared to other products, like Oracle R or Microsoft, but it offers a range of all the company's functions.

What other advice do I have?

SAP HANA is a new innovation from SAP compared to the old databases, like RDBMS. SAP HANA serves as an in-memory database that works fast and solves queries in real-time.

In terms of the most valuable functionality in speeding up data processing tasks, the main features of SAP HANA revolve around the fact that it is really easy to manage since there is no need to work on the command line, as the solution has its own application that is used for it. Our company's work and manageability parts are very easy with SAP HANA. SAP has many applications that can help my company manage SAP HANA, which is a very easy process. With the product, it is easy to manage backup and restore.

In every project, my company uses SAP HANA for data management because we have to load all the data in the DB. At that time, I never faced any error while doing any configurations since there would never be any issues with the DB part. A specific person is needed to manage the DB part. Even in a small company, there will be one person to manage the DB since it is very easy to manage by SAP HANA.

When speaking about the tool's in-memory computing can impact data analysis capabilities, if one considers the old database or RDBMS, then I would say that they have capabilities related to rows. When we execute a query or when we analyze data, the query only works with the rows as it reads every line. SAP S/4HANA allows for the aggregation of columns, making the retrieval of data very specific. I think a range of 1-1000 can be considered for the analysis of data.

SAP HANA is specifically made for SAP applications and is called S/4HANA. SAP launched HANA database with applications for SAP-related operations. SAP has certain tunings to ensure that SAP applications work better. I just use the tool with SAP applications, and I will never use it with any other applications. From SAP's end, SAP HANA is a very good database.

From the admin side, I never got involved with any integrations related to the product, but I would recommend it.

If a company wants to manage its resources, like for different functions, if an organization wants an application that can be used for enterprise resource planning, SAP is the best solution in the world.

I rate the overall tool a nine out of ten.

Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
Flag as inappropriate
PeerSpot user
Buyer's Guide
SAP HANA
April 2024
Learn what your peers think about SAP HANA. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
769,236 professionals have used our research since 2012.
Amin Mohamed - PeerSpot reviewer
Procurement & Contracts Team Leader at ATS
Real User
Top 10
Excellent monitoring, reporting, and price and stock control
Pros and Cons
  • "SAP HANA's most valuable features are monitoring, reporting, and price and stock control."
  • "SAP HANA isn't user-friendly, and it's very hard to train newcomers to use it."

What is our primary use case?

I primarily use SAP HANA for procurement.

What is most valuable?

SAP HANA's most valuable features are monitoring, reporting, and price and stock control.

What needs improvement?

SAP HANA isn't user-friendly, and it's very hard to train newcomers to use it. In the future, SAP HANA should develop and review their offering for the construction field.

For how long have I used the solution?

I've been using SAP HANA for six years.

What do I think about the stability of the solution?

SAP HANA is very stable - I would rate its stability ten out of ten.

What do I think about the scalability of the solution?

SAP HANA's scalability is good - I would rate it nine out of ten.

How was the initial setup?

SAP HANA was very hard to implement.

What about the implementation team?

We used an in-house team.

What was our ROI?

SAP HANA has saved us huge amounts of time and money.

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

SAP HANA is very expensive for small to medium businesses.

What other advice do I have?

I would give SAP HANA a rating of 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
Consultant at a tech vendor with 10,001+ employees
Real User
Is stable and scalable, and certain functions have good performance
Pros and Cons
  • "Some functions have good performance."
  • "I would like more technical documentation. I would like it to be easier to find online help or have a better launch-based service. SAP has a lot of functions, so we need more best practices and more detailed documentation on industry solutions. For example, it would be good to have documentation on why a certain process needs to be set up and which kinds of configurations need to be set up."

What is most valuable?

Some functions have good performance.

What needs improvement?

I think a lot of areas need improvement. There seem to be a lot of requirements.
In Taiwan, we have a general universal invoice system in our government, and we need more support for this.

I would like more technical documentation. I would like it to be easier to find online help or have a better launch-based service.

SAP has a lot of functions, so we need more best practices and more detailed documentation on industry solutions. For example, it would be good to have documentation on why a certain process needs to be set up and which kinds of configurations need to be set up.

Before SAP HANA releases the next update, they need to run more internal tests.

For how long have I used the solution?

I've been using it since 2016.

What do I think about the stability of the solution?

The 2020 version is stable.

What do I think about the scalability of the solution?

It is scalable. We have more than 100 people using SAP HANA. Most of them are developers and consultants.

How are customer service and support?

Technical support has been more helpful than before but still need improvement.

How was the initial setup?

The initial setup proceeds better when best practices are followed. It can take more than a week to implement the system.

We have one team that handles the maintenance of the solution.

What about the implementation team?

We used an in-house team for the deployment.

What other advice do I have?

On the basis of my experience, SAP HANA is better than other solutions.

I would recommend SAP HANA, and on a scale from one to ten, I would give it a rating of eight.

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
PeerSpot user
Development & ERP Technologies Department Manager at Israel Aerospace Industries Ltd.
Real User
Very fast, good memory, and very good scalability
Pros and Cons
  • "The memory is the solution's most valuable feature. It's the main feature of HANA. Others are still the regular IT databases that are on storage and are therefore much slower than HANA. The solution is quite fast."
  • "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."

What is our primary use case?

We are primarily using the solution for the BW system of SAP. We also use the legacy reporting, which is very good.

The solution is quite fast.

How has it helped my organization?

We hoped to move all our BI systems to work with HANA, unfortunately, there are a lot of performance issues, even after remodeling the BW models.

What is most valuable?

The memory is the solution's most valuable feature. It's the main feature of HANA. Others are still the regular IT databases that are on storage and are therefore much slower than HANA. The solution is quite fast.

What needs improvement?

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.

For how long have I used the solution?

I've been using the solution for about 3 years

What do I think about the stability of the solution?

The solution is less stable than traditional databases. We have encountered several cases when the database just flows. For some reason, that database took a lot of memory, and when we opened a case with SAP, we had to send a lot of logs, which did nothing because at the end, they couldn't find the root cause for this issue. This happened in several cases. We had production down and that's not acceptable for our business.

What do I think about the scalability of the solution?

The solution is very scalable. We have about 10,000 users.

Each of those is not connecting to the database per se, but we are using HANA to take all the data and a lot of users. Several other software applications are also connecting to it.

How are customer service and technical support?

Technical support is okay, but not great. It seems like there are a lot of SAP support packages that are coming out and lots of versions. For me, this indicates that the product is not quite ready or stable enough.

We've contacted technical support in the past and did not get good results. Eventually, we just created some parameters that we have configured into the system. We solved the problem by ourselves by creating a workaround that avoided the problem. SAP never gave us a straight answer about what we should do in our case.

How was the initial setup?

The initial setup was quite complicated. We had to do a migration, so it wasn't a fresh installation. We had Oracle as our legacy system and had to move everything over to HANA. We had to do half a year of testing and had to do several cycles of tests and migrations before deploying. Once that was done, we deployed over a weekend.

What about the implementation team?

We handled the implementation ourselves.

What other advice do I have?

We use the on-premises deployment model.

I'd advise others to wait until the software will be much more stable before implementing it.

I'd rate it eight out of ten. If it was more stable and more manageable, I'd rate it higher. If people could have the ability to do things on their own within the solution, to read the software logs on their own, and get the root cause of any problem, and not just send it to the support, it would be much better.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Software Engineer - Data at a energy/utilities company with 10,001+ employees
Real User
Needs more integration capabilities and support for other programming languages but is pretty flexible
Pros and Cons
  • "Its in-memory capabilities are good, which is why many companies still use it."
  • "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)."

What is most valuable?

What is good about SAP HANA is its simplicity and its flexibility. 

Its in-memory capabilities are good, which is why many companies still use it. 

What needs improvement?

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. 

For how long have I used the solution?

While I'm not exactly sure how long the company itself has used the solution, I've been dealing with it for four years at this point. It's been a while.

What do I think about the stability of the solution?

In terms of stability, I can't comment much. It depends on the underlying system and infrastructure, and it has the same kind of stability as any other on-premise solution. It doesn't have any cloud features such as multiple replication and multiple locations, et cetera. In that sense, it has the same stability as any other on-premise solution and does not guarantee any SLA. 

What do I think about the scalability of the solution?

In terms of scalability, it's quite scalable. We've used it for production solutions very often and from any number of users. Generally, there are a few hundred users or so. I have not really worked on an implementation that uses thousands of users or anything that big, so I can't really comment on massive scaling. However, if it's for enterprise applications that have a few hundred internal users, it's good. 

How are customer service and technical support?

The community support needs to be better. I haven't been impressed with it. In general, it just needs better support.

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

I have only worked on SAP and I haven't worked on other solutions.

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

I don't have information on the pricing, as that is an SAP and corporate-level agreement, which is not really known by all the in-house teams. I'm not really aware of the pricing. On the internet, I couldn't find much information about the cost of SAP HANA. I have heard that it is an expensive option. Being an enterprise-level solution, however, I don't have exact numbers. 

What other advice do I have?

I'm not really part of the decision making team or the architecture team. I do not know if my organization has a business relationship with SAP or not.

I'd rate the solution five out of ten.

In the case of enterprise projects, I've heard that SAP HANA is used very widely. I would say, in general, it would be good to explore other alternatives, and not just go with HANA. It would be good to explore big data alternatives that are out there. They might be a better fit. Databricks these days seems to be quite popular. It might be an interesting alternative for some organizations. Depending on the use case, I'd recommend that other alternatives should be considered. If it's a reporting solution that people are building, which is using a lot of SAP internal data, then SAP HANA is a good option. Otherwise, other alternatives are out there.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
PeerSpot user
Account Executive at a tech vendor with 5,001-10,000 employees
Real User
Eases management of databases; rock solid with great functionality
Pros and Cons
  • "Eases management of databases."
  • "The user interface and CRM need to be more user-friendly."

What is our primary use case?

We use this solution for our CRM, and for our ERP, inventory, and supply chain management. It's basically used to run the majority of the company. We are customers of SAP HANA and I'm an account executive. 

What is most valuable?

SAP is great for what it does. There are likely better solutions out there but I'm not aware of them. It's a solution for big companies and in that sense it makes management of the databases much easier for higher-level people to know what's going on. 

What needs improvement?

The user interface and CRM need to be more user-friendly, it's abnormally painful. I'm a frontline user of the CRM, and it requires lots of clicks that are unnecessary. Less is more on the internet and quite often I'm clicking five, six, seven times to get where I need, and that's not effective. When an item in a certain category is not done properly, it can either lock up a system or not complete the process. We see it on a daily basis and we have to figure out a workaround to solve it. It's a technical issue that SAP's had since the beginning, and it hasn't yet been solved. With SAP everything has to be categorized. If it's not, it causes system issues and then you have to decipher the issue to try and undo it. It's an algorithm argument flaw. In the near future, I'd like to see better user interfaces and better connectors between modules.

For how long have I used the solution?

I've been using this solution for about eight years. 

What do I think about the stability of the solution?

The solution is rock stable now. We have an SAP team and five or six people fixing day-to-day issues with up to 30 people working on it all the time. There is an additional team that implements new functionalities. 

What do I think about the scalability of the solution?

It can scale infinitely. We have 12,000 users internationally and we use the product extensively. 

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

I have previously used Salesforce and I don't like it. It runs like a 1980s webpage in the current era.

How was the initial setup?

The initial setup was painful and required a lot of work. Systems would go down all the time because there were initial errors with the SAP system. but once it was up and stabilized, things were good. It still has flaws but it's a good solution as a whole. They've implemented extra modules from SAP. If you don't implement it properly you'll feel the pain. It probably took around six months to solve all the issues because SAP is so big and so integrated and so integral, it can take a while to fix the problems. You can limp along until things are solved and find workarounds, but it takes a lot of effort. SAP helped us with the implementation. 

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

SAP is expensive but it's a good solution for what it does. You're going to get a $20 answer, for a $20 product. For all the functionality it offers, the cost is worth it.

What other advice do I have?

It's important to plan and then plan again before implementing. If you don't plan properly, you will fail. The solution requires planning the implementation, making sure your company is the right size for the product. If you're an SMB, this might not be the right product for you. It might cost you more than you think. If you're enterprise size, you should look at getting into SAP, because it is the right solution. It's a solid product despite some minor issues - if SAP were to fix them it would raise the level of the solution. 

As a user, I rate the solution eight out of 10. 

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
SAP manager at Ankutsan
Real User
Top 10
Highly programmable and customizable
Pros and Cons
  • "SAP HANA's best features are its programmability and extensibility - you can size and shape the software however you need."
  • "The initial setup was very, very complex, tedious, and costly and required someone with great expertise to complete it."

What is most valuable?

SAP HANA's best features are its programmability and extensibility - you can size and shape the software however you need.

For how long have I used the solution?

I've been using SAP HANA for four years.

What do I think about the stability of the solution?

SAP HANA is very stable.

What do I think about the scalability of the solution?

SAP HANA is very scalable.

How was the initial setup?

The initial setup was very, very complex, tedious, and costly and required someone with great expertise to complete it. The deployment took two years.

What about the implementation team?

We used an external team.

What other advice do I have?

I would recommend SAP HANA to others and rate it 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
Download our free SAP HANA Report and get advice and tips from experienced pros sharing their opinions.
Updated: April 2024
Buyer's Guide
Download our free SAP HANA Report and get advice and tips from experienced pros sharing their opinions.