How to Download & Install SAP HANA Studio

⚡ Smart Summary

SAP HANA Studio is an Eclipse-based integrated development environment for the administration and modeling of the SAP HANA Database. It supports installation across Windows, Linux, and Mac, and connects local or remote HANA systems.

🔘 Setup Path: Default installation directories include C:\Program Files\sap\hdbstudio on Windows, /user/sap/hdbstudio on Linux, and /Applications/sap/hdbstudio.app on Mac.
☑️ Pre-Requisites: SAP HANA Studio requires a JVM and the SAP HANA Client, which enables external applications and databases to communicate with HANA.
✅ Perspectives: Administration Console, Modeler, Development, and Lifecycle Management perspectives organize tasks for monitoring, modeling, application coding, and software updates.
🧪 Add System: Use the Add System icon with host name, instance number, and database credentials to establish a connection from SAP HANA Studio to the HANA Database.
🛠️ Administration: Catalog, Provisioning, Content, and Security nodes manage schemas, virtual tables, information views, users, roles, and privileges within the HANA environment.

What is SAP HANA Studio?

SAP HANA Studio is an Eclipse-based integrated development environment (IDE) used for the development and administration of the SAP HANA Database in the form of a GUI tool.

SAP HANA Studio runs on a client or developer machine and connects to the SAP HANA Server. SAP HANA Studio can access a local or remote SAP HANA Database.

By using SAP HANA Studio, you can do the following:

Enable users to manage the SAP HANA Database.
Create and manage user authorizations.
Create new or modify existing data models.

Pre-Requisite for SAP HANA Studio

Supported Platform

SAP HANA Studio runs on the following platforms:

Microsoft Windows x32 and x64 versions:

Windows XP
Windows Vista
Windows 7
Windows 8

SUSE Linux Enterprise Server: x86 64-bit version, Red Hat Enterprise Linux (6.5).
Mac OS 10.9 or higher.

System Requirement

JAVA JVM: During installation and updates of SAP HANA Studio, a JVM is installed or updated.
SAP HANA Client: This software allows you to connect to another database or application.
- The SAP HANA Client can be installed on Unix or Linux, on Microsoft Windows, and on the SAP HANA Server host during server installation. The SAP HANA Client is installed separately from SAP HANA Studio.

Download & Install SAP HANA Studio

Installation Path

The default installation system path according to the operating system and its version is as follows:

Microsoft Windows (32 & 64-bit): C:\Program Files\sap\hdbstudio.
Linux x86, 64-bit: /user/sap/hdbstudio.
Mac OS, 64-bit: /Applications/sap/hdbstudio.app.

Software Download

You can download SAP HANA Studio and SAP HANA Client from here.

Select the file to download according to your operating system:

Installation on Microsoft Windows

Install SAP HANA Studio in the default directory with administrator privileges, or in the user home folder without administrator privileges.

Click on hdbsetup.exe to install SAP HANA Studio.

A SAP HANA Lifecycle Management screen appears.

The default installation folder is C:/Program Files/SAP/hdbstudio.

Step 1) Define Studio Properties.

Select Install new SAP HANA Studio.
Click the button.

The Select Features screen appears as below.

Step 2) Select Features.

The Select Features screen is used to select features.
Select features as below:

SAP HANA Studio Administration: Toolset for various administration tasks, excluding Transport.
SAP HANA Studio Application Development: Toolset for developing SAP HANA native applications (XS and UI5 tools excluding SAPUI5).
SAP HANA Studio Database Development: Toolset for content development.

Click the button.

Step 3) Review and Confirm.

The Review & Confirm screen appears.
A summary of the SAP HANA Studio installation is displayed.
Click the button.

Step 4 & 5) Install Software and Finish.

The installation progress screen appears, and afterward the wizard moves to the finish page.
A message appears: “You have successfully installed the SAP HANA Studio”.
Click the button.

Run SAP HANA Studio

Now, go to the default installation folder, which is “C:/Program Files/SAP/hdbstudio”.

There is an hdbstudio.exe file. By right-clicking on it, you can create a shortcut on the desktop.

When you click the “hdbstudio.exe” file, it opens the Workspace Launcher screen displayed below.

The workspace is selected by default. You can change the workspace location with the Browse option. The workspace is used to store studio configuration settings and development artifacts.
Select “Use this as the default and do not ask again” to prevent this screen from appearing every time for workspace selection when you open SAP HANA Studio.
Click the button.

The SAP HANA Studio Welcome screen appears.

The Welcome screen displays different perspectives. The details of each perspective are as follows:

1. Administration Console Perspective

This screen is used to configure, administer, and monitor the SAP HANA Database. Several views and editors are available in the SAP HANA Administration Console.

The System View Toolbar is used for administration. It looks like the image below:

Below is a table showing system-level editors and views available in the SAP HANA Administration Console.

View/ Editors	Detail	Path
Systems	The System view provides a hierarchical view of all SAP HANA Systems managed in SAP HANA Studio along with their contents (catalog, content, etc.).	Window-> Show View -> System
System Monitor	System Monitor is an editor that provides an overview of all SAP HANA Databases in one screenshot. You can see the details of an individual system in System Monitor by drilling down.	Button on System View Toolbar.
Administration	This is used for performing administration and monitoring tasks.	1. From the System Toolbar. 2. By double-clicking on the System.
Administration Diagnosis Mode	This editor is used in case of emergency to monitor and perform operations on the system when either no SQL connection is available or the SQL connection is overloaded.	1. From the Administration tool list icon. 2. Ctrl+Shift+O
Backup	Used for performing backup and administration.	Expand the system and choose Backup.
Security	This editor is used for managing the following topics: 1. Password Policy 2. Data Volume Encryption	Security option from the Security views of the system.
SQL Console	Used for entering, executing, and analyzing SQL statements in the SQL Console.	From the System Toolbar, choose SQL.

2. Modeler Perspective

This perspective is used to create modeling objects and manage database objects in the SAP HANA System. Modelers use this perspective for the following activities:

Create or modify Tables, Functions, Indexes, Views, Sequences, Synonyms, and Triggers.
Create modeling objects such as Attribute View, Analytic View, Calculation View, Analytic Privileges, Procedures, and Decision Table.
Provision data to the SAP HANA Database from SAP or non-SAP sources through SLT, BODS, or DXC.

3. Development Perspective

This perspective is used to develop applications on HANA for the web environment. In this perspective, programming languages such as Java Script, jQuery, and OData are used.

Lifecycle Management Perspective

This screen is used to install and update software related to the SAP HANA Database and SAP HANA Studio. Lifecycle Management is also used to transport an object from one HANA system to another HANA system.

Add System in SAP HANA Studio

To work with the SAP HANA Database, a user needs to be connected to the SAP HANA Database from SAP HANA Studio. So you build a connection to the SAP HANA Database as below.

Step 1) Click the “Add System” icon from the System Toolbar as below.

Step 2) Provide the following details as below.

Host Name: Enter the SAP HANA Database host here.
Instance Number: Two-digit instance number.
Description: A description of the system for better understanding.
Click the button.

A connection properties screen appears in which you need to enter the SAP HANA Database user and password.

Enter the username and password for the SAP HANA Database to access it from SAP HANA Studio.
Click the button. If there is no error, the connection is successful, and the system name is added in SAP HANA Studio under the System node.

Work With SAP HANA Studio

To log in to the SAP HANA Database through SAP HANA Studio, follow the steps below.

Click on the added system, here “DB (HANAUSER)”.
A popup screen for username and password appears. Enter the username and password for the HANA Database.
Click the OK button.

After logging in to SAP HANA Studio, you will see the screen below for the selected HANA System.

In HANA Studio, under the HANA System, the following sub-nodes exist:

Catalog

The SAP HANA Studio Catalog node represents the SAP HANA data dictionary, where database objects (Table, View, Procedure, Index, Trigger, Synonym, etc.) are stored in the Schema folder. When a user is created in SAP HANA, a schema of the same name is created in the SAP HANA Database by default. This is the default schema of the user when the user creates any database object. A schema is used to group database objects.

A schema defines a container that holds database objects such as Tables, Views, Triggers, Procedures, Sequences, Functions, Indexes, and Synonyms.

A schema can be created in the SQL Editor with the following SQL.

CREATE SCHEMA "SCHEMA_NAME" OWNED BY "USERNAME".

Here, “SCHEMA_NAME” and “USERNAME” should be changed according to your requirement. After refreshing the Catalog node, the newly created schema will be displayed.

I have created the schema “DHK_SCHEMA” by the SQL above.

All database objects are stored in the respective folder of the schema as below.

Provisioning

Provisioning is used for selecting source metadata and importing metadata and data into SAP HANA.

There are two categories of provisioning:

SAP HANA in-built tools (Flat file, Smart Data Access, Smart Data Streaming, etc.).
External tools (SLT, BODS, DXC, etc.).

In the SAP HANA Studio Provisioning node, SAP uses a new feature called “Smart Data Access”, which is a built-in tool.

Smart Data Access combines data from heterogeneous data sources such as Hadoop, Teradata, Oracle, and Sybase.

Data from different sources is stored in the SAP HANA Database as a “Virtual Table”. The restriction with virtual tables is that they can only be used to build calculation views in SAP HANA.

Content

The Content node is a design-time repository that holds all information about data models within packages. All information views, such as Attribute View, Analytic View, and Calculation View, are created inside packages under the Content node.

A package is used to group related information objects in a structured way. A package can be created by right-clicking on the Content node and selecting New->Package.

Security

The Security node in SAP HANA Studio contains 3 sub-nodes:

Security: Used to create User Audit Policy, Password Policy, etc.
Users: Used to create, modify, or delete users. Roles and privileges are also granted to users from this screen.
Roles: Used to create, modify, or delete roles. Privileges are added or deleted from here for each role.

FAQs

SAP HANA Studio runs on Windows (XP, Vista, 7, 8), SUSE Linux Enterprise Server x86 64-bit, Red Hat Enterprise Linux 6.5, and Mac OS 10.9 or higher. It also requires a JVM and the SAP HANA Client to operate.

SAP HANA Studio offers four key perspectives: Administration Console for monitoring and configuration, Modeler for creating data models, Development for building HANA applications, and Lifecycle Management for installing, updating, and transporting software between HANA systems.

Yes. AI coding assistants help generate SQLScript, design calculation views, debug procedures, and write CDS artifacts. They explain syntax errors, suggest optimizations, and accelerate modeling tasks, making SAP HANA Studio development more productive for both new and experienced HANA developers.

SAP HANA includes the Predictive Analysis Library and Automated Predictive Library for in-database machine learning. AI workloads run close to the data using R, Python, and TensorFlow integrations, enabling real-time predictions, classification, clustering, and time-series forecasting directly within the HANA platform.

The Catalog node stores runtime database objects such as tables, views, procedures, and indexes within schemas. The Content node is a design-time repository holding information views like Attribute, Analytic, and Calculation views organized inside packages for structured modeling.

How to Download & Install SAP HANA Studio

What is SAP HANA Studio?