Setting up your free SAP HANA Express Edition on MS Azure on openSUSE
While SAPPHIRE is over, there is still a lot to digest during the next couple of days, even for us who were lucky to be there showcasing Multicloud architectures, IoT and Machine learning (make sure you’ve hit “Like” on SAP Developers while you are checking out the video 🙂 ).
MS Azure to host your SAP HANA Express Edition + XS Advanced apps
One of the many relevant announcements at SAPPHIRE was the general availability of the cloud-foundry based environment on SAP Cloud Platform. Sven Kohlhaas has already explained how the XS Advanced Programming Model is now available in Cloud Foundry here while Thomas Jung has also pointed us to the right resources on developing XS Advanced applications in your local SAP HANA Express Edition and then deploying into the cloud-foundry based SAP Cloud Platform.
If, like me, you do not have the minimum 16GB RAM in your laptop to run HANA Express with XSA but you still want to experiment in your own HANA instance, you may turn to cloud providers. Added to the step-by-step installation in the Google Cloud Platform with Ubuntu, I am happy to publish the tutorials for Microsoft Azure and openSUSE so you can have another great option:1-
- Installing SAP HANA, express edition, on Microsoft Azure and openSUSE
- Install dependencies for SAP HANA, express edition, in openSUSE
- Extract the binaries and execute the installation script
Looking for the server-only version? There’s a quicker path
Our folks at Microsoft have created a quickstart template that will save you all the manual steps. Be sure to read the blog by Mario Szpuszta for step-by-step instructions on how to use this template here:
http://blog.mszcool.com/index.php/2017/05/developed-an-sap-hana-express-azure-quick-start-template/
Getting started or learning how to develop applications in SAP HANA?
So now that you have your SAP HANA instances, here are some official learning resources, tutorials and training to get you started:
- The Developer Center:Â where you can find groups showing how to develop your first application in SAP HANA with XS Advanced. Â
- The sample multi-target app in this getting started guide
- Using node.js and Google App Engine to create an application, starting with this tutorial
- Using SQL only? Start by connecting to your SAP HANA database with a SQL client and the jdbc driver and you can use the rest of the series to create your own tables and upload data into your database.
- Visit openSAP to check on video tutorials like the introduction to development on SAP HANA
- Or the HANA Academy to find videos answering your questions while building applications.
As usual, happy coding and see you on Twitter or on LinkedIn !
Hi Lucia,
this is slightly offtopic, but I would like to share a strange behaviour of the product.
We installed the Hana Express (version 2.0 SPS 02 Revision 1) on MS Azure (os: openSUSE leap 42.3), and also on Google Cloud (os: SLES for SAP 12-SP3 ).
When we switch to Database Explorer mode in SAP WebIDE for SAP Hana, write a simple query with incorrect syntax, and execute it, then the system simply freezes for 15-20 minutes. The CPU starts to work on 100%, and no one else is able to log into the system, or use it for that period.
OS level access is working properly, but the XS CLI becomes extremely slow.
Could you reproduce this phenomenon in your system? Is this a bug, or we missed or failed something the installation and configuration process. (Which is quite simple, by the way.)
Thanks in advance,
Zsolt
Hi, Zsolt,
I have not had this kind of behaviors in my machines (SUSE or openSUSE). I would like to encourage you to post this, including more details such as logs and what exactly you are executing (SQL statement and how many records it's processing, for example) in the Q&A so more people can see it.
Please tag it as HANA Express so we can follow up.
Cheers,
Lucia.