SAP HANA Primary Use Case
Database Consultant at a pharma/biotech company
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.
Owner at LAVORO AUTOM INF E COM LTDA
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.
Account Executive at a tech vendor with 5,001-10,000 employees
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.View full review »
Vice President at a energy/utilities company with 5,001-10,000 employees
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.View full review »
Senior Engineering Manager at a tech services company with 1,001-5,000 employees
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.View full review »
We are primarily using the solution for the BW system of SAP. We also use the legacy reporting, which is very good.
The solution is quite fast.View full review »
CEO at a tech services company with 51-200 employees
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.View full review »
Head IT at a healthcare company with 51-200 employees
We primarily use the solution as a kind-of database for our workloads.View full review »
We primarily use SAP HANA for machine learning and deep learning.View full review »
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.View full review »
Venu Satya Kolapalli
Vice President at StarTek
We use it for database virtualization.View full review »
CEO at a financial services firm with 1,001-5,000 employees
We are system implementers and we have many clients who use SAP HANA. Some examples of our customers are factories, hospitals, and other businesses.View full review »
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.View full review »
SAP Basis Consultant at a energy/utilities company with 1,001-5,000 employees
The internet of things, big data, and utilization of block chain will be possible with HANA.View full review »
Process Mining Data Scientist (CELONIS) at a consumer goods company with 10,001+ employees
We're writing SQL queries for the verification process, and we're using SAP master tables for tables. We write huge queries for processing data.View full review »
CEO at a financial services firm with 1,001-5,000 employees
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.View full review »
Head-IT/SAP at Barista Coffee Company Ltd.
Our primary use of SAP HANA is the use of modules, such as Material Management (MM), and Sales and Distribution (SD).View full review »
Assistant Vice President at a energy/utilities company with 10,001+ employees
We are end users of SAP HANA and I'm assistant vice president of our company.View full review »
Project Manager at a logistics company with 11-50 employees
We are using this product for IAM.View full review »
We are using this solution for enterprise resource planning.View full review »