The purpose of this exercise is to set up and then become familiar with the SAP HANA Studio user interface. You will perform the following tasks:
● Start SAP HANA Studio
● Add an SAP HANA connection to the Systems view
● Define SAP HANA Studio preferences
● Work with Views and Perspectives Business Example
You are working on a customer project where SAP HANA is installed, and need to get familiar with SAP HANA Studio, in order to connect to the SAP HANA system, browse the database catalog objects as well as the repository.
1. Launch the SAP HANA Studio.
If you are prompted to choose a folder to store settings, use the default location and choose Submit.
If you are prompted to choose a workspace folder, leave the defaults unchanged and choose OK.
If you are asked to create a password hint (in case you forget your password), choose No.
2. From the Welcome page, open the SAP HANA Administration Console perspective.
3. Connect your SAP HANA Studio to the SAP HANA training system using the following information:
Field Value
Host name wdflbmt7215.wdf.sap.corp Instance number 00
Description My SAP HANA Training system
4. Enter your credentials as given in the following table:
Field Value
User STUDENT## (don't forget to swap ## for
your 2 digit number)
Password Training1
5. Set your SAP HANA Studio preferences using the values in the following table:
Path and parameter Value
General > Network Settings > Active Pro-vider
Direct
General > Web Browser > Use External Web Browser
Internet Explorer
6. You are currently working in the SAP HANA Administrator perspective, switch to the SAP HANA Modeler perspective.
7. Switch back to the SAP HANA Administration Console perspective for the next tasks.
8. Explore the Systems view by expanding the nodes.
● Catalog
● Content
● Provisioning
● Security
Note:
In the Catalog node, the System has automatically created a schema for you.
The schema name is the same as your user name and is the default schema whenever you work with database objects such as tables.
9. Open the Administration view for your SAP HANA system.
Unit 2 Solution 1
Getting Started with SAP HANA Studio
The purpose of this exercise is to set up and then become familiar with the SAP HANA Studio user interface. You will perform the following tasks:
● Start SAP HANA Studio
● Add an SAP HANA connection to the Systems view
● Define SAP HANA Studio preferences
● Work with Views and Perspectives Business Example
You are working on a customer project where SAP HANA is installed, and need to get familiar with SAP HANA Studio, in order to connect to the SAP HANA system, browse the database catalog objects as well as the repository.
1. Launch the SAP HANA Studio.
If you are prompted to choose a folder to store settings, use the default location and choose Submit.
If you are prompted to choose a workspace folder, leave the defaults unchanged and choose OK.
If you are asked to create a password hint (in case you forget your password), choose No.
a) Locate and launch SAP HANA Studio with the default settings as described above.
2. From the Welcome page, open the SAP HANA Administration Console perspective.
a) Choose Open SAP HANA Administration Console.
3. Connect your SAP HANA Studio to the SAP HANA training system using the following information:
Field Value
Host name wdflbmt7215.wdf.sap.corp Instance number 00
Description My SAP HANA Training system
a) In the Systems view, right-click in the blank area and choose Add System.
b) Enter the Host Name and Instance Number provided in the table.
c) In the Description field, enter My SAP HANA Training system . d) Choose Next.
4. Enter your credentials as given in the following table:
Field Value
User STUDENT## (don't forget to swap ## for
your 2 digit number)
Password Training1
a) Enter your user name and password as provided in the table.
b) Choose Finish.
5. Set your SAP HANA Studio preferences using the values in the following table:
Path and parameter Value
General > Network Settings > Active Pro-vider
Direct
General > Web Browser > Use External Web Browser
Internet Explorer
a) Choose Window→ Preferences and follow the path provided in the table above to set the values.
6. You are currently working in the SAP HANA Administrator perspective, switch to the SAP HANA Modeler perspective.
a) Choose Window→ Perspective→ Open Perspective→ Other to display all the available perspectives.
b) Choose the SAP HANA Modeler perspective and notice the layout changes slightly to provide features that a modeler uses.
7. Switch back to the SAP HANA Administration Console perspective for the next tasks.
a) Using In the perspective switcher buttons located in the upper-right corner of the screen, choose SAP HANA Administration Console.
8. Explore the Systems view by expanding the nodes.
● Catalog
● Content
● Provisioning
● Security
Note:
In the Catalog node, the System has automatically created a schema for you.
The schema name is the same as your user name and is the default schema whenever you work with database objects such as tables.
a) Click on the arrow to the left of each node to expand the details and explore the tree.
9. Open the Administration view for your SAP HANA system.
a) In the Systems view, select the H00 (STUDENT##) system.
b) Click on the hammer and wrench icon in the toolbar at the top of the System view c) Explore the system information.
Lesson: Working with Interfaces for Administrators and Developers
SAP HANA Web Development Workbench
In addition to SAP HANA Studio, there is the SAP HANA Web Development Workbench. This interface was originally aimed at developers and coders as an alternative to using the heavier SAP HANA Studio. The SAP HANA Web Development Workbench focused on the features needed by application developers. The SAP HANA Web Development Workbench is evolving to become the main interface not just for developers but anyone who needs to access SAP HANA, this includes administrators and modelers. However, it should be noted that there are still some feature gaps between the SAP HANA Web Development Workbench and SAP HANA Studio that will be closed in later versions. So for now, it may mean SAP HANA Studio is needed alongside SAP HANA Web Development Workbench. But the majority of developers will prefer to work with the SAP HANA Web Development Workbench due to its simplicity and portability.
Note:
One of the motivational factors for SAP moving towards the SAP HANA Web Development Workbench as the main interface for SAP HANA is because of the importance of cloud computing where 100% of the tools needed are cloud based and available through a browser. SAP HANA Studio is not a browser based tool, it is installed as a local client.
This course uses the SAP HANA Studio.
SAP HANA Logon Screen
Figure 42: SAP HANA Logon Screen
In order to get started with the SAP Web Development Workbench, open a web browser and enter the following URL:
http://<hostname>:80<instance>/sap/hana/xs/ide Substitute the two placeholders with your system details.
Enter your user and password and choose LOG ON.
SAP Web Development Workbench
Figure 43: SAP Web-Based Development Workbench
To view the panel to access the SAP HANA repository of existing artifacts such as views and procedures, choose Editor.
If you want to work with tables and other database objects, choose Catalog.
Modeling with the SAP HANA Web-Based Development Workbench
Figure 44: Modeling with the SAP HANA Web-Based Development Workbench
Note:
It is important to note that some features are only available in SAP HANA Studio and not in SAP Web Development Workbench and vice versa. But in each release of SAP HANA the gap closes.
Lesson: Working with Interfaces for Administrators and Developers
LESSON SUMMARY You should now be able to:
● Work with the SAP HANA Studio
● Describe the SAP Web Development Workbench