Category: Database SAP HANA
Last Updated on Wednesday, 10 October 2012 03:53
Written by Saurav Mitra
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.
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
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.
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.
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.
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
Enter the SAP HANA instance details, i.e. the Hostname & Instance Number and click Next.
Enter the database username & password to connect to the SAP HANA database. Click on Next and then Finish.
The SAP HANA system now appears in the Navigator.
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
. 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 Schema
s which a used to categorize tables according to user defined groupings.
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 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!