Our experience in SAP HANA
Updated February 25, 2015
Our experience in SAP HANA
Score 7 out of 10
Vetted Review
Verified User
Software Version
HANA 1 SP7
Modules Used
- Moduling
Overall Satisfaction with SAP HANA
We are currently using HANA for real time data warehouse reporting. Our present-day focus area is for Production management with an vision to migrate Enterprise Data Warehouse to HANA. HANA is able to solve report availability latency and gave a huge boost on the performance. How reports are available for business users in real time where in the past they have to wait a day to get the reports.
- Great performance boot. Having the data available in-memory, reports are now running 10-20X faster.
- Columnar storage provides a great degree of data compression and speed-up data aggression.
- All the data models are virtual views (Attribute, Analytical and Calculation view) so No materialize view. Gives ultimate flexibility to change the data model on the fly during development cycles with low impact.
- Still an evolving product, we are getting fix patched every 2-3 weeks’ time period.
- Like to see some enhancement on the security module. Admin can’t able to see data available under user private schema. Not able to restrict memory allocation based on user profile.
- Missing tighter integration with other database like Oracle and SQL server
- Huge performance benefit as business users have access to real time reports to make faster business decisions
- Quicker response to demand and supply changes
- Increase employee efficiency
Evaluation of the other products were not done by me.