Getting Started with HANA SAP Native Development
If you are new to SAP HANA, here you will get some useful tips on where to start your learning journey.
Getting Started with SAP HANA Native Development
With HANA Express SAP is providing a great opportunity for everybody to gather insights and learn more about SAP HANA and HANA Native development. The SAP HANA Express edition is a streamlined version of SAP HANA. Overall it is a complete database and application development platform designed for one developer. It can run on laptops and other resource-constrained hosts and is free to use for in-memory databases up to 32GB of RAM.
This Blog Article is mainly addressed to SAP HANA Beginners and aims to give answers on:
How to set up SAP HANA Express (VM Version)?
Where to start your learning journey?
How to Setup SAP HANA Express on a VM?
Before setting up SAP HANA Express you would need to decide on one of the various installation options. You can select between the On-Premise Versions or using the services of Cloud Providers. In this article, I want to focus on the On-Premise Virtual Machine option for Windows.
The general recommended System Requirements for the VM Method are as follows:
- JRE: Java Runtime Environment 8 (64 bit)
- HDD: 120GB recommended
- Cores: 2 (4 recommended)
- Intel Processors: Intel Virtualization activated in BIOS
The requirements for the RAM depend on how you plan to use the Database. As shown in the following graphic you would require at least 8GB of RAM for the “Database server only” and additional 8GB of RAM if you would like to install the tools required for Native development. For more details, you can also refer to the SAP Sizing Guide.
Initial Setup for Server + XSA Applications Version (VM)
1. Download Hypervisor
Download and install a Hypervisor. Potential Hypervisors could be VMWare Workstation Player, VirtualBox or VMWare Fusion. In my case, I’ve used VMWare Workstation 15 Player and it worked perfectly.
2. Register at SAP Developer Webpage
In order to access the Download Manager you would need to register your copy of the SAP HANA Express using the registration page. The Download Managers will appear after a successful registration. Save the Download Manager file.
3. Download SAP HANA Express VM Files
Download the Server+Applications VM using the Download Manager. Due to its size, this may take a while.
4. Start Hypervisor and Open VM
Start the Hypervisor and open the Virtual Machine by selecting the hxexsa.ova file which you downloaded in step 3. The setup for this took about 10 minutes in my case. Afterwards, you can start the VM.
5. Provide Initial Credentials
After starting the VM you will be asked to enter the hxehost login ID and Password. Provide „hxeadm“as login ID and „HXEHana1“ as PW. You would need to change this Password later.
Consider the following restrictions for your new Password:
- At least 8 chars
- At least 1 uppercase letter
- At least 1 lowercase letter
- At least 1 number
- Optional: Special Chars, but not $ \ “ ‘
- No Dictionary Words.
6. HANA DB Master Password / Proxy / XSA Configuration
After setting your initial Credentials for the hxeadm User, you will be asked to provide the HANA database master password. Done this you would need to choose if you are using a proxy server to access the Internet. If so select „Y“ and provide the Proxy details in the subsequent steps. Select „N“ otherwise. As a last step you will be asked if you would like to wait for XSA to finish the configuration. By confirming you would need to wait for a while but with the benefit of having all the necessary XSA apps loaded afterward so you cloud directly start developing.
The configuration took me about 20 minutes and is finalized when you see the following message:
7. Setting up the „hosts“ file
In order to access all XSA Apps, HANA Cockpit etc. you would need to modify your Windows „hosts“ file and provide the hxehost address. Before doing so you have to find out your hxe ip address. For this type /sbin/ifconfig into the HDB command line. The IP Address we are searching for is the „inet addr“ as shown below:
The „hosts“file can be found in the folder „../Windows/System32/drivers/etc“. Open the hosts file as an administrator and adjust the file by adding your „inet addr“ address as shown below:
Be cautious here as spacing is important!
HDB start and stop after initial setup
Now as your HANA DB is set up and running let’s talk about how to start and stop in future. In order to stop the HANA DB it is sufficient to type HDB stop in your console. After receiving a confirmation that the HANA DB is stopped you can close the Virtual Machine. Do not close the VM when the Database is still running.
In order to start the HANA DB, you would need to log in with your hxehost user and your chosen password (step 5).
When the login was successful, you can start the HANA DB by using the HDB start command.
After receiving a confirmation that the DB has started you can log into the XSA Application server using the following statement:
xs login –u XSA_ADMIN –p “<yourpw>” -s SAP
If you are asked to provide an API_URL provide your API endpoint: https://hxehost:39030.