SAP HANA Primary Use Case

NS
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 »
SA
Country Manager at a tech services company with 1-10 employees

We use it in order-placing and in the IBD integration, integrated business planning for forecast, and demand planning. I'm working in the sales and operation department. I'm not working in finance or production. Maybe the other teams are using it differently, or they're using different modules, however, for us at sales and operation, we are using it to place orders, developer CAST, track reports, and ensure accuracy.

View full review »
BV
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.

View full review »
Buyer's Guide
SAP HANA
November 2022
Learn what your peers think about SAP HANA. Get advice and tips from experienced pros sharing their opinions. Updated: November 2022.
655,711 professionals have used our research since 2012.
DY
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 »
RS
Head- IT 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 »
SG
Sr Regional Manager at a tech vendor with 10,001+ employees

The client is using the solution for supply chain management, and at the same time, our enterprise uses it to track the businesses' performance. The rest of our regions are going to be using SAP ECC. We are the first region to go with HANA. We were shortlisted to show them the roadmap and guide them. Supply chain management and tracking raw materials were areas of concern.

View full review »
SS
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 »
AllaShlafir - PeerSpot reviewer
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 »
IF
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 »
BM
IT Application Manager at TransBuisness

We use SAP HANA for our BW system, which is the system we use for our BI tools and BI reports.

View full review »
MB
Independent Consultant at Bosch&Cia

SAP Business One works with SQL or HANA. My experience in HANA is configuring and administrating the database. We will also use it for the virtualization of all of our machines. 

We use SAP Business One and HANA as they have the same platform and databases.

View full review »
George Mukira - PeerSpot reviewer
ICT Consultant at Spring Training & Consulting

We have used SAP HANA to do some tendering through the supplier management system. We have our own servers that are hosting the solution.

Primarily we use SAP HANA to manage suppliers, they can upload the tender documents. We are then able to do prequalification based on the preset requirements. We then know who is qualified and who is not. Additionally, it has helped us send notifications to the suppliers.

View full review »
GK
Vice President at StarTek

We use it for database virtualization.

View full review »
KK
Manager, Development, SAP Solutions at a retailer with 1,001-5,000 employees

We use this solution to custom build features. We are customers of SAP HANA and I'm a solutions manager working for a retail company in Finland. 

View full review »
VB
Sr Advisory Technical Specialist at IBM

We use SAP HANA as the source of SAP or SAP S/4HANA. We don't have a BW system in between, so we assess data from SAP HANA DB, and we use HANA data models in the HANA database and consume those into SAP.

View full review »
Kalam Basha Angadi - PeerSpot reviewer
SAP Solution Architect at a tech services company with 201-500 employees

This solution is an advanced, analytical database, which supports in-memory computing.

View full review »
FH
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 »
YS
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 »
PP
SAP Technical Architect at a pharma/biotech company with 1,001-5,000 employees

The solution is mainly for in-memory computing and past data processing, both columns or databases. It's a very good database.

View full review »
Pierre CAHAY - PeerSpot reviewer
Senior Manager at a computer software company with 10,001+ employees

We are currently using the solution for planning, sourcing, and ordering from a contract perspective.

View full review »
RS
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 »
RK
Project Manager at a logistics company with 11-50 employees

We are using this product for IAM.

View full review »
Tarun Panchal - PeerSpot reviewer
IT Manager , SAP HANA Administrator at Tara Paints & Chemicals

We are using this solution for enterprise resource planning.

View full review »
OK
Architect at Ernst & Young

I have customers who work with SAP, and I carried out performance research for them, comparing the different parameters of SAP HANA. The solution is generally used for data warehousing. 

View full review »
AA
Technical manager at SAFE-SAS

We use this solution in conjunction with other prompted solutions primarily for real-time analytics.

View full review »
Buyer's Guide
SAP HANA
November 2022
Learn what your peers think about SAP HANA. Get advice and tips from experienced pros sharing their opinions. Updated: November 2022.
655,711 professionals have used our research since 2012.