Try our new research platform with insights from 80,000+ expert users
reviewer1575201 - PeerSpot reviewer
Senior Engineering Manager at a tech services company with 1,001-5,000 employees
Real User
Stable, scalable, and easy to use
Pros and Cons
  • "It's easy to use, and the Hana Studio is pretty good."
  • "The JDBC connectors are very slow."

What is our primary use case?

We are solution providers. We are a supply chain organization and we deploy and supply chain solutions for our customers.

We have a host of solutions and for each of our customers based on their environments. We customize their platform and deploy it.

SAP HANA is one of our database endpoints.

What is most valuable?

It's easy to use, and the Hana Studio is pretty good.

What needs improvement?

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.

For how long have I used the solution?

My company has been using SAP HANA for ten years.

We are using the latest version.

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

What do I think about the stability of the solution?

It's a stable solution.

What do I think about the scalability of the solution?

It's a scalable solution. Because it's an on-premise infrastructure and SAP this is the best support for most of our customers, scalability is taken care of.

We are an SAP house. We have more than 1,000 people who use this solution.

How are customer service and support?

I have not interacted with the technical support. Other teams may have, but my involvement is more with the integration. 

How was the initial setup?

The initial setup was a bit complex. We were told to download it from the marketplace, but when we tried, it didn't work. We may have been doing something wrong, but we did not have a clear understanding of how it should be done. We also had difficulties with the trial version, it was not working.

There are two options:

  1. Download SAP HANA then import it
  2. Go to the marketplace and download the connector

For testing purposes, if they could provide us with clear documentation, it would be very helpful.

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

Licensing is on a yearly basis.

We are using the paid version. We pay $200 on a monthly basis.

What other advice do I have?

I am not an expert in HANA. I build the enterprise bus that integrates with SAP HANA as well as other systems. We have built our own integrated platforms.

The recommendation of this solution would depend on the use case and the requirements, and the price will be considered.

I would rate SAP HANA an eight out of 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
PeerSpot user
Technical Department Manager at Direcbusiness Technologies, Inc.
Real User
Fast performance with good dashboards and analytics, but the documentation needs improvement
Pros and Cons
  • "What I like most are the dashboards and pervasive analytics."
  • "The documentation can be improved in the future."

What is our primary use case?

We have an ongoing cloud installation but mostly, we implement on-premises.

We use this solution for SAP Business One. 

It's used mainly for analytic purposes, reporting, and the processing of large data.

What is most valuable?

What I like most are the dashboards and pervasive analytics. Those are the most useful to us.

What needs improvement?

The documentation can be improved in the future.

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

For how long have I used the solution?

I have been implementing SAP Hana for six years.

We are using the latest version.

What do I think about the stability of the solution?

It's a stable solution.

What do I think about the scalability of the solution?

SAP HANA is scalable.

We are project-based. In each project, there are anywhere from 30 to 50 users.

How are customer service and technical support?

We have not really received any technical support from SAP HANA.

I think that's also one thing that maybe SAP would be most helpful, especially if we encounter several errors during installation. We don't get to have many references or we don't get to ask the technical guys of SAP HANA.

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

Previously we were using MySQL, but due to the fast performance of SAP HANA, we switched approximately three years ago.

How was the initial setup?

In the newer versions, the initial setup is mostly straightforward. However, the older version was more complex. We had several issues with installing.

The installation usually takes approximately four hours.

There are two admins at the most to maintain this solution.

What other advice do I have?

We definitely plan to keep implementing this product in the future and I can recommend it.

I would rate this solution a seven out of 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: Implementer
PeerSpot user
Buyer's Guide
SAP HANA
November 2024
Learn what your peers think about SAP HANA. Get advice and tips from experienced pros sharing their opinions. Updated: November 2024.
824,067 professionals have used our research since 2012.
Group General Manager-ICT at a consumer goods company with 501-1,000 employees
Real User
Unmatched performance, good security, and good traceability for audits
Pros and Cons
  • "The performance in terms of processing time is unmatched due to the in-memory processing capability."
  • "The product is very demanding on memory requirements."

What is our primary use case?

We use SAP HANA as our primary database for our enterprise business. The product is centrally hosted where all our business departments access the product through its sister product SAP ERP.

The product hosts data for the deployed modules namely, Finance and Control (FICO), Materials Management (MM), Plant Maintenance (PM), Production Planning (PP), Quality Management (QM), Human Capital Management (HCM), and Sales and Distribution (SD).

It also hosts the business warehouse (BW)/BI environment.

How has it helped my organization?

The performance in terms of processing time is unmatched due to the in-memory processing capability.

The administration of the many records that were previously distributed in different systems into a central location has been made easier. All that information has been availed central from multi-locations without the requirement for manipulation using worksheets, as was the case before.

The database is also running our business warehouse and business intelligence environment, where insightful reports are generated for business management.

What is most valuable?

Security and performance are the two most valuable features. Our processing time came down to less than two hours from more than ten hours in the legacy system. We use the product to process our small-scale grower payments at the end of the month and whose daily tea deliveries records are in hundreds of thousands.

The audit trails in the HANA product are so robust that one can trace back to the tiny details of what happened at a particular time, who did it, and the time it was done. This makes auditing of both the transactions and performance of the product possible. 

What needs improvement?

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.

For how long have I used the solution?

We have been using SAP HANA for six years.

What do I think about the stability of the solution?

This is a very stable product.

What do I think about the scalability of the solution?

SAP HANA is very scalable.

How are customer service and technical support?

The customer service is excellent, whereas the technical support is not among the best but we managed.

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

We used another solution before this one and we switched due to data growth and the need for predictive management.

How was the initial setup?

The initial setup is complex.

What about the implementation team?

SAP itself assisted us with deployment.

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

Setup and licensing require planning and proper budgeting, as it is not cheap.

Which other solutions did I evaluate?

We evaluated products by Microsoft and Oracle.

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 Technical Architect at a pharma/biotech company with 1,001-5,000 employees
Real User
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. 

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
Section Head at a energy/utilities company
Real User
Offers great integration and has bettered our procurement process
Pros and Cons
  • "Integration is the most valuable feature we use SAP HANA for."
  • "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 credit cycle. I would like to see better localization from the HCM."

What is our primary use case?

We're using the on-premises deployment model.

How has it helped my organization?

This solution did improve my organization. We had some changes to better our organization, especially in the procurement process. Here in the Middle East, we have some processes that are not according to standard business processes. Through our change management processes, we had to re-change or resend our process to adapt it with SAP.

What is most valuable?

Integration is the most valuable feature we use SAP HANA for.

What needs improvement?

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.

For how long have I used the solution?

I've been using this solution for five years.

What do I think about the stability of the solution?

We are satisfied with the solution's stability.

What do I think about the scalability of the solution?

This solution is fine to scale. It converted great.

How are customer service and technical support?

We have a technical support contract with a subcontractor from SAP in the from of an SLA, a service-level agreement, divided into four categories. First, second, third, and fourth lines of support. We are satisfied with the technical support.

How was the initial setup?

It was a little bit complex in the beginning, but after gaining experience training through business structures, now it is straightforward for us. Especially, as we are building our internal team now, it is becoming easier and easier.

It took us eight months to deploy because we are running five modules. In some cases, it may take even longer than that.

What other advice do I have?

The biggest lesson learned was that we started late. We all should have started earlier.

Out of ten, I would rate this solution as eleven.

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
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
Natra Vijaya - PeerSpot reviewer
Sr. Solution Manager Consultant at Sfource AG
Real User
The technical team is very supportive and the program is stable
Pros and Cons
  • "One feature I find very valuable, is the response time of the application on the database memory."
  • "If the developers were to enhance or improve the application logic while processing the transactions, that would be great."

What is our primary use case?

I am the technical consultant at our firm and our primary use case of the solution is to manage our databases. 

What is most valuable?

We don't really use the solution for code integration purposes but one feature I find very valuable, is the response time of the application on the database memory. 

What needs improvement?

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.

For how long have I used the solution?

I have been using the solution for six years now.

What do I think about the stability of the solution?

The solution is currently very stable. We have about 80,000 people in our company's underlying database.

How are customer service and technical support?

The technical support is good and they were very helpful.

How was the initial setup?

The initial setup was complex and we had to contact the vendor a couple of times. And for the licensing part we've also had a couple of issues. We did the deployment ourselves, as a team. 

What other advice do I have?

On a scale from one to ten, I rate this solution an eight. In the future I would like to see the response time of the application being much faster than it currently is. The response time on  a task should be faster so that we don't have to wait for 10 seconds each time. 

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