How to Consume SAP HANA Express Edition on Google Cloud Platform
Last week, SAP and Google have announced strategic partnership details are here: http://news.sap.com/flexibility-scalability-speed-sap-google-strategic-partnership/ and I have shared a blog post https://blogs.sap.com/2017/03/10/sap-and-google-has-declared-a-strategic-partnership-what-does-it-mean/
Today I want to share my fist test drive results. First things first, I have enrolled Google Cloud Platform. Before being enrolled I have read what Google Cloud Platform offers about SAP HANA. At the moment there are two main offerings: SAP HANA BYOL and SAP HANA, Express Edition, I have decided to go with SAP HANA Express Edition, since it seems more easy 🙂
Google Cloud Platform is seems free, but in real it is not. After getting enrolled GCP grants you 300 USD free credit, many services in the platfrom are not free, but don’t worry Google does not want to cheat you, all transactions are in good control and no billing without your control.
I have easily enrolled by giving credit card information. Google says this is required, because I might be Robot !
I really like the Google Cloud Platform, it is similar to Sap Cloud Platform, but little bigger 🙂 To be honest I feel myself like Alice through the Rabbit hole. It is not easy to find how to deploy SAP HANA express Edition. But after exploring couple of minutes, I have found my way. But there is one better way: to read a tutorial: https://www.sap.com/developer/tutorials/hxe-gcp-getting-started-launcher.html
On the left-end side Cloud Launcher is the place that you can found everything you need at the beginning.
After opening the door of Cloud Launcher, I have really entered a great ballroom. I have entered the Database room:
My lovely HANA Express Edition was there at the bottom 🙂
I go with the recommended configuration which is 2 vCPUs and 13 GB of memory, it says that estimated cost will be 142.24 USD by 730 hours per month with 0.195 per hour.
I have deployed my fist HANA Express Edition less than 5 mins.
And ofcourse I have checked my billing status.
More to come…
Cheers,
SarhanPolatates
Hi,
For those interested, there is video tutorial on how to get started on the Google Cloud Platform with SAP HANA, express edition here: https://blogs.sap.com/2017/03/09/getting-started-with-sap-hana-express-on-the-google-cloud-platform-by-the-sap-hana-academy/
Hi Sarhan,
did you manage to connect an HANA Express tenant database created on Google Cloud Platform from HANA studio? I have no problems to connect to the SYSTEMDB and create a tenant database but can't manage to connect to it. I tried to add specific firewall rules as the tenant is listening to a different port but no success.
If it is working for you which settings did you change in order to get this successfully done?
Thank you in advance for any advice!
Kind regards,
Lars
Hi Lars,
I have only changed the default pass of user SYSTEM and tried to connect the host located on GCP with db user SYSTEM however host unreachable 🙁 I am keeping explore.
Sarhan
Hi Lars,
I think this is good read by Craig Cmehil https://blogs.sap.com/2017/03/08/google-app-engine-meets-sap-hana-express-edition/
Cheers,
Sarhan.
Hi Sarhan,
thank you for keeping me updated on your progress.
So far I either had no success in connection a tenant database to HANA Studio.
I haven't found any tutorial so far which proves that it is at least possible to connect to a HANA Express tenant database at Google Cloud Platform via HANA studio .
It might be possible that the Google Cloud Platform Launcher is just a proof of concept that you can launch an instance at the platform without any specific practical use-cases in mind yet. The announced partnership is relatively new and it could be possible that this is just a tiny step on the journey ahead to set up the cloud environment.
Cheers,
Lars
Hi Lars,
a good chance is GCP firewall prevents you from successful connection.
As per admin guide - tenant DB uses tcp ports 39040..309099 for SQL connections https://help.sap.com/viewer/6b94445c94ae495c83a19646e7c3fd56/2.0.01/en-US/440f6efe693d4b82ade2d8b182eb1efb.html#loio440f6efe693d4b82ade2d8b182eb1efb
By default these ports are closed, to make them open you want to add a new rule in https://console.cloud.google.com/networking/firewalls/
and then add it to the network tags in you GCP VM instance details (no restart is needed).
I found this approach has fixed the issue for me.
Anton
Hi folks,
Did you also have problems using XS? I tried to use this command and it says to be unavailable in this instance 🙁
same here. how do i install XSA on google cloud ? I have installed HANA Express Edition already, but when i run XS command - it throws error
regards,
Vivek
I researched the SAP tutorials and found this link: https://www.sap.com/developer/tutorials/hxe-gcp-getting-started-launcher.html. According to him, XSA is not implemented in this version of GCP using the rapid setup... 🙁
Hey Raphael,
Correct, its not there, I have downloaded the binary which is hxexsa but unable to find the installer what i need to run.
Hi Vivek.
You can traverse to /<dir>/HANA_EXPRESS_20/DATA_UNITS/HDB_LCM_LINUX_X86_64 and run ./hdblcm
You can follow the instructions to update the xsa component.
Cheers,
Radha
Good aftrnoon,
I need help. I have installed the HANA Express in google cloud platform, how can I connect a HANA Express tenant database created on Google Cloud Platform with my local installed HANA studio ?
thank you.