Know your gear
Enhance your purchase
SAP HANA PHYSICAL APPL DATA STRG is rated
4.30 out of
5 by
31.
Rated 5 out of
5 by
David Mbugua from
Unmatched performance, good security, and good traceability for audits
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
Disclaimer: I am a real user, and this review is based on my own experience and opinions.
Date published: 2020-11-05T00:00:00-05:00
Rated 5 out of
5 by
Nam Doan from
Has good stability and an easy setup
What needs improvement?
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.
For how long have I used the solution?
I have around 12 years of experience implementing SAP HANA.
What do I think about the stability of the solution?
It is stable.
What do I think about the scalability of the solution?
It depends on the enterprise, but the average enterprise has 20 employees. They buy two accounts to use the SAP S4HANA. It means that on average the enterprise will buy 20% to buy the license.
How are customer service and technical support?
So far technical support is good. If we have any problem that a local partner cannot resolve for the customer, they will write to SAP and support will help fix the problem.
How was the initial setup?
The initial setup is straightforward. It usually takes around eight months but it depends on a customer's requirements. We can spend a month or two customizing.
What's my experience with pricing, setup cost, and licensing?
The SAP license fee is more expensive than other solutions like Oracle or Microsoft Dynamics.
What other advice do I have?
I would rate SAP HANA a nine out of ten. Not a ten because of the price.
Disclaimer: My company has a business relationship with this vendor other than being a customer:Implementer
Date published: 2020-11-29T00:00:00-05:00
Rated 5 out of
5 by
reviewer1489158 from
Operates well, good functionality and usability
What is most valuable?
The solution operates well. I had no problems with the functionality.
What needs improvement?
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.
What other advice do I have?
I would have rated the solution higher if this version was not missing some key features the newer version has. We are going to continue to use the solution.
I rate SAP HANA an eight out of ten.
Which deployment model are you using for this solution?
On-premises
Disclaimer: I am a real user, and this review is based on my own experience and opinions.
Date published: 2021-03-01T00:00:00-05:00
Rated 5 out of
5 by
Venu Satya Kolapalli from
Flexible processing, overall great functionality, and highly scalable
What is our primary use case?
We use it for database virtualization.
What is most valuable?
The main feature is that the processes are very flexible, they are able to be adapted to the business and their departments. The solution is very good and has covered all functional areas needed in this type of solution.
What needs improvement?
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.
For how long have I used the solution?
I have been using the solution for a few months.
What do I think about the stability of the solution?
I have found the solution to be stable, it is very robust.
What do I think about the scalability of the solution?
There is the ability to scale the solution by increasing capacity with no problem, it is very flexible. We have almost 34,000 users using the solution.
How are customer service and technical support?
We had some issue with support in the past because they did not have enough availability. However, they have improved and now they are okay.
How was the initial setup?
Since we have been using the solution before we did not have any issues with the install. There were not any major complex operations. However, there were some challenges but we had the full documentation with us and it was not a problem.
What's my experience with pricing, setup cost, and licensing?
The price of the solution could be reduced, it is expensive. If they wanted to go into other industries and sectors the cost is on the higher side. They cannot go into each and every sector. If the cost was more reasonable, then it would be easy for them to enter more markets. This would be a disruptor in the industry because it would be used more often than other solutions, which would be good for the company.
What other advice do I have?
I do recommend this solution but at the same time, it is expensive. The cost will not be able to be afforded by everyone such as medium and small scale businesses.
I rate SAP HANA an eight out of ten.
Which deployment model are you using for this solution?
On-premises
Disclaimer: My company has a business relationship with this vendor other than being a customer:partner
Date published: 2021-02-28T00:00:00-05:00
Rated 5 out of
5 by
reviewer1593270 from
New technology with good stability
What is our primary use case?
We always make use of the latest version.
We like that SAP HANA is a new technology. We also like that the product is both vertically and horizontally scalable, allowing us to do around 86 percent compression of documentation from 50 to seven terabytes.
In light of the hosting cost, we find this to be very interesting. We also like the warm and cold data in respect of the solution's technology. There is a real team involved. The customer can initially utilize SAP ECC on the HANA interface and then go on S/4HANA. From this point on, doing upgrades will be very easy and smooth and the risk management will be extremely light.
What needs improvement?
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.
For how long have I used the solution?
We have been using SAP HANA for a couple of years.
What do I think about the stability of the solution?
The solution is secure and stable.
What do I think about the scalability of the solution?
As the solution allows for document compression, I would consider it scalable.
How are customer service and technical support?
We have had occasion to make use of technical support, although its level varies according to the locale of SAP's global presence.
What about the implementation team?
While I was not personally involved in the installation, my engineers were.
My deployment and maintenance team comprises around seven people, although I could not tell you which percentage of this is made up of managers, administrators and engineers.
What's my experience with pricing, setup cost, and licensing?
A monthly or yearly license must be purchased, although its utility will be based on the cost-benefit analysis that is reached by the individual customer.
What other advice do I have?
The solution is cloud based
I would recommend S/4HANA to other users.
I rate SAP HANA as a nine out of ten.
Disclaimer: I am a real user, and this review is based on my own experience and opinions.
Date published: 2021-06-08T00:00:00-04:00
Rated 5 out of
5 by
Tarun Panchal from
Easy to manage, includes reporting and analytics, but priced high
What is our primary use case?
We are using this solution for enterprise resource planning.
What is most valuable?
The solution is easy to manage enterprise resources and the reporting and analytics are including. It is good for company growth and all module are managed well.
For how long have I used the solution?
I have been using this solution for approximately five years.
What do I think about the stability of the solution?
The solution is stable. I have not had any bugs or issues.
What do I think about the scalability of the solution?
We have over 50 people using the solution in my organization.
How are customer service and technical support?
The technical support is good.
How was the initial setup?
The initial setup is straightforward.
What about the implementation team?
We used an integrator for the implementation of the solution and we were satisfied.
What's my experience with pricing, setup cost, and licensing?
The price is high and could be a bit cheaper.
What other advice do I have?
I rate SAP HANA a six out of ten.
Which deployment model are you using for this solution?
On-premises
Disclaimer: I am a real user, and this review is based on my own experience and opinions.
Date published: 2021-05-29T00:00:00-04:00
Rated 5 out of
5 by
reviewer1575201 from
Stable, scalable, and easy to use
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.
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 technical 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:
* Download SAP HANA then import it
* 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
Disclaimer: My company has a business relationship with this vendor other than being a customer:Partner
Date published: 2021-05-16T00:00:00-04:00
Rated 5 out of
5 by
reviewer1494228 from
Good reporting and analytics, but the performance and integration should be improved
What is our primary use case?
We are using this product for IAM.
How has it helped my organization?
Using this solution has given us better details for reporting and analytics.
What is most valuable?
The most valuable feature is optimization.
What needs improvement?
The performance and integration with other products are areas in need of improvement.
For how long have I used the solution?
I have been working with SAP HANA for between three and four years.
What do I think about the stability of the solution?
The stability is okay.
What do I think about the scalability of the solution?
It scales well and we have had no trouble with it.
How are customer service and technical support?
The technical support is good.
How was the initial setup?
The deployment was straightforward.
What about the implementation team?
We had assistance from an SAP partner for deployment.
What's my experience with pricing, setup cost, and licensing?
The price of this product is good.
What other advice do I have?
I would rate this solution a seven out of ten.
Which deployment model are you using for this solution?
On-premises
Disclaimer: My company has a business relationship with this vendor other than being a customer:partner
Date published: 2021-04-12T00:00:00-04:00
Rated 5 out of
5 by
reviewer1717869 from
Stable and scalable
What is our primary use case?
We work with the latest update.
We use the solution as a database. We primarily use it for the SAP application. Some of the use cases involve CDS Views, which provides a quicker processing of the report and the application.
What is most valuable?
The in-memory database is a good and valuable feature.
What needs improvement?
Since we use BW, we are required to use an SLT tool to carry out the data for generating the reports. But, when it comes to in-memory database in respect of the realtime reporting, I do not see why this report cannot be made available from the system itself. This would allow for some partitioning of the database, so that there would not be a need for the EMP in respect of the realtime data.
The initial setup was complex. I am talking about how the data is replicated to the site. We had an Oracle Database and did replication to the VR site. Yet, when it comes to HANA, we are forced to work out the method for ensuring that this replication works as it should. It is at this point that the solution becomes stable.
Technical support could be better. When we have requested this, the tendency has been to instruct us to implement a note and keep them apprised. In reality, there is no one who helps us with actual troubleshooting of the problem.
The pricing is a bit on the high side.
While I would definitely recommend the solution, I would caution that one should employ the proper resources that are geared towards the system. Unfortunately, SAP does not provide a structured training program, which means a person must rely on multiple system integrators and some service providers.
For how long have I used the solution?
We have been using SAP HANA for more than three years.
What do I think about the stability of the solution?
The stability is very good and we have encountered no issues regarding it.
The initial setup was complex. I am talking about how the data is replicated to the site. We had an Oracle Database and did replication to the VR site. Yet, when it comes to HANA, we are forced to work out the method for for ensuring that this replication works as it should. It is at this point that the solution becomes stable.
What do I think about the scalability of the solution?
The solution is easy to scale.
How are customer service and support?
Technical support could be better. When we have requested this, the tendency has been to instruct us to implement a note and keep them apprised. In reality, there is no one who helps us to actually troubleshoot the problem.
Which solution did I use previously and why did I switch?
We had already been using SAP when we switched from it to Oracle, because all of the innovations were taking place on HANA.
How was the initial setup?
The initial setup was complex. I am talking about how the data is replicated to the site. We had an Oracle database and did replication to the VR site. Yet, when it comes to HANA, we are forced to work out the method for for ensuring that this replication works as it should. It is at this point that the solution becomes stable.
The deployment lasted six months.
What about the implementation team?
We deployed with the help of a vendor.
No real maintenance is required. Data volume management is needed and all the reports are available, based on which the maintenance is easy.
What's my experience with pricing, setup cost, and licensing?
The pricing is a bit on the high side.
The use of hardware does not incur additional costs.
What other advice do I have?
There are 40,000-plus users making use of the solution in our organization.
I rate SAP HANA as an eight out of ten.
Which deployment model are you using for this solution?
On-premises
Disclaimer: I am a real user, and this review is based on my own experience and opinions.
Date published: 2021-12-13T00:00:00-05:00
Rated 5 out of
5 by
YogendraSingh from
Customizable, user friendly, and reliable
What is our primary use case?
Our primary use of SAP HANA is the use of modules, such as Material Management (MM), and Sales and Distribution (SD).
What is most valuable?
We have found the solution to be customizable and it is beneficial it comes as a bundled package. Additionally, it is user-friendly.
What needs improvement?
SAP HANA is not perfect and they could improve by having more options and more integration.
For how long have I used the solution?
I have been using SAP HANA for approximately eight years.
What do I think about the stability of the solution?
The performance of SAP HANA is very good.
What do I think about the scalability of the solution?
The solution is scalable.
We have a complete team size of approximately 12,000, including all the consulting and project managers.
We have approximately 36 end users, that directly impact the business. We might increase usage in the future but this depends on the business.
How are customer service and support?
I have contacted the technical support from SAP HANA and they are providing a complete solution to customers. I have been satisfied.
How was the initial setup?
The installation is straightforward and took approximately six months.
What about the implementation team?
We used an in-house team to do the implementation.
What's my experience with pricing, setup cost, and licensing?
We pay annually for the license of the solution.
What other advice do I have?
I rate SAP HANA a ten out of ten.
Which deployment model are you using for this solution?
Hybrid Cloud
Disclaimer: I am a real user, and this review is based on my own experience and opinions.
Date published: 2021-11-18T00:00:00-05:00
Rated 5 out of
5 by
accounte853641 from
Eases management of databases; rock solid with great functionality
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
Disclaimer: I am a real user, and this review is based on my own experience and opinions.
Date published: 2021-10-08T00:00:00-04:00
Rated 5 out of
5 by
reviewer1652946 from
Provides great in-memory computing with very efficient response times
What is our primary use case?
We are end users of SAP HANA and I'm assistant vice president of our company.
What is most valuable?
The solution's in-memory computing and the efficient response time are very good features. It's a good solution.
What needs improvement?
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.
For how long have I used the solution?
I've been using this solution for six years.
What do I think about the scalability of the solution?
The solution is scalable so if you want to increase your node capabilities, it's very easy to scale out. You just have to add the node and it gets started.
How are customer service and technical support?
The technical support people are very competent.
How was the initial setup?
The initial setup is straightforward and there were no problems with deployment.
What other advice do I have?
I recommend this solution but running SAP HANA requires deep pockets - it's costly.
I rate this solution eight out of 10.
Disclaimer: I am a real user, and this review is based on my own experience and opinions.
Date published: 2021-08-23T00:00:00-04:00
Rated 5 out of
5 by
Bruno Valentim from
Offers advanced features, helps reduce hours, and makes it easy to find what you need
What is our primary use case?
I was using the product for some research in technical drawings - in terms of making some drawings, the different parts, and the structure of the machinery. I don't know if it's available in the SAP HANA, however, there is a model for this to schedule the maintenance. The company wasn't using it. Sometimes the product furnishes a lot of insights, cultural insights that the company still is not ready to implement.
What is most valuable?
The solution offers advanced features that the company was struggling to implement. For example, in terms of parts, you can't implement a lot of structures of the machinery, however, you still need to use the codes. They're not related one to another, which makes them hard to find, typically. That means every time you need it to buy an entire assembly of parts, you need to know exactly which one you had. You have to use a drawing, a technical drawing, that specifies each code that you need. SAP saves you from asking to bring an entire assembly with a lot of parts. That's a powerful aspect that could help to reduce hours of work that are wasted in this way.
What needs improvement?
A documents preview could be helpful. Today we have a lot of documents, for example, in PDF formats, which we would like to preview. We'd even just like to click on an icon and have it open another tab. That way, I can see the document directly inside SAP HANA. In the company I was working with, we had a parallel system which meant we needed to go to SAP, see the code, see the drawing number, and then go to another system that is finished by Autodesk, and then find the drawing and open it. This is a lot of work.
I really would like to just have it inside this app.
I'd like the product to have more mobile aspects. Many younger users want mobility and flexibility.
The solution can be expensive. In Brazil, many companies still do pretty much everything in Brazil, and, if they want to try a new solution, they want to try it at zero cost. Many, therefore, will look for open-source solutions before they even consider SAP.
For how long have I used the solution?
I've used the solution over the last 12 months.
What do I think about the stability of the solution?
It's very stable. Sometimes it gets a little slow, however, that might be a company issue. When it came to the internet the entire site wasn't that good. Sometimes you had too many people connecting and the company was using a lot of Google solutions. You noticed that when a lot of people are in virtual meetings, we would have internet connections affected.
What do I think about the scalability of the solution?
I'm not sure about the scalability.
I don't know if you can use it in a Docker or if you can scale it in SQL and you can maintain the speed, or if you are talking about, for example, big data. The infrastructure of the company seemed to be weighed down, for example, when there were a lot of virtual meetings and it affected the internet. I can't speak to if this problem would also affect being able to scale the product.
How are customer service and support?
I would describe technical support as good. It's always worked for me and therefore I have no complaints.
How was the initial setup?
I didn't handle the initial implementation. The company furnished all the equipment needed for me to work. They gave me the computer, which Red Hat was installed on. They just give me access and showed me where to access what I needed and where to put the ID and password. I didn't do anything.
Typically there are six people that are available for maintenance tasks. They're IT technicians.
What's my experience with pricing, setup cost, and licensing?
SAP solutions are typically quite expensive.
What other advice do I have?
I'm a partner and consultant.
I'm not sure which version of the product I am on.
I'd advise new users that it's important to first find a solution that can understand the culture that's involved inside this solution. Sometimes people think that ERP software like SAP are magical things that you just install it and it makes life easier. It doesn't work like this. You need to have the culture, you have to have this knowledge. You need to understand how it works and how much it requires from you. It requires more than you think. It doesn't work like magic.
I'd rate the solution at a nine out of ten. It's very good, however, there's always room for improvement.
Disclaimer: My company has a business relationship with this vendor other than being a customer:Partner
Date published: 2022-01-16T00:00:00-05:00
Rated 5 out of
5 by
George Mukira from
Beneficial interactions with suppliers, reliable, and improves organization
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
Disclaimer: I am a real user, and this review is based on my own experience and opinions.
Date published: 2022-08-06T00:00:00-04:00
Rated 5 out of
5 by
Erkan Varol from
Highly programmable and customizable
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
Disclaimer: I am a real user, and this review is based on my own experience and opinions.
Date published: 2022-09-01T00:00:00-04:00
Rated 5 out of
5 by
Ahmed_Adel from
Useful for real-time analytics, but the pricing could be better
What is our primary use case?
We use this solution in conjunction with other prompted solutions primarily for real-time analytics.
What needs improvement?
The pricing on this product could be reduced, and the installation process could be more straightforward.
For how long have I used the solution?
We have been using the solution as integrators for about five years.
What do I think about the stability of the solution?
The solution is stable.
How are customer service and support?
I do not have any experience with customer service and support.
How was the initial setup?
The initial setup is not straightforward. It took us between seven and 15 days for deployment. We have over ten people using this solution in our organization.
What's my experience with pricing, setup cost, and licensing?
I am not sure about the licensing costs for this solution, but the feedback I have received is that it is expensive.
What other advice do I have?
I rate this solution an eight out of ten. It is a good product, but it is expensive.
Disclaimer: My company has a business relationship with this vendor other than being a customer:Integrator
Date published: 2022-09-08T00:00:00-04:00
Rated 5 out of
5 by
VaishnavBsa from
Has a good modeling feature and integrates well with third-party systems
What is our primary use case?
We use SAP HANA as the source of SAP or SAP S/4HANA. We don't have a BW system in between, so we assess data from SAP HANA DB, and we use HANA data models in the HANA database and consume those into SAP.
What is most valuable?
The feature I found most valuable in SAP HANA is modeling. I also like that the solution has good integration and you can integrate it with any system, even third-party systems.
What needs improvement?
Ease of use could be improved in SAP HANA. I like SAP because SAP solutions can be used by anyone, which means even laymen can start working on SAP tools, but in SAP HANA modeling, you'll need to know some other technologies and sequel scripting, and you need a separate skillset, so if you don't have the skillset, you won't be able to work on SAP HANA. Making SAP HANA low-code would make it even better.
For how long have I used the solution?
I've been using SAP HANA for two 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?
SAP HANA is a scalable solution.
How are customer service and support?
I find the technical support for SAP HANA pretty good because if you have any issues, the team responds to you very quickly.
How was the initial setup?
The initial setup for SAP HANA was straightforward. I don't have information on how long it took to deploy the solution because I wasn't in charge of the deployment.
What's my experience with pricing, setup cost, and licensing?
I have no information on SAP HANA licensing costs.
What other advice do I have?
More than three hundred people use SAP HANA within my organization.
At the moment, there's no plan to increase usage for SAP HANA.
My company does system patching every quarter, so there's no issue with maintaining the solution.
I would recommend SAP HANA to others who want to start using it.
My rating for the solution is eight out of ten.
Which deployment model are you using for this solution?
On-premises
Disclaimer: I am a real user, and this review is based on my own experience and opinions.
Date published: 2022-09-08T00:00:00-04:00
Rated 5 out of
5 by
reviewer1876326 from
Copes very well with high volumes and provides good integration
What is our primary use case?
We use this solution to custom build features. We are customers of SAP HANA and I'm a solutions manager working for a retail company in Finland.
What is most valuable?
The product handles high volumes very well and provides good integration. HANA has great databases and we're able to have a lot of custom-built features. I think this is the best solution for us given our high file volumes.
What needs improvement?
The SAP ERP processes are quite complex for us and it's a challenge. I don't like the presentation layer tools on the analytics side, it's too complex. I'd like to see a consistent analytic system as those tools and their capabilities are not easy to select. An alternative could be for them to offer the option of access to other solutions.
What do I think about the stability of the solution?
I think the solution is relatively stable but in some cases, it can depend on the service provider and their capabilities. We handle about 40 promoters, all in Finland and dealing with high volumes. Our market set is very high here.
What do I think about the scalability of the solution?
I think it is highly scalable but it comes at a financial cost. We currently have around 1,000 users.
How are customer service and support?
We use the support when we need it but we have quite good capabilities ourselves. If we're having some challenges then it can take time to have them resolved or to find the root cause of the problem. We've had some ongoing challenges that have taken quite a while to resolve.
How was the initial setup?
If you have some experience, the initial setup is quite easy.
What's my experience with pricing, setup cost, and licensing?
We are always discussing ways to optimize memory usage and hence our licensing costs. The solution is quite expensive but we also get a lot of value-added because of the high level of integration. I think it's worth the money but it's a fine balance.
What other advice do I have?
I would recommend SAP HANA solution for ERP but not necessarily for analytics. There is no other solution that can provide the value added that we get from SAP, despite the challenges.
I rate this solution nine out of 10.
Disclaimer: I am a real user, and this review is based on my own experience and opinions.
Date published: 2022-06-26T00:00:00-04:00
Rated 5 out of
5 by
Oleg Krivolapov from
Excellent in-memory database that boosts performance
What is our primary use case?
I have customers who work with SAP, and I carried out performance research for them, comparing the different parameters of SAP HANA. The solution is generally used for data warehousing.
What is most valuable?
I think the in-memory database is excellent as it boosts performance.
What needs improvement?
The product lacks some flexibility in its settings and configurations.
What do I think about the stability of the solution?
The solution is stable.
What do I think about the scalability of the solution?
The product is quite scalable.
How was the initial setup?
I don't think the initial setup is too complex. Obviously it's not easy because SAP HANA is a complex system, so it's somewhere in the middle.
What's my experience with pricing, setup cost, and licensing?
Licensing costs are quite expensive for the Ukraine but there is a range of different purchasing models so it's flexible in that sense. For a small enterprise, the costs might seem unreasonably high.
What other advice do I have?
I rate this solution eight out of 10.
Disclaimer: My company has a business relationship with this vendor other than being a customer:Partner
Date published: 2022-06-23T00:00:00-04:00
Rated 5 out of
5 by
Pierre CAHAY from
Multi-layered solution with good scalability, but lacking in feedback availability
What is our primary use case?
We are currently using the solution for planning, sourcing, and ordering from a contract perspective.
What is most valuable?
We have found that the Fiori Apps are particularly good.
What needs improvement?
I would like to see improvement on the feedback from the road-map; it is currently extremely hard to get insight in this area.
For how long have I used the solution?
I have been using this solution for four years.
What do I think about the stability of the solution?
The stability of this solution is extremely good.
What do I think about the scalability of the solution?
We have found it to be extremely scalable.
How was the initial setup?
The initial setup was complex, but this was due to the nature of the current project which is large and complex. However, for smaller projects, it has been more straightforward.
What about the implementation team?
The implementation was carried out in-house, and we also implement the solution for our customers.
What's my experience with pricing, setup cost, and licensing?
The price of licensing is dependent on the size of the project, however, we have found that there is scope to negotiate the cost.
If the solution is implemented on-premises there may be some extra costs for hosting etc.
What other advice do I have?
I would rate this solution as a seven out of ten.
Which deployment model are you using for this solution?
On-premises
Disclaimer: My company has a business relationship with this vendor other than being a customer:Partner
Date published: 2022-08-17T00:00:00-04:00
Rated 5 out of
5 by
Joseph Huang from
Is stable and scalable, and certain functions have good performance
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
Disclaimer: My company has a business relationship with this vendor other than being a customer:Partner
Date published: 2022-08-29T00:00:00-04:00
Rated 5 out of
5 by
Natra Vijaya from
Stable and good support
How has it helped my organization?
We are using SAP HANA as a single system for global solutions.
For how long have I used the solution?
I have been using SAP HANA for approximately four 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?
We have more than 3,000 users using the solution in my organization.
How are customer service and support?
The support is good from SAP HANA.
How was the initial setup?
The initial setup of SAP HANA is complex. We did the implementation of one site, and a global deployment will take another three to four years.
What about the implementation team?
We used a partner for the deployment of SAP HANA.
What other advice do I have?
The solution has been good in our use case. Everything has been operating well.
A business has to understand what processes they need to use and according to their needs, they have to activate the required configurations within the SAP HANA system.
I rate SAP HANA a nine out of ten.
Which deployment model are you using for this solution?
On-premises
Disclaimer: I am a real user, and this review is based on my own experience and opinions.
Date published: 2022-09-20T00:00:00-04:00
Rated 5 out of
5 by
reviewer1156443 from
The IBP module was the most useful followed by the FI/CO and CNMM
What is our primary use case?
The client is using the solution for supply chain management, and at the same time, our enterprise uses it to track the businesses' performance. The rest of our regions are going to be using SAP ECC. We are the first region to go with HANA. We were shortlisted to show them the roadmap and guide them. Supply chain management and tracking raw materials were areas of concern.
What is most valuable?
The IBP module was the most useful followed by the FI/CO and CNMM modules.
What needs improvement?
The product could be improved in several ways.
First, before carrying out a project with this environment size, a POC needs to be carried out, for which you would have access to various environments. And those environments are something that SAP should invest in and others should provide. That would be an improvement.
Second, some good amount of handholding, guidance, or other validation or certification from SAP at different levels.
Third, access to tools for a longer period than the pre-defined trial version license. That's something that we can ask our friends from SAP to extend or make available in a different licensing model at zero cost.
For how long have I used the solution?
I have three years of experience with the solution.
What do I think about the stability of the solution?
The solution is very stable. We would rate its stability as eight out of 10.
What do I think about the scalability of the solution?
We would rate the scalability of the solution as eight-plus on a scale of one to 10.
How was the initial setup?
The initial setup was pretty complex, considering the enormous amount of data they had from an Oracle ERP. Migration was an especially painful task, but we managed to sail through it thanks to the support of our customer. We delivered it within the timelines. We managed a few escalations. We worked with the customer. We had a weekly stand-up with the customer and various workshops and sessions to educate them and highlight the challenges.
What about the implementation team?
Implementation was completely in-house with a team of around 18 to 22 people and a couple of people from SAP, who looked at the overall program management level, providing guidance plus certifying that best practices were being followed and implemented.
The deployment, moving from Oracle to SAP HANA, took around eight months
What's my experience with pricing, setup cost, and licensing?
The customer took care of all the SAP license costs. Our scope was primarily implementation and migration support.
Which other solutions did I evaluate?
Oracle ERP had the flexibility, but it didn't have the functionality that the customer was looking for.
What other advice do I have?
We would give the product an overall rating of nine out of 10.
We have an entirely SAP family, which makes it easy to manage and support. The customer opened its first, and we are doing multiple instances of SAP ECC implementations for the rest of the small countries in APAC, the Middle East, and Africa.
Around 175 to 250 people use the solution at every level of the customer's organization.
We will be providing maintenance for the next five years.
My advice would be to explore and play with the different systems available in the market. But, ultimately, look for a system with a brand, broad user usability, and support. For instance, my customer wanted to explore an open-source ERP. We persuaded him to go with SAP, primarily because they have the expertise. They adhere to the best policies. They offer support, etc.
If you don't have all this, don't explore freebies. Go for a licensed version, recommended globally, and highly rated by Gartner or various research and consulting firms.
Which deployment model are you using for this solution?
Public Cloud
Disclaimer: My company has a business relationship with this vendor other than being a customer:Gold Partners
Date published: 2022-09-18T00:00:00-04:00
Rated 5 out of
5 by
Narasimhan Jayavel from
Reliable with good dashboards and helpful technical support
What is most valuable?
The dashboard is great.
It's user-friendly so long as you use it frequently.
The product is stable.
You can scale the solution.
Technical support has been good.
What needs improvement?
Some production features are lacking. For example, we cannot see any dashboards in the production department. The generation of reports needs to be better. We have sales reports and yet no production reports.
It's a complex initial setup.
It can be an expensive solution.
For how long have I used the solution?
I've used the solution for six years.
What do I think about the stability of the solution?
The stability is very, very good. There are no bugs or glitches. It doesn't crash or freeze.
What do I think about the scalability of the solution?
The scalability is very good. It's very capable.
How are customer service and support?
I've used technical support in the past. They are good.
Which solution did I use previously and why did I switch?
I did not use a different solution. I use what my company uses in order to get reports.
How was the initial setup?
The initial setup is difficult and complex. It's very complex compared to SQL, for example.
The initial deployment took 15 days, however, nowadays, it takes one or two days. Mostly, I can complete it in one day.
What about the implementation team?
I'm a business consultant. I do implementations for various parts of my customers' organizations.
What's my experience with pricing, setup cost, and licensing?
The licensing is typically chared yearly. It was rather expensive.
What other advice do I have?
We deploy the solution mostly on-premises and sometimes on the cloud. When we use the cloud, we usually use the AWS cloud.
I'd warn new users that it might be difficult the initial time they use it if they are changing their ERP, however,t it'll be very helpful in the future if they're using it frequently.
I'd rate the entire product an eight out of ten. There are other well-known ERPs, such as Salesforce, and companies expect to have the same features. However, not everything may be on SAP, and that's something they need to work on.
Which deployment model are you using for this solution?
On-premises
Disclaimer: My company has a business relationship with this vendor other than being a customer:partner
Date published: 2022-05-14T00:00:00-04:00
Rated 5 out of
5 by
reviewer1784415 from
Flexible solution with good integration
What is most valuable?
The most valuable features are the flexibility and the integration with other solutions in data quality.
What needs improvement?
HANA could be improved by adding analytics and development models in the institution.
For how long have I used the solution?
I've been using this solution for two or three months.
How are customer service and support?
The support is good and is available 24/7.
What other advice do I have?
I'd rate SAP HANA as nine out of ten.
Disclaimer: I am a real user, and this review is based on my own experience and opinions.
Date published: 2022-02-22T00:00:00-05:00
Rated 5 out of
5 by
Imran Hafeez from
Highly stable, plenty of features, and useful Fiori application
What is most valuable?
It is difficult for me to narrow down what the best features are in SAP HANA because they work together to provide the overall functionality of the solution. However, the Fiori application is very good.
What needs improvement?
In the Asian market, we have to customize SAP HANA to fit our needs and if we are implementing any solution from SAP or Oracle it is not recommended to customize them.
In a future release, SAP HANA should add a module for taxation, such as income tax and withholding tax.
For how long have I used the solution?
I have been using SAP HANA for a few months.
What do I think about the stability of the solution?
SAP HANA is highly stable.
What do I think about the scalability of the solution?
We have not gone live yet with the solution to determine how many people with be using it. We have some applications deployed on our CRM and others will be deployed on SAP making it difficult to determine the potential usage of the solution at this time.
What's my experience with pricing, setup cost, and licensing?
The price of SAP HANA is very expensive and it is paid annually.
Which other solutions did I evaluate?
I have evaluated other solutions from Oracle.
What other advice do I have?
I would recommend this solution to others.
I rate SAP HANA a six out of ten.
Which deployment model are you using for this solution?
Hybrid Cloud
Disclaimer: I am a real user, and this review is based on my own experience and opinions.
Date published: 2021-10-30T00:00:00-04:00
Rated 5 out of
5 by
reviewer1396107 from
A scalable and stable solution with valuable features
What is our primary use case?
We have a lot of clients from different industries, such as factories and hospitals. We have deployed it on the cloud as well as on-premises for various clients.
What is most valuable?
All features are valuable.
What needs improvement?
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.
For how long have I used the solution?
I have been using SAP HANA for several years. I have been using it since they launched the HANA database.
What do I think about the stability of the solution?
It is stable.
What do I think about the scalability of the solution?
It is scalable. We have installed SAP HANA for around 15,000 users.
How are customer service and technical support?
I would say they are average. Sometimes, they are not able to answer our questions, or their answers come very late after we have already resolved the issue. They should be more familiar with the product.
Which solution did I use previously and why did I switch?
We used our own product, which we developed on our own. After engaging SAP, we substituted our own product with SAP HANA.
How was the initial setup?
The initial setup was straightforward.
What's my experience with pricing, setup cost, and licensing?
It is expensive.
What other advice do I have?
I would recommend this solution. We plan to continue using this solution for our clients.
I would rate SAP HANA an eight out of ten.
Disclaimer: My company has a business relationship with this vendor other than being a customer:Implementer
Date published: 2020-10-31T00:00:00-04:00
Rated 5 out of
5 by
reviewer1396107 from
A feature-rich product that is easy to set up, stable, and scales well
What is our primary use case?
We are system implementers and we have many clients who use SAP HANA. Some examples of our customers are factories, hospitals, and other businesses.
What is most valuable?
This is a feature-rich product and I like all of them.
What needs improvement?
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.
For how long have I used the solution?
I have been using SAP HANA since they first launched the HANA database, several years ago.
What do I think about the stability of the solution?
This is a stable solution.
What do I think about the scalability of the solution?
SAP HANA is scalable and we have a lot of clients who use this product. We have installed it for perhaps 15,000 users, and plan to increase our client base.
How are customer service and technical support?
The technical support from SAP is medium. I'm not fully satisfied and it could be improved.
It isn't always a matter of them needing to being faster. Sometimes they cannot answer our questions, whereas other times, the answers come so late that we have already solved the problem.
Which solution did I use previously and why did I switch?
We used to implement our own product that we had developed. However, after engaging with SAP, we substituted our own product for SAP HANA.
How was the initial setup?
The initial setup was straightforward.
What about the implementation team?
We have a team of about 200 consultants who implement, deploy, and maintain solutions such as this one.
What's my experience with pricing, setup cost, and licensing?
SAP HANA is an expensive product.
What other advice do I have?
SAP HANA is a good product and I can recommend it.
I would rate this solution an eight out of ten.
Which deployment model are you using for this solution?
Hybrid Cloud
Disclaimer: My company has a business relationship with this vendor other than being a customer:Implementer
Date published: 2020-10-30T00:00:00-04:00
Rated 5 out of
5 by
Rmegio Lawag from
Fast performance with good dashboards and analytics, but the documentation needs improvement
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
Disclaimer: My company has a business relationship with this vendor other than being a customer:Implementer
Date published: 2020-11-11T00:00:00-05:00
Rated 5 out of
5 by
reviewer1386300 from
Very robust solution with good data access
What is our primary use case?
I am currently using the latest version. But before that, before I jumped into the version, I used the initial version of HANA, as well. This initial version of HANA was not that great, it had a lot of bugs. But the latest version is very good. It's excellent.
I'm afraid that HANA is not a relational database, it's a column-level database just like Sybase IQ. Sybase is also an activity product, an SAP product. SAP bought Sybase in May 2010. So normal Sybase is RDBMS. Sybase has one more variant called Sybase IQ. That is not RDBMS, that is a column-level database. Normal Sybase is a whole-level database. That's a column-level database. So SAP HANA is based on this column-level architecture.
One more thing. The success of HANA primarily depends on the RAM and the storage. HANA became a success because the cost of the solar devices has fallen down substantially. I don't know about British Pounds, but in Indian Rupees, earlier in 2007, 2008, when I was working for Microsoft, one terabyte of a SAN device, used to cost around 22.5 LAK. I would say I would have had a 100,000. I think that's the nature. So one SAN device was costing 22 LAKs. The same SAN device, in 2013 and 2014, was costing around three LAKs. So the SAN device cost reduced by more than 200%.
Also, in parallel, the RAM cost also decreased, and the technology and the fastness of RAM increased. This impacted the primary condition for RDB and RDBMSs like Oracle, Sybase, SQL Server, and the like, that they need to support the foreign key relationship, where I have a few tables. For example, if I have five to six tables, suppose the first table is employment information. The second table is employee career details or his project, something like that.
Now, instead of populating the tables with the same information, the primary condition of RDBMS was to have a foreign key relationship between these two tables and reduce the redundancy. That was a primary condition, but in HANA, thanks to the cheap storage and high-speed RAM, I may not even bother to do a redundancy of data. I can combine all the tables and make a huge table. And as an entire table, whatever its size, I can pin the table in the RAM so that my access of information is not from the hard disk, but is directly from the memory, which is much, much, much faster. That is the beauty of HANA.
What needs improvement?
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.
For how long have I used the solution?
I have roughly five years of experience in SAP HANA, because I started working on SAP ECC, on logistics and other components. After that, HANA became famous only in the years 2013 and 2014. Then I started pursuing HANA very, very actively. Right now, my journey is continuing and after five to six years I have a good amount of knowledge and experience on HANA.
What do I think about the stability of the solution?
It is stable.
What do I think about the scalability of the solution?
SAP HANA is vertically and horizontally scalable.
Our banking system uses HANA primarily for our financial transactions. There are our SAP financials running on HANA. This HANA SAP was on the Oracle database. We have migrated it. It's very, very complex and took almost one year for us to prepare the plan and migrate to HANA finance. There are around 700 to 800 users using the database and they're not facing any problem. It's fantastic.
How are customer service and technical support?
I would say I'm satisfied with technical support, buy it can be improved also. Improved in terms of data warehousing, because HANA was introduced for data warehousing and because SAP wanted to catch the OLTP market. Now they have introduced many things to attract the OLTP customers, especially in banking and telecom sectors. That's okay. You have to keep your business interests also. HANA's architecture is the foundation of the language of data, warehousing, and design. For any project or product, if it's based on data warehousing, I would say HANA is the language for that because what data warehousing wants is a data warehousing database.
Primarily, it's not an OLDP, it's OLAP, online analytics processing. And where the data is not changed, the data doesn't change as frequently as a OLTB database. For that kind of environment, I think HANA needs a lot of improvement in terms of making it more columnar. It has to incorporate up level design a little bit harder, as well.
You know MySQL database? Not Microsoft, MySQL. Microsoft is not SQL. M-Y-S-Q-L, has been bought by Oracle. Oracle bought MySQL, it acquired the MySQL company. If you look into the database, by default, MySQL engine is InnoDB. InnoDB is the default engine on MySQL. But, MySQL also gives you the flexibility of choosing your own engine. I don't want to know InnoDB, I have a huge Microsoft Excel file with around 10,000 rows, but I don't want to use InnoDB because I have to pay for that. To save those costs, at the time of starting MySQL engine, I can choose my type of data. Instead of InnoDB, I can choose Excel also. SAP HANA should give that kind of flexibility to its customers, making it more reachable to small SMEs, small and medium enterprises.
Now it is simple, because thanks to the cloud approach, it is giving a lot of flexibility to the customer, but if it wants to attack, hit the right target, acquiring the very, very small scale customer, who has around max 50 terabytes data or 100 terabyte data, a small scale company, small companies, that market should also be captured by SAP, not only the big companies. As the English saying goes, small things count. You can't ignore small things.
How was the initial setup?
The initial setup is pretty straightforward. The only thing was there were a lot of parameters which had to be taken into consideration and any parameter at installation will be paid. But one good thing about SAP HANA is even if you miss a single parameter, you cannot agree to it for the steps. The further steps will tell you that, "you have missed this step. You first complete it, then you can come here." That kind of interlinking is there. So yes, SAP installation is pretty straightforward, and very easy and smooth.
What other advice do I have?
I would recommend SAP HANA. No doubt I would definitely recommend it. But the thing is, if I adopt SAP HANA, my total cost of ownership in terms of having a functional consultant, as well as a HANA admin, would increase. I should first find a balance and analyze the data, "Do I really want to have HANA? What benefit will I have if I have HANA at my premises? And if I want to cut cost but also get the benefits of HANA, will the cloud option of HANA cater to my needs?" All those questions.
That is the company analysis I should do: what do they do differently? But many companies will be driven by the business needs, but at the same time some companies will also be driven by factors like the existing relationship with other vendors, like Oracle or SQL Server, and the kind of discounts they get when they buy that product. All those things will be there as driving factors. To answer your question, I would definitely recommend SAP HANA to anyone.
High availability and disaster recovery are very poor in HANA. High availability is measured on the barometer of RPO and RTO. RPO stands for recovery point objective, RTO stands for recovery time objective. The graph in which these two factors will be measured is from the five nines, the seven nines, or the three nines, that kind of factor. But it is a factor of my high availability. 99.9% of my database is available or 99.99999999%, giving a chance of 0.0001% for some kind of availability failure is because of natural disaster or some kind of electrical failures or something like that. So those are the factors you have to see for high availability.
My SAP HANA, technically, can withstand those calamities and recover itself from that disaster. That is called high availability. That high availability is there, but it is very, very, very minimal. If you're talking about high availability of HANA in actual high availability markets compared to Oracle and other RDBMS, HANA is a small child. If you remember when Microsoft SQL Server came into the RDBS market back in the year 1997, when they introduced the SQL 97, then they introduced the SQL 2000, SQL 2005. At that time, they introduced the high availability called Windows Cluster log shipping, mirroring the application.
At that time, in 2007 and 2008, Oracle introduced RAC, Real Application Clusters. Compared to the features of real application clusters, the Microsoft product was a small child. And Microsoft took that as a challenge and they improved and they improved. And in 2012 they introduced something called Always On. Always On is an improved...
Disclaimer: I am a real user, and this review is based on my own experience and opinions.
Date published: 2020-12-27T00:00:00-05:00
Rated 5 out of
5 by
reviewer1414206 from
Reliable, fast, stable, scalable, and innovative
What is our primary use case?
The internet of things, big data, and utilization of block chain will be possible with HANA.
What is most valuable?
It's a reliable and fast solution.
It is very stable and very innovative. You can integrate many applications with it.
What needs improvement?
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.
For how long have I used the solution?
We've been using it for three years now.
It's a cloud-based solution.
What do I think about the stability of the solution?
It is a very stable solution.
What do I think about the scalability of the solution?
It's very scalable.
How are customer service and technical support?
The technical support has been fine.
Which solution did I use previously and why did I switch?
We were running SAP on Oracle, and then we switched to HANA.
How was the initial setup?
If it's a new installation, it is straightforward. However, if it's a migration from one system to a new system, it's not as straightforward as you might think it would be.
What about the implementation team?
We utilized around 30 technical and functional staff because we were leaving our legacy system behind and migrating to a new one.
What's my experience with pricing, setup cost, and licensing?
We pay for a maintenance license, and the licensing cost is high. In general, it is a very expensive solution.
What other advice do I have?
This product covers almost everything, and it's scalable and very innovative. On a scale from one to ten, I would rate SAP HANA at nine.
Disclaimer: I am a real user, and this review is based on my own experience and opinions.
Date published: 2021-07-07T00:00:00-04:00