SAP HANA Tutorial for Beginners – A Quick Way to Learn SAP HANA
Welcome to the SAP HANA tutorial. This is the introductory chapter of the new age technology called SAP HANA. In our journey of learning, we will cover SAP HANA architecture, history, significance, features, scope and many more. Stay with us as we explore the world of new in-memory database technology.
So, are you excited to learn SAP HANA Tutorial? Let’s start it.
Keeping you updated with latest technology trends, Join DataFlair on Telegram
1. What is SAP HANA?
SAP HANA is an in-memory database technology encompassing various components which makes it a complete package or suite for a centralized ERP system and business application development. SAP HANA is a tool which comprises an in-memory HANA database, data modeling tools, data provisioning and HANA administration, making it a suite.
It uses real-time data processing/computing which fetches data directly from the in-memory (main memory) speeding up the data retrieval operations. This platform or tool deploy both on-cloud or on-premise aiding to the real-time analytics. Another factor which makes SAP HANA the clear winner of the race is that it uses a large main memory (RAM), and multi-core processors which makes dealing with enormous data, a smooth experience. The multi-core processing engines process data parallelly within different columns of the same database and return data to the clients in no time. This is by the virtue of a columnar or column-oriented database management system which is arranged and read in columns from top to bottom instead of rows (left to right). Using a columnar database optimizes data structure and eases storing large data by compressing it.
SAP HANA is the first technology which use for both OLTP and OLAP application processing. This means that you can use it for both transactional and analytical purposes. It is achieved by extracting data from the transactional system like ERP, then transforming the data to use for reporting and also, it offers query processing environment for both structured and unstructured data such as a relational database (tables) and less structured (texts, graphs) respectively. Thus, SAP HANA can use in many different ways like via SAP Business Warehouse, accelerators and native applications.
2. SAP HANA Features and Capabilities
In this section of SAP HANA Tutorial, we will go through all the main capabilities and features of SAP HANA in brief. We have a separate article where we discuss features of SAP HANA in detail.
- An in-memory database, column-orientated database, and parallel database processing.
- 100% ACID compliance
- Multitier storage i.e. data stores both in-memory and on disk in columnar format.
- Data modeling tools and application development tools, stored procedure.
- Comprehensive administration tools.
- Robust security and disaster recovery
- Graphs and spatial processing
- Predictive analytics and machine learning
- Wide ranged text query searching and text analytics
- Responsive web applications
- Application lifecycle management
- Data integration and replication
- Apache Hadoop and Apache Spark integration
- Remote data synchronization
3. SAP HANA Components
In this part of SAP HANA Tutorial, we will study the SAP HANA is a technology that is a collection of different tools and technologies that work in tandem to bring it in existence. There are four technologies which collectively make SAP HANA.
- DB: SAP HANA DB is the core in-memory database which central to the functioning of SAP HANA.
- Studio: SAP HANA Studio has the modeling tools for data handling and management.
- Appliance: SAP HANA software install in an appliance, which is vendor hardware.
- Application Cloud: SAP HANA Cloud is the cloud-based infrastructure ensuring the functioning of appliances.
4. SAP HANA Tutorial – History
Prior to commercialization of SAP HANA, a few other in-memory database technologies were introduced by SAP SE like the TREX search engine, P*TIME, MaxDB, etc. Then in later 2008, Mr Hasso Plattner, from SAP SE introduced the concept of SAP HANA as a real-time analytics and aggregation technology supported by an in-memory database management system. The name HANA for this SAP technology was given by former SAP SE executive Mr Vishal Sikka and it is believed to be short for “Hasso’s New Architecture”.
Officially, SAP HANA was announced in September 2011 as a support technology for SAP NetWeaver Business Warehouse. Then in the following years, SAP worked on introducing new technologies like cloud computing, enterprise cloud services, business suites, SAP ERP compatibility etc. In the year 2015, S/4 HANA was released which supported functionalities like ERP, CRM, SRM etc.
However, instead of releasing new versions of SAP HANA, SAP releases updates like service packs which are referring to as Support Package Stacks (SPS) which are released every six months. Many SPS updates were released for the first version of SAP HANA. Then, in November 2016 SAP HANA 2 (second version) was released for which the first update SAP HANA 2.0 SPS 01 came in April of 2017. However, the latest version is SAP HANA 2.0 SPS 03.
5. The Significance of SAP HANA
Ever since the advent of technology, man has been struggling to make this world a better place with the optimal technology to use. In this endeavour, innovations to make the data storage and retrieval process fast and easy have been constantly made. Earlier, data was stored in external storage disks (hard disks) and fetched by the CPU (single core) which was a very slow process involving many intermediate components like a cache. To overcome this issue, the concept of an in-memory database was introduced. In this technology, data stores in the main memory i.e. the RAM and fetch by the processing units directly from there. This makes the data retrieval process a hundred times faster than doing it from the traditional databases.
SAP HANA is a technology with in-memory database management system at its core. SAP HANA was launched for public use in 2011 and is considered to be a revolutionary technology since then, as it was a major breakthrough in database management technology due to the concept of an in-memory database. The traditional database technologies and concepts were very complex and slow, whereas the concept of an in-memory database is simple and fast. SAP HANA is not only software or hardware but is a technology which manifests itself in appliances made by combining SAP HANA compatible hardware devices and SAP HANA software. Another fact that marks the significance of SAP HANA is it’s an ability to support both transactional (OLTP) and analytical (OLAP) data applications.
The data process, transform by applying complex calculations and aggregate easily to support complex analytical queries. Thus, SAP HANA is an outstanding new age technology which supports real-time data processing and analysis which is both fast and affordable.
6. SAP HANA Tutorial – License Editions
In this section of the SAP HANA Tutorial, we will discuss the two editions of the license.
- Runtime license edition
- Full Use license edition
- Express edition
a. Runtime license edition
In this edition, you can run SAP applications like S/4 HANA and SAP BW powered by SAP HANA.
b. Full Use license edition
This edition supports both SAP and non-SAP applications. There are three sub-editions that are available under the full-use license edition.
- Base edition: This edition provides all the core database features and development tools. However, it does not support SAP applications.
- Platform edition: This edition provides the features of base edition along with features like spatial, predictive, R server integration, search, text, analytics, graph engines and additional packaged business libraries.
- Enterprise edition: This edition provides features of platform edition plus added data loading and the rule framework capabilities.
c. Express edition
This edition is a special edition with a target user base of students who can use it on laptops and other resource-limited environments with an in-memory capability up to 32GBs.
7. SAP HANA Applications
SAP HANA has a very strong customer base as they provide a wide range of applications. In this part of SAP HANA Tutorial, we have collected some applications, let’s discuss them:
- Core process accelerators
- Planning, Optimization applications
- Sense and response applications i.e. SAP HANA works as a digital core for an Internet of things (IOT).
- It is efficient in processing high volumes of both transactional and analytical data by supporting OLTP and OLAP applications respectively.
- SAP HANA works as a digital core for devices, people, big data, business networks and social networks.
8. The Scope of SAP HANA
9. SAP HANA Vendors
As we know, SAP HANA becomes a usable application by the fusion of hardware and software. The hardware is the physical components like a memory chip, processing unit, etc. which causes the concept of in-memory database management to come to reality and deliver the promised service. In the hardware, SAP HANA software installs which is call as SAP licensed appliance. So, there are many IT vendors which make hardware compatible to the functioning of SAP HANA software.
In this SAP HANA tutorial, we have listed some popular vendors of HANA:
- Lenovo (China)
According to a recent statistical analysis, IBM is a leading vendor of SAP HANA as it holds up to 70% of the market share.
This was all about SAP HANA Tutorials for beginners. Hope you liked our explanation.
This concludes our SAP HANA Tutorial. We hope by now you must have got a fair idea of the SAP HANA technology laying a foundation for understanding this technology better. In the coming lessons, we will discuss the features, advantages, limitations, functioning, and career in SAP HANA.
For any suggestions and queries related to SAP HANA Tutorial, drop your comments in the comment box below.