The SAP HANA studio is a collection of applications for the SAP HANA appliance software. It enables technical users to Manage the SAP HANA database, to Create and Manage User Authorizations, and to Create new or Modify existing Models of data in the SAP HANA database. It is a client tool, which can be used to access local or remote SAP HANA databases.

Supported Platforms

The SAP HANA studio runs on the Eclipse platform 3.6. We can use the SAP HANA studio on the following platforms:

  • Microsoft Windows x32 and x64 versions of: Windows XP,Windows Vista, Windows 7
  • SUSE Linux Enterprise Server SLES 11: x86 64-bit version

System Requirements

Java JRE 1.6 or 1.7 must be installed to run the SAP HANA studio. The Java runtime must be specified in the PATH variable. Make sure to choose the correct Java variant for installation of SAP HANA studio:

  • For a 32-bit installation, choose a 32-bit Java variant.
  • For a 64-bit installation, choose a 64-bit Java variant.

Installation Paths

If we do not specify an Installation Path during installation, the following default values apply:

  • Microsoft Windows 32-bit -> C:\Program Files\sap\hdbstudio
  • Microsoft Windows 64-bit -> C:\Program Files\sap\hdbstudio
  • Microsoft Windows 32-bit (x86) -> C:\Program Files (x86)\sap\hdbstudio
  • Linux x86, 64-bit -> /usr/sap/hdbstudio

Open the SAP HANA studio from the Start menu: Start > All Programs > SAP HANA > SAP HANA Studio
The SAP HANA studio starts.

Perspectives

The SAP HANA studio provides an environment for Administration, Modeling and Data Provisioning. There are several predefined User Interface layouts addressing several applications types called Perspectives.

The Administration Console is used to Administrate and Monitor the SAP HANA instances. The Modeler view is used to define Information Models.

Adding System

In order to connect to a SAP HANA instance we need to know the Server where the instance is running and Instance Number. Also we need a Username & Password combination to connect to the instance.

The left side Navigator space will show what are all the HANA instances available in SAP HANA Studio. As this is new system the first step we have to do is add the system.

  • So right click in the Navigator space and click on Add System

Add System

  • Enter the SAP HANA instance details, i.e. the Hostname & Instance Number and click Next.

System Credentials

  • Enter the database username & password to connect to the SAP HANA database. Click on Next and then Finish.

Database Login Credentials

  • The SAP HANA system now appears in the Navigator.

SAP HANA System

Catalog and Content

After the system has been integrated on the left side of the SAP HANA Studio we will find the Navigator View. There are two sub-nodes, Catalog and Content. The Catalog represents SAP HANA’s data dictionary, i. e. all data structures, tables, and data which can be used. The physical tables and views will be placed in the Navigator tree under the Default Catalog node. This node contains a list of Schemas which a used to categorize tables according to user defined groupings.

Default Catalog & Content

The node Content represents the design-time repository which holds all information data models created with the Modeler. Physically these models are stored in database tables which are also visible under Catalog. The Information Model nodes navigate to Attribute Views, Analytic Views and Calculation Views. The Information Models are organized in Packages. The Contents node just provides a different view on the same physical data.

One model can incorporate tables from multiple Schemas. The Schema do not limit the modeling capabilities. The created Column Views are always located in schema _SYS_BIC, their metadata in schema _SYS_BI.


Have a question on this subject?

Ask questions to our expert community members and clear your doubts. Asking question or engaging in technical discussion is both easy and rewarding.

Are you on Twitter?

Start following us. This way we will always keep you updated with what's happening in Data Analytics community. We won't spam you. Promise.

  • SAP HANA Architecture

    In this article we will discuss about the architecture overview of the In-Memory Computing Engine of SAP HANA. The SAP HANA database is developed in C++ and runs on SUSE Linux Enterprise Server. SAP HANA database consists of multiple servers and...

  • SAP HANA Studio

    The SAP HANA studio is a collection of applications for the SAP HANA appliance software. It enables technical users to Manage the SAP HANA database, to Create and Manage User Authorizations, and to Create new or Modify existing Models of data in...

  • SAP HANA Information Modeler

    Information Models are multiple database views of transactional data stored in the physical tables of SAP HANA Database used for Analytical purposes. Analytical Data Modeling is only Possible For Column Tables i.e. Information Modeler only works...

  • SAP HANA - An Introduction for the beginners

    SAP HANA: High-Performance Analytic Appliance (HANA) is an In-Memory Database from SAP to store data and analyze large volumes of non aggregated transactional data in Real-time with unprecedented performance ideal for decision support & predictive...

  • SAP HANA Appliance

    SAP In-Memory Appliance (SAP HANA) software is a flexible, multipurpose, data source agnostic in-memory appliance that combines SAP software components optimized on hardware provided and delivered by SAP’s leading hardware partners.