You will learn
- How to use HANA Studio Perspectives
- How to create a connection to the HANA back end
- Getting started with the HANA Web based development workbench
Access your first data in a native SAP HANA Application.
Beginners will take 20 minutes to finish this tutorial.
Access your HANA instance that was created in “How to create an SAP HANA Developer Edition in the Cloud”.
Chose Notepad as the Open with Editor.
Replace the current IP address in front of the hostname
hanapm with the specific IP address for this workshop which was supplied by your instructor.
Save the content and exit Notepad.
Open the HANA Studio via the Windows Start menu or via the Icon on your Start bar.
If your HANA Studio opens to the following Overview screen, simply press Workbench to return to the full Studio tooling:
To support the new developer centric workflow, there are two additional Eclipse Perspectives which have been added to SAP HANA Studio. These are not displayed by default.
In the upper right corner of your SAP HANA Studio, there is an add Perspectives button. Press this:
Add the SAP HANA Development perspective. This is the perspective you should be using for almost this entire tutorial:
Repeat the step and add the Debug perspective:
After adding these two new perspectives, you may also still see the initial SAP HANA Administration Console perspective as well. If so, you can right mouse click and choose Close as we will not be using this perspective:
Make sure you are in the SAP HANA Development perspective by clicking on the button:
Click on the
Systems view. Right click in the white space below this tab and choose
Input the server hostname:
Input the instance number:
Enter a meaningful description of your choice. Press the
Enter the user id and password. The user id should be
WORKSHOP_<Group Number>. Your group number is
01. For this tutorial, your user id is
Enter the password:
Click Store user name and password in secure storage.
You should now have a new connection with your specific user id for the HANA system. Please make sure to use this connection for the rest of the exercise.
The System ID and users shown in these screen shots might be different than the ones you are working with and will often be blurred to avoid any confusion.
Switch to the
SAP HANA Repositories view. You should see the system entry you created in the previous step and a default Workspace. Right mouse click and choose
Create Repository Workspace:
Confirm the file system location on your local machine which will hold the local copy of this Workspace. Click
You should now see the local workspace mapped to the remote workspace in the SAP HANA Repositories view:
Your System ID, User ID, Hostname, and System Numbers will be different than those displayed in subsequent screen shots. For this reason we have often blurred this information in screen shots to avoid confusion.
To view what you have just created, deployed and activated you can view the URL on the server via your web browser.
You have completed the exercise! You are now able to:
- Create a connection to the HANA server
- Launch the SAP HANA Web-based Development Workbench
- Create a schema
- Create access control files
- Grant access to the schema
- Create an
index.html file to test your setup
If you need addition help resources beyond this document, we would suggest the following content: