Skip to Content
Author's profile photo Sarhan Polatates

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

Assigned Tags

      12 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Denys van Kempen
      Denys van Kempen

      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/ 

       

      Author's profile photo Former Member
      Former Member

      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

      Author's profile photo Sarhan Polatates
      Sarhan Polatates
      Blog Post Author

      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

      Author's profile photo Sarhan Polatates
      Sarhan Polatates
      Blog Post Author

      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.

      Author's profile photo Former Member
      Former Member

      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

      Author's profile photo Anton Dyzhyn
      Anton Dyzhyn

      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

      Author's profile photo Raphael Pacheco
      Raphael Pacheco

      Hi folks,

      Did you also have problems using XS? I tried to use this command and it says to be unavailable in this instance 🙁

      Author's profile photo Vivek Singh
      Vivek Singh

      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

      Author's profile photo Raphael Pacheco
      Raphael Pacheco

      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... 🙁

      Author's profile photo Vivek Singh
      Vivek Singh

      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.

       

      Author's profile photo Radha Fogla
      Radha Fogla

      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

      Author's profile photo ayoub TARMOUNIA
      ayoub TARMOUNIA

      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.