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.JPEGHANA the futre of databasesSAP 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,10HANA helped my company to access the data faster than everUsed 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.,,10SAP HANA - A Way Towards The FutureI 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.,9HANA -- a Panacea for performance issues.It 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.,,8SAP HANA - The best database there is !!!HANA 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,10Paradigm shift with SAP HANASAP 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 AccessFast and efficientI 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,8HANA for BW - a Good Start into HANAOur 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,7Linhardt BI strategie - powered by SAP HANAWe use HANA as database for our SAP Business Warehouse -&gt; 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,7SAP HANA ROCKS!Using 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,9Security and AdaptabilityWe 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.,,8Get SAP HANA!Currently, 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.,8Dell Integration with SAP HANAWe 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.,,7SAP HANA Review from everyday userWe 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.,10SAP HANA ReviewSAP 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.,8SAP HANA PerformsWe 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.,9SAP HANA is for you!We 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.,8SAP HANA ReviewWe 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.,6SAP HANA ReviewCurrently, 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,7Very powerful productWe 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!,,8Solved reporting problemsWe 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,9Moving on with HANAWe 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,10SAP Application on HANAAt 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 DaySAP HANA is a must haveSAP 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 CloudPros and cons from an experienced userWe 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,8
Unspecified
SAP HANA
208 Ratings
Score 8.4 out of 101
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>

SAP HANA Reviews

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
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>
Score 8.4 out of 101

Do you work for this company?

Show Filters 
Hide Filters 
Filter 209 vetted SAP HANA reviews and ratings
Clear all filters
Overall Rating
Reviewer's Company Size
Last Updated
By Topic
Industry
Department
Experience
Job Type
Role

Reviews (1-25 of 86)

Companies can't remove reviews or game the system. Here's why.
Jorge Zambrano Hernandez profile photo
Score 10 out of 10
Vetted Review
Verified User
Review Source
SAP 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.
It is recommended for companies with big landscapes and integration and needs improvement in their times.
I would not recommend this for small companies with slow growth.
Read Jorge Zambrano Hernandez's full review
Javier Pomposo profile photo
Score 10 out of 10
Vetted Review
Verified User
Review Source
Used 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
Well suited for scenarios managing a big amount of data that needs to be quickly accessible.
Read Javier Pomposo's full review
Amitkumar Shinde profile photo
Score 8 out of 10
Vetted Review
Verified User
Review Source
I 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.
When you want to fetch reporting data on real-time data, HANA comes in handy.
Read Amitkumar Shinde's full review
nagendra hamsala profile photo
Score 8 out of 10
Vetted Review
Verified User
Review Source
It 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.
Where performance is a requirement, HANA is the way to go. Also when large amounts of data is involved, HANA is able to churn it faster.
In some cases, where we have to join data from multiple sources, it was lot easier with the available functionalities and join conditions. It is not for users who are not tech savvy, having a graphical usage will be lot helpful.
Read nagendra hamsala's full review
Sanjay Mahajan profile photo
Score 10 out of 10
Vetted Review
Verified User
Review Source
HANA 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.
Well suited for all SAP applications, where application is using the database as data store. It is also well-suited where it is being used as the database directly for analytics. I cannot think of any scenario where it is less appropriate.
Read Sanjay Mahajan's full review
Rajib Mukherjee profile photo
Score 9 out of 10
Vetted Review
Verified User
Review Source
SAP 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.
I would recommend SAP HANA in scenarios where detailed analysis is key to the success of the company but the challenge arises in the enormity of the volume of the transactions. For example, performing an open AR aging analysis on percentage of completion based projects in our companies is a job that can run for hours in traditional RDBMS based databases. However, with the power of HANA, the controllers can gain access to the key figures within minutes to enable them make critical decisions and move on in-depth based analysis. The focus has shifted from run-based daily jobs to on the fly analytics to meaningful information. The power of HANA is probably less appropriate or not as advantageous in low volume enterprises where the difference in runtime of reports is indiscernible.
Read Rajib Mukherjee's full review
Venkata Harish Dunaboyina profile photo
October 13, 2019

Fast and efficient

Score 8 out of 10
Vetted Review
Verified User
Review Source
I 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.
SAP HANA is scalable and efficient.
Read Venkata Harish Dunaboyina's full review
Paul Kasparbauer profile photo
Score 9 out of 10
Vetted Review
Verified User
Review Source
We use HANA as database for our SAP Business Warehouse -> SAP BW powered by HANA.
  • database querying
  • fast speed
  • good user interface - HANA Studio
It is a perfect database for SAP BW.
Read Paul Kasparbauer's full review
Anshul Nagori profile photo
October 07, 2019

SAP HANA ROCKS!

Score 9 out of 10
Vetted Review
Verified User
Review Source
Using 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
Suited for analytics, cloud and big data. Less suited for Microsoft based workloads.
Read Anshul Nagori's full review
Purushottam Kumar profile photo
September 27, 2019

Security and Adaptability

Score 9 out of 10
Vetted Review
Verified User
Review Source
We 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.
SAP HANA has good security features and level of integration with products like Fiori and Power BI.
Read Purushottam Kumar's full review
Roland Harrison profile photo
September 27, 2019

Get SAP HANA!

Score 10 out of 10
Vetted Review
Verified User
Review Source
Currently, 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.
SAP HANA is a big tool that is great for managing lots of data. It's well suited for cloud-based organizations because the response time is so fast. It might be less well suited for smaller organizations with minimal budgets.
Read Roland Harrison's full review
Manoel Silva profile photo
Score 10 out of 10
Vetted Review
Verified User
Review Source
We use SAP HANA as a technology partner providing hardware and software certifications for SAP and customers.
  • Best performance.
  • Simplicity.
  • Reliability.
SAP HANA is well suited to being used as the persistence for S/4HANA and as the source of data for custom applications.
Read Manoel Silva's full review
Denise Carew profile photo
Score 10 out of 10
Vetted Review
Verified User
Review Source
We 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.
SAP HANA is well suited for scenarios where there is a lot of data. For smaller systems where performance is not an issue, then it is not really required.
Read Denise Carew's full review
Tanya Thao Le profile photo
September 25, 2019

SAP HANA Review

Score 7 out of 10
Vetted Review
Verified User
Review Source
SAP 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.
SAP HANA is fast and efficient. SAP HANA can handle a variety of data types and has been particularly well suited for the utility industry.
Read Tanya Thao Le's full review
Poornima Ramachandra profile photo
September 25, 2019

SAP HANA is for you!

Score 8 out of 10
Vetted Review
Verified User
Review Source
We use SAP HANA across my organization. Specifically for BI, ERP, and OTC.
  • In-memory application.
  • Enables predictive analysis.
SAP HANA is best suited for organizations using an OLTP (Online Transactional Processing) application.
Read Poornima Ramachandra's full review
Shash Reddy profile photo
September 24, 2019

SAP HANA Review

Score 9 out of 10
Vetted Review
Verified User
Review Source
We 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.
Based on my experience, SAP HANA is more suited for light weight service calls at a very high throughput which is more read-only. It is not very suitable for calls which have an insert or update with very high throughput.
Read Shash Reddy's full review
Gaurav Bajaj profile photo
September 24, 2019

Very powerful product

Score 9 out of 10
Vetted Review
Verified User
Review Source
We 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.
SAP HANA is very well suited for calculation on the fly to present reports to top management.
Read Gaurav Bajaj's full review
Mohammed Iqbal profile photo
September 24, 2019

Solved reporting problems

Score 8 out of 10
Vetted Review
Verified User
Review Source
We 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.
SAP HANA will help your business overcome challenges with reporting and analytics.
Read Mohammed Iqbal's full review
Vijay Chiruvella profile photo
September 23, 2019

Moving on with HANA

Score 10 out of 10
Vetted Review
Verified User
Review Source
We 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.
It is suitable for customers of SAP ERP's. Haven't found traction from owners of non-sap based systems yet.
Read Vijay Chiruvella's full review
Goldy Verma profile photo
Score 9 out of 10
Vetted Review
Verified User
Review Source
At 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
For analytic applications like GRC over HANA, it is a wonderful tool for real time reporting and very compatible with different UI tools like Fiori, Power BI, Lumira etc. Having HANA does not make sense if the organization is small and there is no need to get real time insight of your operational data.
Read Goldy Verma's full review
Marton Forjan profile photo
Score 10 out of 10
Vetted Review
Verified User
Review Source
SAP 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
Can't imagine a scenario without it.
Read Marton Forjan's full review
No photo available
Score 9 out of 10
Vetted Review
Verified User
Review Source
We 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.
SAP HANA is well suited when performance is essential to the business process. HANA Live can replace the need for an external BI solution if the data comes from the ECC system (not external sources). The integration of AI frameworks, as well as the AFL, can provide a competitive advantage. Coding extension on HANA XSA is a perfect alternative for non-ABAP developers to swiftly provide solutions without the baggage that comes with the ABAP stack. For us, HANA seems less suited for unstructured data. We had to move all our GOS attachments from our legacy SQL server to a content server before we migrated to SAP HANA.
Read this authenticated review

About SAP HANA

The SAP HANA® platform combines a robust database with services for creating innovative applications. According to the vendor, it enables real-time business by converging transactions and analytics on one in-memory platform. Running on premise or in the cloud, SAP HANA aims to untangle IT complexity, bringing huge savings in data management and empowering decision makers everywhere with new insight and predictive power.
Categories:  Embedded Database

SAP HANA Features

Has featureIn-memory, columnar, massively parallel database processing
Has featureFull ACID compliance
Has featureMultitenancy

SAP HANA Integrations

SAP HANA Competitors

Pricing

Does not have featureFree Trial Available?No
Does not have featureFree or Freemium Version Available?No
Does not have featurePremium Consulting/Integration Services Available?No
Entry-level set up fee?Optional

SAP HANA Technical Details

Operating Systems: Unspecified
Mobile Application:No