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:
1. A minimum free disk space of 190 MB. The objects you create in SAP HANA will be stored on the server; they will not take any space on your machine (unless you export them).
2. A recommended memory of 1 GB. SAP HANA Studio is built upon the Eclipse IDE, which is written in Java. The more memory you have on your machine, the smoother the Studio will run.
3. Windows XP, Vista, or Windows 7, or SuSE Linux Enterprise Servereither the 32-bit or 64-bit version.
4. JAVA JRE 1.6 or 1.7. This needs to be installed and configured correctlyor the SAP HANA Studio installer will fail. Additionally, if you have 32-bit OS, you’ll need a 32-bit Java, and a 64-bit Java for a 64-bit OS.
5. A SAP HANA server to connect to, you will need the server name or IP address, and the instance number. You should ask for this information from you client/system administrator. You will also need to make sure that the Studio can connect to the server on the port 315 (for example, if the instance ID is 40, the port 34015 needs to be reachable). Check with your network administrator for this.
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:
HTTP://WWW.SDN.SAP.COM/IRJ/SCN/INDEX?RID=/WEBCONTENT/UUID/10E6E3FF-6081-2F10-E690-829E62F29A26
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.
Note
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:
- Open Administration Console:
- This option allows you to administrate the SAP HANA appliance itself; for example, creating users and assigning authorizations
- Open Modeler:
- This is where you will do all your SAP HANA development work, creating views on data, running SQL queries, and so on—we’ll be spending the best part of this post using the Open Modeler option
- Open Lifecycle Management:
- Allows you to update the SAP HANA installation on the server, by applying patches you have received from SAP
- Documentation Overview:
- This is a link to the SAP HANA online documentation pages on the sap.com website
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:
1. The Navigator pane: Shows the SAP HANA systems you’ve configured, as well as the list of objects (notably, tables and views) available to you on those systems.
2. The Quick Launch pane: As its name suggests, a quick way to get to the creation screen of different object types.
3. The Where-Used List pane: Readers familiar with SAP will have already come across this concept, which is widely used in the SAP ERP. This pane will show, for the object selected in the Navigator, where the object is used (if, for example, an attribute view is used in several analytical views, the analytical views will be listed here).
4. The Cheat Sheets pane: Depending on the context (the action you’re currently performing), this pane will show you different options. In the previous screenshot,we are at the main page, not performing any particular action, so this pane shows us the option to add a new SAP HANA server.
5. The Properties pane: Lists, and allows modification of, the properties of the object currently being modified.
6. The Job Log, History, and Progress pane: Whenever you perform creation or modification actions in SAP HANA, your changes need to be activated before being usable in the database (again, a common notion in the SAP ERP world). Since activation can take a little while (especially if you choose to use a cascaded activation, which will activate an object and then attempt activation of all dependent objects), and can potentially fail (for example, in the case of syntax errors), these panes will show you the status of your current action.
.png)
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:
.png)
The program will be installed, and you will have a Start menu item created for you.
.png)
The four options available are as follows:
.png)
The main areas (panes) of the Modeler perspective are explained as follows:
1. The Navigator pane: Shows the SAP HANA systems you’ve configured, as well as the list of objects (notably, tables and views) available to you on those systems.
2. The Quick Launch pane: As its name suggests, a quick way to get to the creation screen of different object types.
3. The Where-Used List pane: Readers familiar with SAP will have already come across this concept, which is widely used in the SAP ERP. This pane will show, for the object selected in the Navigator, where the object is used (if, for example, an attribute view is used in several analytical views, the analytical views will be listed here).
4. The Cheat Sheets pane: Depending on the context (the action you’re currently performing), this pane will show you different options. In the previous screenshot,we are at the main page, not performing any particular action, so this pane shows us the option to add a new SAP HANA server.
5. The Properties pane: Lists, and allows modification of, the properties of the object currently being modified.
6. The Job Log, History, and Progress pane: Whenever you perform creation or modification actions in SAP HANA, your changes need to be activated before being usable in the database (again, a common notion in the SAP ERP world). Since activation can take a little while (especially if you choose to use a cascaded activation, which will activate an object and then attempt activation of all dependent objects), and can potentially fail (for example, in the case of syntax errors), these panes will show you the status of your current action.
Next Steps for Installation Click Here: SAP HANA Studio Installation
Comments
Post a Comment