In this SAP tutorial, We’ll discover how to download and set up SAP HANA on our system and also we will learn SAP HANA Studio and the installation steps of SAP HANA Studio.
SAP HANA 2.0 Express Edition is a free version of SAP HANA 2.0 that can be installed on a local machine. It provides all the features of the full version of SAP HANA 2.0, but with some limitations in terms of the amount of data that can be stored and processed.
The installation process of SAP HANA 2.0 Express Edition involves two main steps: installing the SAP HANA 2.0 platform and then installing the SAP HANA Studio full client.
What is SAP HANA Express Edition
With SAP HANA 2.0 Express Edition, developers can build and test applications that leverage the power of SAP HANA, including real-time analytics, machine learning, and data modeling.
It includes a variety of tools and services to support these activities, including the SAP HANA cockpit, SAP Web IDE for SAP HANA, and the SAP HANA Application Lifecycle Management tool.
For example, a startup building a mobile app for e-commerce could use SAP HANA 2.0 Express Edition to develop and test the backend database and application logic. The startup could also use SAP HANA’s in-memory computing capabilities to provide real-time analytics and personalized recommendations to users.
Pre-Requisite for SAP HANA Studio
SAP HANA Studio runs on below platform:
- SUSE Linux Enterprises Server: x86 64 Bit version, Red Hat Enterprises Linux (6.5).
- Mac OS 10.9 or Higher.
- JVM for Java is installed or updated when SAP HANA Studio is installed or upgraded.
- Any other database or application can be connected using the SAP HANA Client software. During the server installation, the SAP HANA Client can be installed on Microsoft Windows, Unix/Linux, and SAP HANA Server hosts. SAP HANA Client and SAP HANA studio are installed independently.
An Eclipse-based integrated development environment (IDE) called SAP HANA Studio is used to create and manage GUI tools for the SAP HANA database.
Running on a client/developer computer, SAP HANA Studio connects to SAP HANA Server. Both local and remote SAP HANA databases can be accessed by SAP HANA Studio.
SAP HANA Studio allows us to:
- allows the user to control the SAP HANA database.
- User authorizations can be created and managed.
- Build new data models or edit those that already exist.
After that, we will install the virtual machine in our windows operating system.
Run SAP HANA Studio
Now go to “C:\Users\workspace” which is the default installation location.
A shortcut to the hdbstudio.exe file can be made on the desktop by right-clicking it.
- The default selection is a workspace. By choosing Browse, we can alter the workspace’s location. Studio setup settings and development artifacts are kept in workspaces.
- Choose “Use this as the default and do not ask again” to stop the workspace selection page from appearing each time SAP HANA Studio is used.
- To download and install SAP HANA Studio, click the button.
Several perspectives are displayed on the Welcome screen. Details for each perspective are as follows:
Administration Console Perspective
The SAP HANA Database is configured, administered, and monitored using this interface. In the SAP HANA Administration Console, a number of Views and editors are available.
The System View Toolbar, which is used for administration, appears as follows:
In the SAP HANA System, this perspective is used to generate modeling objects and manage database objects. Modelers used this viewpoint for the following activity:
- Tables, functions, indexes, views, sequences, synonyms, triggers, and views can be created or modified.
- Build modeling objects like decision tables, attribute views, analytical privileges, calculation views, and analytical privileges.
- Data provisioning from SAP and non-SAP sources via SLT, BODS, and DXC to the SAP HANA database.
The development of a HANA application for the online environment uses this perspective. Java Script, jQuery, ODATA, and other programming languages are utilized in this perspective.
Lifecycle Management Perspective
The SAP HANA Database and SAP HANA Studio software installation and update process take place on this screen. Transporting an object from one HANA system to another HANA system also uses lifecycle management.
Add System in SAP HANA Studio
The user must connect to the SAP HANA database from SAP HANA Studio in order to interact with it. As a result, we create the following connection to SAP HANA DATABASE:
- Step 1: From the System Toolbar, select “Add System”.
- Step2: Provide the following detail below –
- Host Name – Enter the SAP HANA database here.
- Instance Number – Two Digit Instance number.
- Description – Description of the system for better understanding
- Click on the How to Download & Install SAP HANA Studio button.
We must input the SAP HANA Database User and Password on the connection properties screen that opens.
- To access the SAP HANA database from SAP HANA Studio, provide your username and password.
- If there is no problem, the connection was successful, and the System name is added to the System Node section of SAP HANA Studio.
Here is the Dashboard of SAP HANA STUDIO
In Hana Studio under HANA System following sub-nodes exit-
Database objects (Table, View, Procedure, Index, Trigger, Synonyms, etc.) are stored in the Schema Folder of the SAP HANA Studio Catalog node, which represents the SAP HANA data dictionary.
The SAP HANA Database will automatically construct a schema with the same name when a user is created in SAP HANA. When a user creates a database object, this is the default schema that is used. Database objects are grouped using schema.
Database objects including Tables, Views, Triggers, Procedures, Sequences, Functions, Indexes, Synonyms, and more are contained in a container known as a Schema.
To choose the source metadata and import the metadata and data into SAP HANA, utilize provisioning.
There are two types of provisioning, which are as follows:
- Integrated SAP HANA tool (Flat file, Smart Data Access, Smart Data Streaming, etc.)
External Resources (SLT, BODS, DXC, etc.)
The new “Smart Data Access” built-in tool is used by SAP in the SAP HANA Studio Provisioning node.
- Data from many data sources, including Hadoop, Teradata, Oracle, and Sybase, are combined using Smart Data Access.
- The Design Time Repository, or Content Node, houses all of the data models’ information in the package. Each and every type of information view, such as an attribute view, an analytical view, a calculation view, etc., will be produced in a package under the content node.
- The package is used to systematically group related information objects. By selecting New->Package from the context menu of the Content Node, the package can be generated.
In this tutorial, we learn how to download and install SAP HANA. I have also explained, how to run SAP HANA Studio.
You may also like:
I am Chris Waldron, working as a Senior SAP HANA Consultant at Halliburton, Houston, Texas, United States. I have been working in SAP for more than 15 years, especially in SAP IT consulting and business consulting. I worked in various industries in Sales & Distribution, Customer Relationship Management, banking, Risk Management, etc. And I am an SAP Certified Development Specialist – ABAP for SAP HANA 2.0 and SAP HANA Modeling Certified consultant. Read more