At the end of this tutorial, you will know:
- How to download Client
- How to download Studio
- How to download SAPCAR
- Extract the SAR Files to desktop
- Install SAP HANA CLIENT
- Installing SAP HANA Studio on a Windows Box
To Install SAP HANA Studio on a Windows System, we will first install the client which provides connectivity from the windows box to the HANA Server.
On top of the client, we can install HANA Studio which provides graphical user interface to create tables, create view, and so on and so forth.
So, first we will download the client files, then we will download studio files, and then we will download SAPCAR which is a utility tool to expand those downloaded files, and finally we will install the files.
To start installing the application, we have to first go to “Internet Explorer”.
And then type http://service.sap.com in the URL which will open the homepage for “Service Marketplace” (figure 1).
On the “Service Marketplace”, we need to go to the “SAP Support Portal” which will take us to the “Support Portal” homepage (figure 2).
From the “Support Portal” homepage, we need to download two sets of installation files.
To install the files, we need to go to “Software Downloads” which is the third tab in the support portal which will open the “SAP Software Download Center”.
Next, we need to click on “Support Packages and Patches” from the left-hand side menu (figure 3).
Then, we need to click on “A-Z Index” from the dropdown under “Support Packages and Patches” which will bring us to the next screen (figure 4).
Next, we click on “H” as we have to install SAP HANA components (figure 4) which will bring us to the next screen with the list of all tools beginning with “H”.
From the list, we have to click on the “SAP HANA PLATFORM EDITION” (figure 5) which will bring us to the “SAP HANA PLATFORM EDITION” menu.
On this screen, we need to click on “SAP HANA PLATFORM EDIT. 1.0” which will take us to the next screen “SAP HANA PLATFORM EDIT. 1.0”.
Since we don’t want to download the whole product but only the client component for the windows machine so we can connect to a Linux server, we will click on “Comprised Software Component Versions” which will expand the list of various components.
Now Click on Entry by Component
From the above screen, we need to download two tools. Firstly, we need to be able to connect to ODBC and JDBC from the Windows machine to the Linux server. To do that, we will use the “SAP HANA CLIENT 1.0” (figure 7) and click on the “Windows on x64 64bit” option to download the 64 bit version for Windows.
CLick on HANA CLIENT (figure 7)
After clicking on the “Windows on x64 64bit” option, we will scroll down to see the various files we can download (figure 2.15).
We do not download these by right-clicking but by using the “Download Basket”. On the above screen we will see the “Patch Level” also called the “Version Level” mentioned against every version. In some cases, we may need to download the specific version for the specific server. In this scenario, we will download the “IMDB CLIENT 100 Patch Level 34”. To do this, we select the “IMDB CLIENT 100 Patch Level 34” (figure 7) and select “Add to Download Basket” (figure 7).
This will bring us to the download screen where we can see that the version has been added to the download basket.
After the version has been added to the download basket, we need to add the actual SAP HANA Studio file. So, we scroll up and come back to the list of various components (figure 2.19). To download the HANA Studio File we click on “SAP HANA Studio 2.0” from the list (figure 8).
From the dropdown, we select “Windows on x64 64bit” and then scroll down to select the relevant version.
In this case, it is the last version in the list IMC STUDIO2 122”.
After selecting the required version, we will add it to the “Download Basket”.
Next, we need to download the SAPCAR tool which is an executable to extract data from the downloaded “SAR” files.
To download SAPCAR, go Back to the "Support Packages & Patches" we need to click on “By Catalogue”
On this page, we need to click on “Additional Components” and from the list select “SAPCAR”.
On the next screen, we need to select the latest version of SAPCAR which in this case is 7.21 (figure 11).
From the next dropdown, we need to select the version compatible with the existing windows environment which in this case is “Windows on x64 64bit” (figure 11).
After clicking on the required version, scroll down to select and add the relevant version to the download basket which in this case is “SAPCAR 5” (figure 11). Add it to the “Download Basket” by following to procedure mentioned before.
To check the content of the download basket, click on the link “my DOWNLOAD BASKET” from the left-hand side menu which will open a screen with all the components we have added to the basket (figure 2.33). In this scenario, there will be three files – SAPCAR, HANA Studio, and HANA Client.
From the above screen, we need to take the cursor to one file at a time, right-click, and then select “Save Target As…” and save it to the desired location which in this case is the desktop.
Repeat the procedure for saving the HANA Studio and HANA Client file on the desktop as well.
After we minimize the browser window, we should see the three files downloaded on our desktop.
So, this is the way that we can get the content from service market place in order to install the SAP HANA Client or the Studio on a Windows Box which is connecting to a HANA server on a Linux Machine.
To begin the installation process, the first thing we to do is to extract the data from the SAR files. To do this we would go to “start” and then type “cmd” in the command line.
Now change to the directory where you have downlaod the files
and extract all files with the cmd
So, we scroll down to the end of the screen again and type SAPCAR –xvf “I*.sar” it will extract any file that starts with “I” and ends with .sar on the desktop folder.
>sapcar -xvf "I*.sar"
It will now extrack all the files in the relavent folders
Now Exit the CMD prompt.
So, we can see now that the .sar files are getting extracted to those folders
After the extraction, we can exit the command line by typing “exit” in the command box.
To install the SAP HANA CLIENT, we will first go to the SAP HANA CLIENT FOLDER and install the client by clicking on the “hdbinst.exe"
And, then we will allow it to install (figure 13).
Next, it will prompt if we can install the client and which version so we will simply click “enter” to install version 1 for 64-bit which will then install the client.
After the file stops installing, the command box will ask us to press any key. After pressing a random key, we need to confirm that the client has been installed. To check that, go to “Start” and click on “Control Panel”.
Next, click on “System and Security” from the control panel (figure 15) and then click on “Administrative Tools” (figure 15).
Next, go to “Data Sources ODBC”, go to the second tab “System DSN”, and click on “Add” (figure16).
We should be able to see “HDBODBC” connectivity and its version (figure 17).
The next step is to install the studio, go to the other folder “SAP HANA STUDIO” and again click on “hdbinst.exe” and allow it to install.
Next, a command box will open which will try to detect if the Studio is already installed. In this case, we will have to install the studio and to do that we just need to click “Enter” and it will automatically download. It takes a few seconds to install as at first it will install the Microsoft C++ Runtime environment (figure18).
Then, it will install the Equinox P2 Director which is used for the front end and lastly, it will derive that the installation file has been installed.
To see if the Studio has been installed, go to “Start” and click on “All programs”.
Next, click on “SAP HANA” and then on “SAP HANA STUDIO”.
The next screen will confirm that the SAP HANA STUDIO has been installed.