Get your SSH keys to HANA Express instance in Google Cloud Platform

You’ve been watching this SAP CodeTalk or following this tutorial on how to setup your SAP HANA, express edition, (or HXE) with the Google Cloud Launcher. Now you would like to connect to the instance from some SSH client, such as PuTTY or the console on your Mac or Linux computer.

You need the SSH keys, but where are they? If this is your first project and you have not generated your keys before, chances are that you won’t find them in your .ssh folder as this tutorial indicates:

SQL Clients and SAP HANA 2.0

So recently I’ve been playing around a lot with our “Server Only” version of the SAP HANA, express edition (HXE). Now with that server only version I am mainly focused on just using more of the Database features than anything else. Trying SQL and working with the PAL libraries.

With our activities and ability to quickly load HXE into the Google Cloud Platform I also thought how else could I speed of some of my time. I mean I am only working with SQL on some of these things so could I use the JDBC driver and find a tool that would do nicely for it?

I’ve now tried a good half a dozen or so and decided that the current one I will play with the next few weeks would be DBeaver.

How to configure transports of XS Classic native applications

I recently needed to configure the transports of Delivery Units between a SAP HANA, express edition, (HXE)  instance in Amazon Web Services and one of my tenant databases in another HXE instance in Google Cloud Platform.

My destination HXE instance (some kind of QA environment) was originally a server-only to which I added the XS classic tools as explained in this how-to guide . The source instance plays the Dev environment in this scenario.  I wanted to transport from Dev into QA without manually exporting and importing Delivery Units.

In order to configure the transports and access the ALM tools you will need the following roles in the source/Dev system:

• sap.hana.xs.lm.roles::Administrator
• hana.xs.admin.roles::HTTPDestAdministrator
• hana.xs.admin.roles::RuntimeConfAdministrator

Five stars to SAP HANA Express Edition on Google Cloud Platform

Ever since I installed my SAP HANA, express edition (HXE), instances on Google Cloud Platform I have been using them as my main platforms for development and different experiments. My experience has been so good that I feel it has to be shared so others do not miss on it.

What I like about Google Cloud Platform (GCP) is that it makes it extremely easy to get my SAP HANA instances up and running when and how I want them.

The web SSH client and GCloud console stand out as a star feature. Two clicks and you are logged in to the operating system, ready to cast some commands using the web interface.