TrustRadius
SAP HANA is an application that uses in-memory database technology to process very large amounts of real-time data from relational databases, both SAP and non-SAP, in a very short time. The in-memory computing engine allows HANA to process data stored in RAM as opposed to reading it from a disk which means that the data can be accessed in real time by the applications using HANA. The product is sold both as an appliance and as a cloud-based software solution.https://media.trustradius.com/product-logos/Kx/1h/QTQCX47ATCR4.JPEGSAPHANA the futre of databases2019-10-08T14:10:01.461ZSAP HANA it's the best way to improve performance and save space for the company while giving new possibilities for innovation.,Compress information.
High performance.
Speed in calculations.,New ways to integrate SAP and non-SAP products.
Interface access.
User experience.,10,Easy lifecycle and less re-investment.
Better times of response and agility.
Big initial investment.,BW in HANA is the greatest experience for a company to develop new ways to interpret their data.,It's the best way to integrate all sources in one place to generate transparency for costumers and compliance.,Having the agility to deploy new apps or solutions, that process the data in the company with HANA improves how the owners of the process can make changes more precisely.,Oracle Database,10Jorge Zambrano HernandezHANA helped my company to access the data faster than ever2019-10-10T12:17:19.715ZUsed globally in the company. It makes the data read faster. It solved some issues with some data collecting.,Access data faster, avoiding long waits.
Manage bigger amounts of data
Trustable and powerful system in the database,More wizards to make use of the new functionalities that Hana brings.,10,Positive impact basically, making our data reads faster.,Especially interesting when managing big amounts of data. For example, in the month closing when the users need the data fast to finish the processes. With the old system, we had some issues some times because it could take a long time to access data.,That is very important because we work with external systems like Salesforce and Service max, so the different types are always useful and many times are a must.,In this case, I am not in charge of this kind of process and have no idea.,,10Javier PomposoSAP HANA - A Way Towards The Future2019-09-25T22:59:49.614ZI have been involved in many SAP HANA implementations/migrations and upgrade for my clients and HANA. The biggest advantage is its unparalleled speed and access to data in real-time. Its architecture organizes and stores data in columns and in-memory which eliminates data copies, allows for faster loading, and uses less memory.,Database speed.
Smooth integration with reporting tools like BOBJ and Tableau.
Independent development platform.,Runs only on SAP or SUSE Linux certified hardware.,8,Dynamic decision making and edge in the competitive industry.,My client and their management are hugely benefiting by real-time reporting built on the HANA database.,SAP HANA allows data to store and process in columns as well as rows in the database. Also, many operations can be parallelly processed in SAP HANA as opposed to only a single operation processing in the traditional database for executing one query. Thus, parallel processing increases the speed of operation manifold.,In a traditional database and the technologies working with it, users can use only one of the transactional processes (OLTP and OLAP) at a time. But, in SAP HANA’s in-memory database, you can access various databases both for transactional (OLTP) and analytical (OLAP) queries parallelly at once.,9Amitkumar ShindeHANA -- a Panacea for performance issues.2019-09-25T04:41:21.494ZIt is being used to store harmonized data from multiple sources so that reporting performance is better.,Performance: a huge amount of data was churned in no time.
Modeling was better.
Merging data from multiple sources was easy through joins.,Usability for the developer.
More graphical data would be helpful.
Options to build semantics.,8,Fear of the unknown is reduced.
Licensing costs.,We have not used it with Live data. :-(,We used HANA only for relational data, and we are happy with the usage. We have not thought about other data type usages at this time.,We have not used such complex logic. We used data services for cleansing. All we did in HANA is merge the data from multiple sources.,,8nagendra hamsalaSAP HANA - The best database there is !!!2019-09-24T19:34:33.753ZHANA is being used as the databases for all of our SAP systems - SAP ECC, SAP BW, SAP BPC, and SAP Solution Manager. It is being used across the whole organization because we have all users in over 30 countries using the same SAP systems. We also have limited use of HANA as the database for Analytics ( for BOBJ).,The performance is very good. It is blindingly fast.
System administration is easy since the application and the database both are from the same vendor.
High availability and disaster recovery are particularly good due to the replication technology of SAP HANA.,Migrate all features from SAP HANA Cockpit to SAP HANA Studio soon, so customers can completely switch to Cockpit.
Alerting mechanism of HANA may be improved
Have scheduling facility for HANA backups in the tool itself such as HANA Studio or HANA cockpit, instead of going through DBACOCKPIT.,10,Positive impact due to improved productivity of users across the company.
It allows the company to innovate due to migration to HANA from legacy database.
Smaller footprint due to the HANA software innovations.,We are not using real-time analytics.,We are using as relational database only at this time.,It has not impacted.,Oracle Database,10Sanjay MahajanParadigm shift with SAP HANA2019-06-14T19:33:52.074ZSAP HANA is used as a database across the entire organization to support day to day operations in Siemens for various business divisions and product lines in the Americas. It is used as the basis to support everyday business transactions, for planning and forecasting purposes, support integrated end-to-end business and business consolidation.,SAP HANA has alleviated some long running jobs in the back-end based on a database read for critical reports to higher management.
SAP HANA has helped provide super users and controllers insights to key figures and margins in their profit centers within desired time-frame. Reports that in the past took more than 20 hours to complete now become available in less than 2 hours.
Month-end, Quarter-end and Year-end long running batch jobs have seen drastic improvements in performance. Corporate Finance and Shared Services Departments that used to have heartaches and pain points with the critical dependent jobs at month end now see the results within desired time frames.
SAP HANA has helped not only improve the performance of read access based reports but also the performance of jobs used to update the database (write-access based programs) resulting in a paradigm shift resulting in an increased leverage to perform the corrective actions as part of error handling.,SAP HANA has room for improvement in providing a user-friendly interface to help users create their own queries. Currently, the provision to create queries is controlled and could improve on the intuitive features.
The cost of the RAM is quite expensive compared to disks. Cost per bite is higher with SAP HANA.
There had been a couple occurrences where the productive system went down after the go-live. Both times, SAP folks, local IT, Global IT, Infrastructure support and network folks were involved in discussions to troubleshoot and no concrete reason was discovered. The recommendations were to increase the server size, limit the HANA view usage (to limit resource pulls) and to ensure to keep latest versions of SAP Hana in the backend. There is room for improvement in this area.,9,One of the biggest positive impacts on the implicit ROI of SAP HANA was realized in improved closed time at month end. This has provided the shared services and corporate accounting folks [the opportunity] to work closely with the business and IT to proactively perform error handling without jeopardizing the close.
Another big positive impact on ROI was realized with empowering the users to create/modify and enhance their own Fiori tiles without relying on IT.
The overall satisfaction index of the business due to the paradigm shift with upgrading to HANA was increased due to the increased performance of the backend jobs - the complex time consuming tasks were in some cases eliminated while in others improved drastically on performance driving up the business satisfaction.,Oracle Database 12c and Microsoft SQL Server,Oracle Hyperion Enterprise Performance Management, Eclipse, Microsoft AccessRajib MukherjeeFast and efficient2019-10-14T01:24:44.688ZI love SAP HANA. Its been used across the organization in few departments which upgraded their applications and few are in process of up gradation. It's fast, efficient, and productive.,Flexible.
Scalable.
Efficient.,It improved our treasury reporting with huge chunks of data every day.,8,Positive is it's fast and data became more value because of real-time.
The data quality and data value increased.,Yes, we benefited from real-time analytics because of improved transactional data and increased data value.,We use multiple types of data from multiple data sources, so it was really important for us to perform data reporting and analytics from different types of data and SAP HANA was the right solution for us here.,Of course, running complex logic in the database has improved the efficiency of retrieving the data from the database, thereby improving the speed of work and reduce the time spent on reporting.,SAP Analytics Cloud,8Venkata Harish DunaboyinaHANA for BW - a Good Start into HANA2019-10-08T14:40:29.249ZOur BW-Based reporting is Running on HANA.,Reporting.
Integration.
Future-proof.,Administration features could be improved.,10,System availability has improved.,BW extraction is now much faster.,Currently, we use only relational types-new ones on the horizon.,Pushing down "all“ the Logic is still a challenge.,MongoDB, Cassandra and PostgreSQL,7Robert ForsterLinhardt BI strategie - powered by SAP HANA2019-10-08T13:49:51.300ZWe use HANA as database for our SAP Business Warehouse -> SAP BW powered by HANA.,database querying
fast speed
good user interface - HANA Studio,The price is a bit high.,9,It's a good investment for the future.,Allows me to see real-time production KPIs.,This is less important.,BW logics can implemented faster.,Qlik Sense and Tableau Desktop,7Paul KasparbauerSAP HANA ROCKS!2019-10-07T15:51:06.183ZUsing it to develop HPE solutions for HANA around storage, backup, dr, Data tiering, also helps customers deploy these with HANA on HPE hardware.,Real time analytics
Ease of usage
Easy to learn,Too many SAP softwares to learn- software sprawl
Lack of expertise
Cloud migration and management can be made easier,9,Faster processing
Better hw resource utilization
Better reporting,Yes, my customers have. They are using data tiering with hot in memory and warm on disk. That has helped them control hw cost but keep results intact.,My customers use all data types.,Yes, modeling has helped executives understand business logic in a much easier way.,Oracle Analytics Cloud,9Anshul NagoriSecurity and Adaptability2019-09-27T14:37:12.881ZWe are using HANA across the organization for all SAP systems and data processing. It helps with faster data processing.,Faster processing of data.
Good security features.
Compatibility with products like Power BI and BOBJ.,HANA 2.0 migration has a lot of compatibility issues when migrated from HANA 1.0.
No clear guidelines on how to use existing schema and views in New HANA.,9,Security features.
The integration possibilities.
Security issues when migrating on HANA 2.0.,The Native HANA Suite gives great flexibility on integration with multiple systems using SAP SLT, SDI. Now it's one of our important systems for data reporting.,It's of significance important as we need this data support to do reporting.,,8Purushottam KumarGet SAP HANA!2019-09-27T14:22:42.889ZCurrently, our instance of SAP HANA is mainly for finance and plant maintenance.,Fast data access.
Calculation views - Combining data views and consolidating them. This is great for viewing lots of data at once.
Connectivity.,Releases were developed and released so rapidly that it made learning the platform difficult because early features were becoming obsolete as they were learned.,10,The finance team was an early adopter SAP HANA - It helped the business use a 3rd party tool that needed rapid access to a huge amount of data.,As mentioned earlier, the finance team used SAP HANA to power Spotfire, a 3rd party tool that needed rapid access to a huge amount of data. This is one example of how SAP HANA has helped my organization get things done!,Thus far we use support for relational and graph. It has been instrumental in keeping business users happy.,Not applicable yet.,8Roland HarrisonDell Integration with SAP HANA2019-09-27T13:49:16.099ZWe use SAP HANA as a technology partner providing hardware and software certifications for SAP and customers.,Best performance.
Simplicity.
Reliability.,User-interface could use some improvements.,10,It's had a positive impact on the volume of business and specialized hardware configuration it requires.,Our integration is at the hardware level and OS level, not application level,SAP HANA simplified significantly the complexity and logic of the traditional ERP.,,7Manoel SilvaSAP HANA Review from everyday user2019-09-26T00:34:07.259ZWe use SAP HANA for analytics and reporting. For a past client, we used SLT to load data into SAP for reporting. We used reporting tools like BO and Tableau. It was mainly used to report on sales. In the past, all teams were using their own spreadsheets.,Loads data quickly.
Fast results for complex queries.,User access could be more simplified. There are multiple roles defined in HANA and would be nice to have it tailored to some business roles.
Performance tuning could be more simplified.,10,My past customers all achieved significant ROI as they were able to get reports they previously were not able to get in a quick time frame. In the past, multiple reports had to be consolidated to get desired results. With HANA and designed reports based on models developed with HANA modeler we were able to deliver reports and have a single source of truth.,We have not used it for real-time analytics on live transactional data.,We worked with developers to develop models that built in the logic which was used to build reports.,10Denise CarewSAP HANA Review2019-09-26T00:23:17.625ZSAP HANA is being used for customer service in my company. As a utility company, HANA holds all of our customer data, ranging from their address to the meter they use and all the billing details.,Speed.
Efficiency.
Easy to use.,The upgrade and implementation can be cumbersome.,7,Overall, the response time has been much faster.
Less network interruption.,Yes, there are many cases where real-time analytics has helped us to troubleshoot a network outage before it happens.,In our organization, we do use SAP HANA to store PDF images of customer bills.,This feature has been used in our organization. Before, we were not able to do complex business logic, but now, we can use the complex business logic that executes very quickly.,8Tanya Thao LeSAP HANA Performs2019-09-26T00:00:12.698ZWe are using SAP HANA for all of our ERP needs. We use SAP for OTC as well as manufacturing.,System speed.
Functionality is great.
Many user options.,User Interface.
Ease of transaction.
Troubleshooting.
Integration with other systems.,8,Overhead for transactions.
High cost for a small performance boost.
All features locked behind subscriptions.,We have not yet transitioned to HANA analytics due to the complexity.,This is huge for integration with other systems. It is very important to integrate!,We have not yet used this feature. Hard to understand where the use case is for this.,9Danny HagamanSAP HANA is for you!2019-09-25T23:27:20.537ZWe use SAP HANA across my organization. Specifically for BI, ERP, and OTC.,In-memory application.
Enables predictive analysis.,License usage of HANA memory needs to be more clear.,8,HANA memory licenses can be pricey.,We have benefited by the in-memory application. We are using real-time sales data reports for our executives.,It is very important since we have various legacy systems supporting different types of data.,We have certainly benefited, especially when creating sales orders when customers are on the phone.,8Poornima RamachandraSAP HANA Review2019-09-25T00:45:53.785ZWe have been using SAP HANA as a standalone DB storing data and services running on it through an XS layer. We also use SAP HANA as backend DB for SAP ECC and SAP CAR applications.,Read access is much faster as we do not need predefined indexes which is a big help for us and improvement over using MS SQL.
Having all data in-memory improves performance drastically.
Calculation and data gathered from multiple tables as views being quick help reduce transformation and movement of data to be staged and consumed.,Inserts and updates need improvement from a performance standpoint, we haven't noticed any substantial improvements in this space compared to other DB we used earlier.
Can easily overload or exhaust the CPU on the system if not very careful how we use and fine-tune the system ahead of time, providing some out of the box controls would be a good start.
Need more quick fixes from SAP Support for HANA DB which currently takes time when we have issues in production, I believe this is because the product is still maturing compared to other products in SAP.,9,Overall our business users have been happy with the speed in day-to-day operations.
It is expensive to run SAP HANA instances compared to other DB's.
It still needs to mature as a product and has a lot of stability issues as you start using advanced functions.,Yes, we have moved to more real-time services based architecture such as inventory visibility and sales analysis as they come in.,We are using the spatial feature to calculate stores by proximity for an address. It is extremely important for us to serve our customers.,Yes, we do more of DB calculation now in more real-time. Earlier we had to transform data and stage before consumed for reporting.,6Shash ReddySAP HANA Review2019-09-25T00:39:15.864ZCurrently, our EDW is sitting on SAP HANA.,In-memory.
Realtime data.
Less data latency.,Stability.
Performance.
Data injection.,7,Faster response.
Faster data retrieval.
Less processing.,Pivotal Greenplum,7rahul singhVery powerful product2019-09-24T22:55:26.326ZWe have huge datasets that we have to work with and SAP HANA is used for SAP BW to perform some complex analytics and present reports.,Faster.
Powerful.
Complex analytics are done on the fly.,Expensive.
Build machine learning inbuilt in HANA.,9,It helps keep a tab on our profit margin by doing some complex things on the fly.,It is used by our operations team to generate some very complex reports and does so very well.,Yes, it did by reducing calculations which used to take huge amount of time to generate some reports which are highly required by top management for some crucial decision-making processes. Now it takes mere seconds!,,8Gaurav BajajSolved reporting problems2019-09-24T22:47:42.125ZWe use SAP HANA as our data mart for our analytic reporting throughout the business.,Reporting has improved and we when we used SAP HANA in memory computing it helped a lot with the performance.
Scalability.
Easy to administer.,Scalability on SAP HEC platform with VM platform.
Simplify the SAP HEC support process to many layers.
SAP Monitoring dashboards with Studio.,8,Decision making improved.,We have really benefited with SAP HANA reporting.,With SAP HANA data mart we can replicate data from multiple sources and create views, it is very helpful.,SAP Business Warehouse,9Mohammed IqbalMoving on with HANA2019-09-23T19:58:35.797ZWe use BW on HANA across the whole organization. We have vastly improved performance over the previous BI/BW implementation on Oracle.,In-Memory has improved performance of BI reporting. Less need to work with DBA's in performance tuning, partitioning, building indexes etc.,Nothing to report,10,Reduced license cost for Oracle, and Oracle DBA's.,Real-time analytics on live transaction data is not a requirement for us yet.,Multiple data type support is great, however HANA is used only for SAP based systems at this time.,It is great to be able to use Database Stored procedures to embed complex business logic.,Oracle Database,10Vijay ChiruvellaSAP Application on HANA2019-06-27T16:59:31.378ZAt our organization we are running SAP GRC on DB HANA 2.0 SP03. We are using XSA WEB IDE for creating HANA native applications for reporting and analysis purposes. HANA's in-memory calculation feature has opened new doors for performing calculations and for reporting. In XSA it is really easy to achieve isolation between different HANA applications. Thank you SAP and the team that is working on HANA.,In-memory calculation
Application isolation to enhance security
Connectivity with different UIs to present the data,HANA DB Authorization
Intra HDI Data Access
Inbuilt FLP,9,Initial investment is high but over time you get a positive ROI
High level of security in HANA's native application prevents organizations from cyber attacks
Low maintenance cost over time,Oracle Analytics Cloud Day by DayGoldy VermaSAP HANA is a must have2019-06-27T14:29:32.422ZSAP HANA was a major game changer for us. Implementing it immediately improved our processes. It is a very efficient database. Super fast and very reliable. The performance improvement is superb. I can't imagine an SAP implementation without it anymore. Implementation was a serious effort, and a sort if difficult transformation. But in return our database shrunk to a lot smaller size, a fraction of its former state. The speed increase of executing database actions, calculations, became super fast.,Speed
Simplicity
Reliability,Serious effort to switch
Hardware requirement,10,We could simplify many related processes, like recovery and safety procedures.
Using HANA DB increased our performance, hence we became way more efficient in every process.
Setting up new environments became way simpler.,,SAP Business Warehouse, SAP Analytics CloudMarton ForjanPros and cons from an experienced user2019-09-26T23:53:18.972ZWe use SAP HANA for all our SAP Business Suite servers. We use HANA Live and recently the HANA AFL SDK to enhance the DB with additional features. We are happy with the HANA Live reporting features which do away with the need of ETL.,Data on SAP HANA is compressed by a factor of 5-7 compared to SQL DB's.
SAP HANA's performance is ungodly. However, it cannot heal poorly developed custom code.
The integration of Tensorflow and other AI frameworks help to analyze the data where it is stored.
Partitioning and Hot vs. cold storage capabilities help to keep the memory consumption at a reasonable scale.,There is a bug in HANA 2.0 SP<37 which does not delete LOB data when the table is truncated or dropped.
The switch from HANA studio to Web IDE was not as smooth as expected. There are functionalities not covered in Web IDE.
The authorization concept is hard to grasp for a security admin working with Business suite previously.
If the HANA appliance reaches its memory limits the index server crashes or will try to run the garbage collector indefinitely, bringing the system to a standstill.
The sizing proofs to be a difficult exercise our system was not sized well and as a result, we are at the memory limits causing problems.,9,It is hard to quantify the effect of a DB with high performance. The end-users are happier as the results of their queries are displayed faster. Therefore the worker becomes more efficient which translates into less money spent.
We recently had severe performance problems due to a bug and out-of-memory situation. The unavailability of our digital core costs money leaving our workforce without a system.
We think that SAP HANA helps us to be prepared for future requirements which we simply could not solve with legacy SQL DB's.,We benefited from applying HANA Live and therefore replacing old reports on BI/BW. In fact, every new BI report analyzing ECC data is now developed using HANA Live. For example, a classical ABAP report took 8 hours to fill the staging table. With HANA Live we get the result almost instantaneously.,Data type support becomes more and more important. We are using ESRI GIS spatial data heavily and also recently migrated ESRI to SAP HANA in a lighthouse project. As a public service provider, it is important that spacial data is accurate and available in no time. This essentially can save lives. JSON is now the de-facto standard to exchange data with web services. It is important that a DB supports JSON natively to be able to effectively retrieve the information encoded in JSON.,Utilizing SQL script and HANA CDS views greatly reduced the need for staging tables. For data that is calculated on ABAP stack however, there is/was no option to calculate this data on the HANA layer, e.g. conversion exits for functional locations or long texts. For this, we had to make use of the SAP HANA AFL SDK (not to confuse with the PAL). Writing HANA extensions is very time consuming and can destabilize the index server. In other cases, we greatly benefit from having direct access to the ECC tables for reporting which reduces the need for a BI/BW system for data on ECC. This effectively makes ETL obsolete and is a huge cost saver plus it safeguards that the data is always accurate as it comes from one source table.,Microsoft SQL Server,8Verified User
Unspecified
SAP HANA
208 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
