In five easy steps, you can install the SAP HANA Studio and set it up on your system. Installation of the SAP HANA server is done by qualified technicians for certified hardware vendors—you cannot download the database software and install it on your server yourself. Hence, only client-side installation will be covered in this section.
Before you install the SAP HANA Studio on your computer, you will need to check if you have all of the required elements, listed as follows:
The easiest way to get hold of the SAP HANA Studio installation package is to use the SAP HANA DVD set; the Studio is available there.
If the DVD is not available, then you can use the SAP Service Marketplace Software Download Center link from HTTP://SERVICE.SAP.COM/SWDC to download the Studio. You will need a SAP Service Marketplace login to download the software. Additionally, your SAP Service Marketplace login needs to have a current SAP HANA installation active, or else you will see that no downloads are available. In the Software Download Center link, use the following path to find the download:
Software Downloads | Support packages and patches | Browse our download catalog | SAP In-Memory (SAP HANA).
A final alternative to download the Studio is to use SDN. A developer version of the studio is available at the following URL:
You will need an SDN profile to download this file. Creating a profile is free, and requires only an e-mail address. You don’t even need to be a SAP customer to create a profile on SDN.
Download the correct version of the Studio for your OS and Java installation. If you have a 32-bit OS and Java installation, install the 32-bit version of the Studio; if not, install the 64-bit version.
Installation of the Studio is straightforward. On Windows, just run the hdbsetup.exe program in the installation folder, as shown in the following screenshot:
Then just follow the instructions. The only information that you’ll need to provide is the destination folder for the installation, and you can usually leave the default value as it is.
Installation takes only a couple of minutes, as shown in the following image:
The program will be installed, and you will have a Start menu item created for you.
The first time you run the Studio after installation, you are presented with a clean, albeit rather empty interface, as shown here:
The four options available are as follows:
Choose the Open Modeler option to get to the main development layout (referred to as a perspective), with which you will do most of your work in SAP HANA; the main development layout is shown in the following screenshot:
The main areas (panes) of the Modeler perspective are explained as follows:
There are more panes in the SAP HANA Studio, which you can enable or disable according to your preference. The layout too is totally customizable and can be customized to suit your particular needs. Feel free to play with the Studio layout to find a layout that works for you.
If you find that you have “lost” a pane, or have made a complete mess of the layout and want to undo your changes, then go to Window | Reset Perspective; this will return you to the default layout at any time.
Before you can do any work with the Studio, you need to connect it to your SAP HANA server. From the main Administration Console or Modeler perspective, right-click inside the Navigator pane, and from the menu that appears select Add System, which will open the following dialog window:
You’ll need to give the hostname and instance number of your SAP HANA installation, as well as a short description (especially useful if you have several instances configured). You can also specify the Locale (default language) setting of your installation, and can create folders to better arrange your different SAP HANA servers.
Once that’s done, click Next >, after which the login dialog window will open, as shown here:
Here you are asked for your login credentials on the SAP HANA server. Ask your system administrator for this information—you might need to specify your User Name and Password, or your SAP HANA server might be configured to accept your operating system user (Single Sign-On).
You can create several entries to the same SAP HANA instance if you need to do so, for example, if you have two different sets of login credentials—an everyday user for development work, and a system administration account to create other users or perform administration tasks. If you need to do this, then the Add to Folder and Description fields can come in useful to help tell the difference.
Click on the Finish button to save the information.
And that’s it
By this point, you should have a working installation of the SAP HANA Studio and are free to play around and discover more about it.
In the next section, we’ll be taking a closer look at the Modeler perspective, and using it to create our first SAP HANA application.
All the above topics will be covered under SAP HANA TRAINING MindMajix
Get Updates on Tech posts, Interview & Certification questions and training schedules