I have been trying to get my hands dirty onto SAP HANA Express edition for some time but sadly did not have the laptop to support the high RAM requirements. So, through this blog, I wanted to share my side of crazy doubts & questions which I have in my mind by reading through different materials. Hopefully this will help the other beginners like me settle down quickly without struggling much.
Rather than beginning with set up etc. let me begin with the doubts which I had before even I began my adventure. It is okay to laugh also at my silly doubts:). My journey just has started I will keep updating the doubts/issues which i face further in this journey.
Doubts and Resolutions
How will this console like window open? Do I need to configure anything?
This was the most trickiest one till the time i started:). In most of the blogs we see people running commands, I was thinking do I need any local installation? The answer was no, once you set up your SAP Express edition on Google Cloud, you will get the option of opening the console in a browser.
Where will I code? How do I check my HANA database and contents?
SAP Web IDE provides you all the features which you need to code your native application.SAP Web IDE also has inbuilt database explorer which can we used to display data, create table typically SQL console is available to you.
Why do I get error when I try to add create database with correct host?
In my case if I was mentioning host as only HXEHOST it was not taking the moment I mentioned HXEHOST.localdomain as per SAP HANA Admin cockpit it started working
What all I can do in Console
You can do all the things practically for example
- For logging as admin you can use sudo su – hxeadm
- For listing out all the XS apps you can use xs apps
- For Stating and stopping HANA Database you can use HDB start/stop
Restarted the instance but my Web IDE is not loading neither HANA Cockpit?
For me I went to the console, login as HXEADM as started the database HDB start and used XS APs command and it worked normally afterwards. So, after restarting the machine we need to start the services as well as database.
Problem here was i was directly shutting down the Virtual Machine instance not doing a clean exit as mentioned by Lucia in the comments. It is must to use HDB stop from command line to stop the VM step by step.
If I provide my credit card on google cloud platform will it charge?
As of now Google cloud platform is offering 300$ credit which will be used first, then after that they will not auto deduct it will need confirmation from you. So, bottom line is do not worry, you are in safe hands
How does this billing work?
Billing depends on the time till your VM is up and running. So always stop your instance when not using, it will show you the balance also at top in console.
Initial Set Up
Luckily found this blog by Lucia Subatin where it talks about deploying the SAP HANA express addition to Google cloud Platform. This blog talks about deploying only the server, but we wanted to deploy server as well as application. On further searching found this video from SAP HANA Academy showing how to install with application.
Must read blog series
First must try exercise
Once everything was setup and running, I followed this wonderful tutorial Build a basic SAP HANA XS Advanced application by Craig Cmehil to begin my journey into the world of XSA. It is must to try all the tutorials to get comfortable.
What can be explored next?
Read more, explore more and share more. As of now I have below mentioned things on my mind.
- Consuming XSOData on Google Cloud vial SAP Cloud API will be tried
- Native app with CRUD operations
- Something related to Machine Learning
- GeoSpatial stuff.
- Deploy Data Hub on Google cloud as now feeling bit comfortable.
- Streaming analytics on and on:)
Feel free to provide your feedback, open to all ears.