Getting Started with SAP HANA Express on the Google Cloud Platform – by the SAP HANA Academy
Update Sep 2017
There is a new series of blogs about this topic:
- Getting Started with Google Cloud Platform
- Initial Setup and Secure Configuration
- Start and Stop SAP HANA
Introduction
In a previous blog, I explained how you can use the SAP Cloud Appliance Library to run SAP HANA, express edition in the cloud. For this solution, the available cloud providers are Amazon Web Services and Microsoft Azure.
As recently announced, a new option is now available: Google Cloud Platform (GCP).
You can sign up for a free trial and get to spend $300 on Google Cloud Platform for one year. The developer license for SAP HANA, express edition, of course, remains free (for up to 32 GB).
A 4 vCPU / 26 GB virtual machine runs for about $ 0.30 cents an hour. So, that’s about 1,000 hours of development, free of charge.
The console of the Google Cloud Platform is very intuitive, easy to use. For those familiar with Amazon Web Services and Microsoft Azure, you will be up and running in no time.
There is world wide coverage, you can select all the available geographical zones to host the VM.
SAP HANA Academy
So what are the steps you need to take?
In the tutorial video below, I show you how you can sign up for the free Google Cloud Platform trial, how to start and configure a virtual machine for SAP HANA, express edition, and how to interact with the SAP HANA database on the command line (SSH) and access HANA XS in your browser.
Resources
For the full playlist about SAP HANA, express edition, see http://bit.ly/SAPHXE
For the partnership, see the blogs
- Flexibility, scalability, speed: SAP and Google announce strategic partnership by Bernd Leukert
- Google Cloud and SAP forge partnership to develop enterprise solutions by Nan Boden
For SAP HANA, express edition, see https://www.sap.com/developer/topics/sap-hana-express.html
For running SAP solutions on the Google Cloud Platform, see https://cloud.google.com/sap/
Lucia Subatin has published a number of blogs about SAP HANA, express edition and the Google Cloud Platform. See Five stars to SAP HANA Express Edition on Google Cloud Platform and also, from the Tutorial Catalog: SAP HANA, express edition, in Google Cloud Platform Launcher.
Thank you for watching
The SAP HANA Academy provides free online video tutorials for the developers, consultants, partners and customers of SAP HANA.
Topics range from practical how-to instructions on administration, data loading and modeling, and integration with other SAP solutions, to more conceptual projects to help build out new solutions using mobile applications or predictive analysis.
For the full library, see SAP HANA Academy Library – by the SAP HANA Academy
For the full list of blogs, see Blog Posts – by the SAP HANA Academy
- Subscribe to our YouTube channel for updates
- Join us on LinkedIn: linkedin.com/in/saphanaacademy
- Follow us on Twitter: @saphanaacademy
- Google+: plus.google.com/+saphanaacademy
- Facebook: facebook.com/saphanaacademy
Excellent. Now I am just waiting for the SAP/Google cooperation for an Android Fiori SDK.
Hi Denys,
did you manage to establish a connection to a tenant database on GCP via HANA studio?
I want to work with the PAL in HANA Express via GCP and find no solution to get this running.
Kind regards,
Lars
Hi, I've imported and extracted hxexsa.tgz on GCP, but I'm not able to insall XSA.. where is the script ?
Hi Denys,
I’d like to echo Lars’s question above.
Was able to get this setup super quick, but for some reason HANA Studio seems unable to connect to Tenant DBs, even though SystemDB is fine, and hdbsql can operate on the Tenant no problem.
EDIT: Lucia Subatin has answered this in the comments section of this blog.
Requires adding your static IP to public_hostname_resolution under global.ini in the Admin/Config tab. Thanks!
Kind Regards,
-Elliott
Thanks,
Great topic for a tutorial. 😉
The Academy team is doing a bit of travel this week but after that I"ll look into this.
Denys
Hi Sid,
Good to hear that the Academy has been useful to you and thanks for watching.
To avoid any misunderstandings, this URL/port concerns the SAP HANA Web-based Development Workbench (XS classic), not the SAP Web IDE for SAP HANA (XS advanced).
Only the ports of the system database are fixed (albeit configurable), for tenants, you have to query system views.
This is documented in
There is also a note on the topic but this only points to the documentation (for HANA 1 and for HANA 2)
Does this answer your question?
PS for the readers:
For those less familiar with XS classic versus advanced and Workbench versus IDE, see the FAQ disguised as quiz:
Best,
Denys / SAP HANA Academy
Hi Denys, I am trying to find the HANA Express edition solution on GCP, can't find it. is n't it available on Google market place now?
Hi Sreekanth,
It was unavailable for a couple of days, but this has been corrected:
Thanks for letting us know.
D
Yes, Denys, Thanks for your comment. It was back operational after 3 days., no issues now.
Hi Denys, I was trying to find the HANA Express edition solution on GCP for last 2 Days but unable to find it.
Hi Sahil,
SAP HANA express edition is no longer available in the cloud provider marketplaces.
To run HXE on GCP, you would have to use the binary installer and create an image.
Alternatively, and maybe more conveniently, you can use the free trial of SAP HANA Cloud, cf