Join the Community

Sponsor

Free BI Digest

Need more help on this subject?

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 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.

About the Author

Saurav Mitra

Saurav Mitra is a business intelligence professional.
Connect with the author via Google+
 



If you have any doubt or question on the above article, please Ask your question here. We will surely help you out!

Before you leave, Kindly provide your comments / suggestions / feedback below. Thank You!