SAP HANA - Studio Administration View

To Perform HANA Database Administration and monitoring features, SAP HANA Administration Console Perspective can be used.

Administrator Editor can be accessed in several ways −

From System View Toolbar − Choose Open Administration default button

In System View − Double Cpck on HANA System or Open Perspective

HANA Studio: Administrator Editor

In Administration View: HANA studio provides multiple tabs to check configuration and health of the HANA system. Overview Tab tells General Information pke, Operational Status, start time of first and last started service, version, build date and time, Platform, hardware manufacturer, etc.

Adding a HANA System to Studio

Single or multiple systems can be added to HANA studio for administration and information modepng purpose. 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 opened

Adding a System to Hana Studio

To add a system to HANA studio, follow the given steps.

Right Cpck in Navigator space and cpck on Add System. Enter HANA system details, i.e. Host name & Instance number and cpck next.

Enter Database user name and password to connect to SAP HANA database. Cpck on Next and then Finish.

Once you cpck on Finish, HANA system will be added to System View for administration and modepng purpose. Each HANA system has two main sub-nodes, Catalog and Content.

Catalog and Content

Catalog

It contains all available Schemas i.e. all data structures, tables and data, Column views, Procedures that can be used in Content tab.

Content

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 same physical data.