Introduction
Some HANA links:
- HANA intro
- Tutorial
- Help
- Academy
- Data loads
- HANA XS
- Web IDE vs. Studio
- NodeJS and HANA
- HANA CLI tools
Also check out River, it is a new development language. It is not publicly available at the time of writing but there is a early adoption program and possible to get a trail account for 7 days. See scn.sap.com and sap-river.com
Options for running HANA in the cloud
A trail account can be created here: hanatrial.ondemand.com
SAP provides HANA in the cloud themselves (starting at 4.500-6.000/month depending on version), see hcp.sap.com.
There is also a starter edition with community support ($539/month), here
- HANA One costs $3/hour ($2.200/month)
- Developer account http://cal.sap.com
- m2.4xlarge costs $0.0642/Hour ($48/month)
- hs1.8xlarge costs $4.600/Hour
The HANA developer account is by far the cheapest option. Let’s try that one out.
HANA One and Developer Edition are technically the same. HANA One requires significantly more hardware though and is therefore more costöy to run. The main difference is otherwise the license, see this post for more details
You can also run on your own hardware if you are a SAP-customer (see SAP HANA Platform edition).
SAP HANA Platform edition
- Supported OS:es. Look for HANA Platform EDIT (a SAP s-user is needed)
-
HANA is only supported for SuSE 11 (which is rather old by now)
Howto setup HANA One instance on AWS
- Launch in EC2 console (search for HANA One in the marketplace)
- Check the IP and access in a browser (accept security exception)
- http://www.saphana.com/docs/DOC-3109
- Set the password using your AWS access key and secret
Howto setup HANA developer edition
Goto and follow the instructions. A EC2 server will be launched with everything you need.
HANA Studio installation
Hana Studio (Eclipse Kepler) - need to install Hana Studio once Eclipse is installed
- Then do Help > Install new software > https://tools.hana.ondemand.com/kepler
A HANA Client is also good to have (not available for Mac):
Development on mac
There is no HANA client for Mac. One alternative is to run the client on linux in a VM
Another workaround: cloud service that makes it possible to use Github
Tutorial
My app ended up here: http://79.125.55.249:8000/hello/
I had to reboot the HANA server once in cal.sap.com, Eclipse lost the connection and could not reconnect.
More advanced stuff
Login to the HANA server
# SSH into the HANA (Suse) server
ssh -i ~/path/to/keypair.pem root@<IP>
# assuming the the system is named HDB
su - hdbadm
# List all hosts
./exe/sapcontrol -nr 0 -function GetSystemInstanceList
Commands:
- hdbsql
- hdbupdrep - update repository
See the 'SAP HANA LCM Tools Reference Guide’ for the details.
Web development IDE
Howto setup (not installed by default):
Run docker on the AWS HANA server
docker provides a good way to compartmentalize different technologies. This provides a way to run other technologies on the HANA server. I’ll se if I can use this when migrating old applications to HANA. Running HANA servers is rather costly and this is a way to keep the total cost manageable.
Instructions for installation of docker on SuSE
# check SuSE version
cat /etc/SuSE-release
SUSE Linux Enterprise Server 11 (x86_64)
VERSION = 11
PATCHLEVEL = 2
# Version 11.4 is the lowest supported level I could find
sudo zypper ar -f http://download.opensuse.org/repositories/Virtualization/openSUSE_11.4/