Our guide is a primer and introduction to the lengthier “SAP HANA Administration Guide” official document. You can follow our link to the latest version of this document online. As you will see, the official guide is over a thousand pages long and details the concepts and main tasks you will need to know regarding the ongoing operation of your in-memory platform.
Note that because the SAP HANA administration guide does not cover either the options or capabilities of the database, our guide will not go into detail on these topics. This guide will give you an introduction to the main points of each section in the official guide, provide some examples of the tasks in these sections, and explain why they are important. Beginners may find this primer useful as a lead-in to the longer guide.
Section 1: SAP HANA Architecture
You will learn about the complexities of SAP HANA’s architecture from your coursework or the longer guide. For the purposes of our primer, you should know that SAP HANA’s core architecture relates to the in-memory database system itself. This architecture uses your company’s existing hardware to increase the data computing performance and reduce your costs.
The main parts of any SAP HANA architecture are the servers. Although the index and name servers are the most important, we will cover all the servers here briefly.
SAP HANA’s Index Server contains all the data you will use and the components that will perform high-level processing of the data you need. Along with the Name Server, it is the most important part of the architecture.
This server contains the system’s topology and essentially owns all the information in it. It knows where the data is stored and which processes are analyzing or using that data.
This part of the server analyzes the data searches you perform. Other parts of the architecture use the preprocessor to extract and collate data from your searches.
This server may help you analyze the data the in-memory platform is using and convert it into actions that increase productivity or reduce lag time between data queries.
Please note that this is a brief overview of the SAP HANA Administration Guide’s section on architecture. The official document will provide further details on multi-host systems and database containers.
Section 2: Administration Tools
Within the SAP HANA Guide is a specific section on the administrative tools to which you may have access once you set up SAP on your system. The two primary tools that you might use are SAP HANA’s Cockpit and the SAP HANA Studio.
SAP HANA Cockpit
The Cockpit is one of the main tools you may wish to use to manage your system. You can access it via your preferred web browser or in offline mode if necessary. SAP HANA Cockpit arranges the content of tiles that you can use to start applications or view data. Please note that you must enable either “Monitoring” or “Administrator” roles to open or access the Cockpit and its contents.
You can use the two URLs below to access a single-container system within the Cockpit:
You will need the name and instance number of your SAP HANA system to complete this action.
If you need to start the Cockpit in offline mode, you can do so using these steps:
- Access the “admuser” operating system credentials you created when you installed it.
- Open Port 1129.
- Navigate your web browser to this link.
The main purposes of SAP HANA Studio are to allow clients to access local or remote systems and to allow developers to modify data sets or create users and authorization levels.
Section 3: Administration of the System
This section of the SAP HANA Administration Guide begins to touch on just how you can use the architecture and the tools we have mentioned to control processes within the database. You’ll learn how to create, monitor, and expand databases, start and stop them as necessary, configure system files, and diagnose errors that occur when the system has problems.
You will learn how to use either the Cockpit or the Studio to start the services your database will use. Each of the tools uses a slightly different process and may require different administrative permissions before you are allowed to start the services. Once you’ve fulfilled the requirements, each service will start one by one.
Section 4: Lifecycle Management
This section will cover two primary aspects that we will detail briefly in the subsections below.
Managing the SAP platform lifecycle at an administrative level allows you to perform tasks such as the addition or removal of hosts, registration, and configuration of the landscape directory, renaming or reconfiguring the system itself, or establishing inter-service communications.
SAP HANA is able to offer you support during all stages of an application’s lifecycle. You can use these tools to alter how you model the product, how it changes as you develop it, or even to manage aspects of assembly and transport of the finished product. If you are an administrator, you will use lifecycle management tools to install or update products or add-ons in SAP HANA.
More Resources for the SAP HANA Enthusiasts:
Section 5: Security Administration
While this is one of the most critical tasks for SAP HANA users, it is also relatively easy to understand compared to some of the other sections in the official guide. This area will go over the status of all the critical security settings within your database, how to monitor them using SAP Cockpit, and the details of the security surrounding your company’s network. The most important aspects of SAP HANA security involve creating and provisioning users with specific access to only the data sets they need.
Section 6: Availability and Scalability
This section of the SAP HANA Administration Guide is mostly conceptual in nature. It deals with backup and recovery of data, system scalability, and high availability. A system that has high availability uses a set of techniques and practices to ensure continuity in a business model and make sure data sets are available to developers whenever they need them.
Section 7: Maintaining the Environment
This section of SAP HANA’s Administration Guide details how you can oversee the various components in the run-time environment. It is important for you to be able to set up and support various applications in real-time as the need arises. You’ll be able to do this using either the classic or advanced models of the HANA XS systems.
Section 8: Data Provisioning
You can use this section to learn how to get data into your in-memory database. Data provisioning covers accessing data, setting up drivers, creating tables and statistics. Plus, this section talks about managing connections and integrating or replicating the data you’re using.
Section 9: HDBSQL
The final section of the guide gives you details on how to access the command prompt within SAP HANA, helps you learn what commands you can use, how to run them, and how to interpret the responses the database gives you.
Indeed, the SAP HANA Administration Guide is massive. However, our primer here should help you get through each section. You should be able to understand the main points each part of the guide is trying to teach you. We’ve selected examples straight from the official source guide at SAP HANA’s own help portal. Thus, we wanted to make sure you’re on the right track.