SAP HANA Studio is an Eclipse-based tool. SAP HANA Studio is both, the central development environment and the main administration tool for HANA system. Additional features are −

It is a client tool, which can be used to access local or remote HANA system.
It provides an environment for HANA Administration, HANA Information Modeling, and Data Provisioning in HANA database.

There are various administration tasks that can be performed using SAP HANA Studio −

To start and stop service
To perform monitoring of SAP HANA system
To perform user management and authorization
To perform backup and recovery
To perform Audit policy and Security configuration
To perform license management
To perform other configurations in HANA system
To perform SQL development tasks – HANA Information Models, SQL Stored Procedures

In SAP HANA Studio, you will find a long list of perspectives, which can be considered as separate tools in HANA Studio. All these perspectives can be used for performing various administrative tasks, system monitoring, and data provisioning.

To see list of all Perspectives in HANA Studio, navigate to Window tab → Perspective → Open Perspective → Other.

SAP 1 4

When you click on “Other…”, it will open the list of all the perspectives that can be used to manage and perform system administration.

SAP 2 1

SAP HANA Administration Console in HANA Studio

Using this feature, you can open HANA database administration and monitoring features in HANA Studio. By default, it opens in System View.

To open SAP HANA Administration, you can select SAP HANA Administration Console Perspective default option. You can also access it via Administration button at the top.

SAP 3 1

When you click the Administration button as shown in the following screenshot, it opens SAP HANA Administration Console. The console contains all database administration and monitoring features of the SAP HANA studio.

SAP 4 1

Following tabs are available under SAP HANA Administration Console −

Overview
Landscape
Alerts
Performance
Volumes
Configuration
System Information
Diagnosis Files
Trace Configuration

These tabs are used to perform monitoring and administration tasks in your SAP HANA system.

Adding a System in HANA Studio

Single or multiple systems can be added to HANA Studio for administration and information modeling purposes. To add new HANA system, host name, instance number and database user name and password is required.

Port 3615 should be open to connect to Database
Port 31015 Instance No 10
Port 30015 Instance No 00
SSh port should also be open

Following are the steps to add a system to HANA Studio.

Step 1 − Right-click the Navigator space and click Add System. Enter HANA system details, i.e. Host name & Instance number and click Next.

SAP 5 1

Step 2 − Enter Database user name and password to connect to SAP HANA database. Click Next and then Finish.

SAP 6

Once you click on Finish, HANA system will be added to System View for administration and modeling purposes. You can see the hierarchical structure of HANA system under HANA Studio.

SAP 7

Each HANA system has two main sub-nodes, Catalog and Content.

Catalog Tab − It contains all available Schemas, i.e. all data structures, tables and data, column views, procedures that can be used in the Content tab.

Content Tab − The Content tab contains design time repository, which holds all information of data models created with the HANA Modeler. These models are organized in Packages. The content node provides different views on the same physical data.

SAP 8

Executing SQL Statements in SAP HANA Studio

SQL Console can be opened by selecting the Schema name, in which, a new table has to be created using System View SQL Editor option or by a right-clicking the Schema name as shown in the following screenshot.

SAP 9

Once SQL Editor is opened, Schema name can be confirmed from the name written on the top of SQL Editor. You can create database objects using SQL statement.

To create a table −

Create column Table Test1 (
ID INTEGER,
NAME VARCHAR(10),
PRIMARY KEY (ID)
);

In this SQL statement, we have created a Column table “Test1”, defined data types of the table and the Primary Key.

Once you write Create table SQL query, click the Execute option on top of SQL editor on the right side of the screen. Once the statement is executed, we will get a confirmation message as follows −

Statement ‘Create column Table Test1 (ID INTEGER,NAME VARCHAR(10), PRIMARY KEY (ID))’ successfully executed in 13 ms 761 μs (server processing time: 12 ms 979 μs) − Rows Affected: 0

SAP 10

Insert statement is used to enter the data in the Table using SQL editor.

Insert into TEST1 Values (1,'ABCD')
Insert into TEST1 Values (2,'EFGH');

Click Execute.

You can right-click the Table name and use Open Data Definition to see the data type of the table. Open Data Preview/Open Content to see the table contents.

Using Log Off /Log On in SAP HANA Studio

Using SAP HANA Studio, you can also log off from a SAP HANA system and end all the connections. To login to HANA system again, click Logon.

To logoff from a system, right-click the System name in HANA Studio → Log Off.

SAP 11

To login again, right-click on HANA system in System Pane → Log On. You will be prompted to enter the password. Enter the password and click OK. You will be logged in to HANA system under HANA Studio. You can view all the folders and objects in HANA system.

SAP 122

You can also define the user logon behavior in SAP HANA Studio startup. It allows you to save the password for the users when HANA Studio or other user settings is open.

Go to Preferences → SAP HANA → Global Settings.

SAP 133 1

If you wish automatic logon takes place when the Studio is started and also to allow explicit logon when HANA studio starts, uncheck the first option.

SAP 14

SAP HANA Admin – System Management

When SAP HANA system is installed, there are various components that get installed with HANA system. It includes −

Mandatory Components of SAP HANA −

SAP HANA Server
SAP HANA Client system

Additional Components −

SAP HANA Studio
SAP HANA Smart Data Access SDA
SAP HANA XS Runtime environment
SAP Live Cache Applications

When the installation is complete, you may need to perform various tasks in SAP HANA system, such as −

Backup and Recovery Management
User Management
Starting HANA System
Stopping HANA System
License Keys
System INI Files
Monitoring HANA System
Data Replication using SMART data access
SAP HANA integration with BusinessObjects Reporting environment

These tasks can be performed using various SAP HANA admin tools. Most common tools to perform SAP HANA system management – HANA Cockpit, SAP HANA Studio.

So, this brings us to the end of blog. This Tecklearn ‘SAP HANA Admin Studio and System Management’ blog helps you with commonly asked questions if you are looking out for a job in SAP Hana Administration and SAP Domain. If you wish to learn SAP Hana Administration and build a career in SAP domain, then check out our interactive, SAP HANA Administration Training, that comes with 24*7 support to guide you throughout your learning period. Please find the link for course details:

https://www.tecklearn.com/course/sap-hana-administraion/

SAP HANA Administration Training

About the Course

SAP HANA Administration training will help you learn SAP HANA administration tools, security and user management, system management and availability, data provisioning and integration with non-SAP systems and more. You will deploy SAP HANA Studio, automate through OS scripts, command line admin tools through hands-on projects and case studies. This course is designed to clear the HA200 SAP HANA Operations and Administration Certification conducted by SAP and helps you get the best jobs in top MNCs.

Why Should you take SAP HANA Administration Training?

The average salary for SAP HANA Database Administrator ranges from approximately $65,843 yearly for Administrator to $143,051 yearly for Enterprise Architect. – Indeed.com
SAP HANA is one of the top tools for working with real-time data due to the transformational nature of this tool. The role of an SAP HANA Administration and Operations personnel is critical of the success of SAP HANA deployment in any industrial set-up.
Worldwide Business Intelligence and Analytics Market to grow to $22.8 billion in next 2 years – Gartner.

What you will Learn in this Course?

Overview of SAP HANA

Overview of SAP HANA
Features and Benefits of SAP HANA
SAP HANA Components
Concept of SAP HANA guides
Scenarios in SAP HANA Administration

Architecture of SAP HANA

What is SAP HANA persistence?
Concept of Sizing in SAP HANA
Process of achieving scale out in SAP HANA
How SAP HANA achieves in-memory computation
Concept of columnar database
How SAP HANA is so fast with comparison to other tools

SAP HANA installation

Overview of SAP HANA tools

SAPA HANA Studio for Administration activities in SAP HANA
Accessing local and remote HANA systems using Client Tool
Monitor, Control, Configure and Administer the SAP HANA database using DBA Cockpit
Using HANA Studio Information modelling and data provisioning in HANA database
SAP HANA Transport

SAP HANA Operations

Privileges in HANA
Configure Password Policy and create user in SAP HANA
Auditing in SAP HANA

SAP HANA Smart Data Access

Data Provisioning in SAP HANA

Leveraging SAP HANA technology and integration architecture for enriching, cleansing and transforming data from disparate sources
Data replication with the SAP Landscape Transformation (SLT)
Implementing SLT Configuration with SUSPEND LOAD

SAP HANA Operations

Create Repository and Job Server
SAP GRC Architecture

Administration Operations in HANA Studio

Updating HANA database using lifecycle management
Security in SAP HANA
Sessions and Transactions in SAP HANA
Configure System Replication using HANA Cockpit

Migration to SAP HANA using DMO

Performance Monitoring and Analysis in SAP HANA

Got a question for us? Please mention it in the comments section and we will get back to you.

546