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.

View full review »
Managing Director at a consultancy with 51-200 employees

We are using on-premises, but I have also done some research in the last six months trying to go towards the cloud. We want to upgrade it because we also did the same thing with another company we are working with which is using the Sage X3 Cloud. We started with Sage Evolution, but now we are also moving to Save X3 Cloud.

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 »
Learn what your peers think about SAP HANA. Get advice and tips from experienced pros sharing their opinions. Updated: May 2021.
511,307 professionals have used our research since 2012.
Development & ERP Technologies Department Manager at a transportation company with 10,001+ employees

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 »
Chief Executive Officer at Redment

We primarily use SAP HANA for machine learning and deep learning.

View full review »
Group General Manager-ICT at a consumer goods company with 501-1,000 employees

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 »
Test Manager (global) at a non-tech company with 10,001+ employees

We use a hybrid deployment model for this solution. Our primary use case of SAP HANA is for business intelligence. 

View full review »
SAP Consultant at a construction company with 501-1,000 employees

We use this solution for database storage.

I am an SAP developer and consultant at my company. I examine the client's system and propose solutions that will ease their processes or make them faster. This involves programming, as well as other kinds of development.

We are using the on-premise deployment model.

View full review »
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 »
Section Head at a energy/utilities company

We're using the on-premises deployment model.

View full review »
Technical Department Manager at Direcbusiness Technologies, Inc.

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 »
Consultant Application Manager at a energy/utilities company with 5,001-10,000 employees

The deployment model used was on-premises.

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 »
SAP Technical Consultant at a tech services company with 1-10 employees

I am the technical consultant at our firm and our primary use case of the solution is to manage our databases. 

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 »
Project Manager at a logistics company with 11-50 employees

We are using this product for IAM.

View full review »
IT Manager , SAP HANA Administrator at Tara Paints & Chemicals

We are using this solution for enterprise resource planning.

View full review »
Learn what your peers think about SAP HANA. Get advice and tips from experienced pros sharing their opinions. Updated: May 2021.
511,307 professionals have used our research since 2012.