Skip to Content
Author's profile photo Paul Hardy

Murder on the HANA Express

Murder on the HANA Express

I am beginning to think they all did it.

On Monday the 21st of August 2017 there was (a) a huge total eclipse of the sun all over North America and (b) SAP Code Jam in Sydney, Australia. This time it was all about HANA Express edition (the code Jam, I don’t think the sun cares much one way or the other).

As you may know the basic premise – as it was explained to me initially – was that you could have a fully functioning HANA system on your laptop, rather like you used to be able to download a trial ABAP version, or even a potted ERP system. As we also know HANA is more than a database, so you would also get the associated supporting framework, or at leats 90% of it, including the XS development environment.

I go Week

Life is crackers at the moment. At work I spent the week trying to explain to my colleagues about inheritance and test driver development, and in my spare time judged some entries for the Google / SAP “intelligent app” contest. I cannot say too much about the latter till the results are out, but one of the applications was about carrots.

This week it was the SAP Code Jam, this will be followed by two days of “Ariba Live” at the Sydney International Convention Centre. I get a free ticket to that as an SAP Mentor which makes me jump for joy, B2B has always been a core interest and I was involved in a Ariba project some years back. I will be blogging about the Ariba event after it ends.

If that was not bad enough there are also two webcasts to be attended both at 6AM my time, one about the latest release of S/4 HANA, one the monthly Mentor Town Hall, where I will be giving a five minute speech about giving speeches….

OK, that is enough waffling for the time being, let us return to the subject of HANA Express, it’s gorgeous, it’s a self-made millionaire, and it isn’t easy for when it gets together it can be MURDER.

The Orient Express (2)

In order to maximise the useful time on the actual day everyone who registered for the event got detailed instructions on how to download the software, to prevent having to sit around on the day watching a progress bar.

Oh No, Not the Sonic Oscillator!

I am not a proper IT person, especially when it comes to web development, or anything cloudy, which is why I suppose I go to these events, to try and bridge that gap with Cadbury’s Snack.

What I do get puzzled by is the never ending range of tools with silly names like “PUTTY” or “DATABASE BEAVER” or “SQL SQUIRREL” or “HYPERVISOR” all of which I encountered today.

The instructions tell you to download the Sonic Oscillator and then deploy it to the Zen Room, and I find myself all at sea. Of course, SAP being SAP, you also have to keep jumping from web page to web page to follow the steps.

Anyway, first off I found a diagram telling me what version of HANA Express I wanted. There are fifty four billion options, but the diagram boiled down to one box asking “Do you have a Windows PC or a Mac?” and an arrow saying “yes” pointing to another box saying “You want the Virtual Machine Edition”. Even I could follow that diagram.

Then there was a page with three options at the top – download to local machine, Windows, Mac or Generic, and some other options for cloud providers at the bottom. I thought the idea was to download it to your local machine so choose Windows.

I then downloaded the HXE installer, it took no time. Then it would not run as it said I did not have Java on my computer. That error message turned out to be a thumping great lie; I did not have 64 bit Java on my PC, only 32 bit, as Internet Explorer does not work with 64 bit. I prefer Chrome, but recently, seemingly out of the blue, it gives me a security error for every single website. I read they had some sort of falling out with Symantec who makes the web site security certificates.

Anyway if you download the 64 bit version from the Java page it (a) takes lots of attempts as the download system detects you have a 32 bit browser and so helpfully changes the choice you made, presuming you had made a mistake and (b) once you are actually allowed to get the choice you made everything is clever enough to have two versions of Java which do not seem to interfere with each other.

Then the choice was to download the “server only” version of HXE or the “server + applications” which gives you XS as well which is recommended if you like “custom development”. Since custom development is what this is all about (in my eyes at least) that was the version I choose and it took a fair old while to download.

By this point I was actually at the event, and used my “Hypervisor” to “power up” my “virtual HANA machine” using an “ovary” file which is what the HXE installed had downloaded and took up a bucket load of space.

At that point I got told I did not have enough physical memory (My PC has “only” 4GB) so the virtual machine option was not in fact an option. The guy sitting next to me ran into the same problem. No worries we were told, really we wanted the cloud version which you installed at the click of a button. So it seems this is not about installing HANA Express on your local machine at all, other than in the sense that a bookmark in your browser resides on your local machine.

Google was the cloud provider of choice. They ask for your credit card details, but give you a $300 dollar credit and promise not to charge you until that runs out (three months) and even then not without your permission. I can live with that.

After a few button presses I had an instance up and running. I followed the instructions and logged into the DOS style command box, and set the password. It reminded me of when I was fourteen.

Hooray! Now was the time to do some development! Whoo Hoo! Here come the bulls! Then I ran into what I call the “life cycle” problem.


In one cartoon Snoopy describes talking to a Mayfly, who only lives 24 hours. Snoopy asked if the fly had any regrets and it said “I wish I knew at four o’clock, what I know now”.

Software life cycles have reduced to similar periods, so much so that by the time you understand how to best use a new product it is obsolete, leading to the situation where nobody knows how to use anything, apart from stuck in the mud ABAP people creating classic DYNPROS. There was a science fiction story about this many years back, though ABAP DYNPRO programming was not specifically mentioned.

In this case the artist formerly known as XS, where you developed using the HANA Studio has now become XSC (the C standing for “classic” in others words “dead”).

Instead we now have XSA (A for advanced) and this works using the SAP WEB IDE (just to confuse matters many people called the HANA Studio the SAP WEB IDE as well) which is based on “Cloud Foundry” which means a complete shift in architecture.

Craig said that whilst the new architecture was far better (more stable) as it was based on micro-mouse-services this also made it more complicated as you have to think about design a lot more.

So there were 3 options for me to proceed if I wanted to start developing on my “local” HANA express.

The first option was to use “Classic” XS and the HANA Studio. All good, except that the Google option I was taking no longer supports such outdated technology, so I could not take that option. These days SAP tells people not to touch “classic” XS with a ten foot bargepole, it is so ten minutes ago.

Another option would be to use the new XSA along with the Web IDE, but that is not available on the Google option I was taking, as it is too new. It will be available “next week”.

This sort of thing is more common than you might imagine, and not just in the IT sphere. Here in Australia there are many stories of business being forcibly removed from their old internet / phone system as it is obsolete and to be replaced by the National Broadband Network, and then when they ask for a replacement NBN connection being told it is not ready yet.

In that case they rely on mobile phones, and there is a way around the HXE problem also. There is a third option where you use one of the tools with funny names like “DB Beaver” or “SQL Squirrel” as a development environment as they can connect to a HANA database using JDBC or similar.

As this is an interim workaround, it did not seem of anything other than academic interest so I did not bother. To be fair it was possible to manually add the XSA framework by going through ten million manual steps, and one guy managed this, but I am really lazy so I think I am going to wait for “next week”.

When “next week” comes I will have another crack, and report back my findings.

Cheersy Cheers



Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Christopher Solomon
      Christopher Solomon

      Great read as always!!!.....and further reaffirms why I never install anything at home for any SAP "trial" this or "local" that. I can find better ways to burn away hours of my life with no real feeling of accomplishment in the end. haha


      Author's profile photo Jelena Perfiljeva
      Jelena Perfiljeva

      Glad to know it's not just me. 🙂

      Great blog, Paul! I find myself irritated by the funky software names as too frequently it appears like a path to Idiocracy. (When I heard about "putty" I thought surely that was a joke.) But maybe I'm just getting old...

      Author's profile photo André Schaarschmidt
      André Schaarschmidt

      Just checked the first release notes entry of "PuTTY". (

      "These features were new in 0.45 (released 1999-01-22): ..."

      Surprisingly old for a piece of software nowadays.
      So the chances you and "PuTTY" could have met earlier, had been there. 😉


      Author's profile photo suratha rajan
      suratha rajan

      Great Read !!


      "The Snoopy Statement", Its a common phenomenon in mid stages of software lifecycle,

      Same story in one of the features that SAP partner company "Mocana" promised geofencing . Wherein they stopped to support anymore in the middle of the software lifecycle but other features were still prevelant.

      Now the solution is to move to HANA as it has this geotracking and geofencing features built in.

      I guess, What we need here is more expertise on decisions to make at end of each software cycle way ahead and be clearly informed. . 


      Author's profile photo Craig Cmehil
      Craig Cmehil

      Hey Paul, took me a bit to stop laughing here after reading it, always a treat to read your posts! Was great seeing you yesterday! I did want to address a couple of points you made just in case there were any questions.

      First I'm sorry your machine was  not able to run the VM as they are the easiest to get going and you do end up with your local "download" and not just a browser URL. The Server Only VM is set for 8GB of RAM so anyone with 8GB or more on their laptop would be good to go and the Server+Applications needs at least 16GB so anyone with 16GB or more on their laptop would be good to go as well.

      The various cloud providers like Google, Amazon, etc are the alternative for those without the necessary memory requirement or for those who don't want it to run locally. Intel also has the powerful Nuc platform (I have that at home)

      For the differences in the Server Only and Server+Applications - that one is one were we see people torn on a regular basis - for one the Server+Applications as all the features of the Server Only version but also the XSA environment. If you go with the Server Only there are so many things you can develop and work on - like Machine Learning ( now with the Server+Applications you can do all of that AND you can build your own XSA based applications (

      In terms of connecting to your instance, although the names are "funny" they are not work arounds but rather another tool that can be used (in addtion to SAP HANA Studio or SAP WebIDE for HANA if you have the +applicatons version) to access all of the text analytics, predictive and now machine learning features of the system ( in trying to be open and versatile in our approach to the platform it tends to result in a multitude of blogs, pages, links and ways of working with it :-/ I'm sure there is a colorful phrase out there for this xxxx if you xxxx if you don't? 🙂

      Hopefully you still got a good deal out of it and an update on XSA and cloud providers, beta testing has wrapped up so next steps are very close now.

      Author's profile photo Mike Howles
      Mike Howles

      Awesome and funny read 🙂


      I was an "early adopter" of HXE "way back" in October of 2016.  So I spent my freetime learning and using HXE 1.0 on an Intel NUC as many others have.


      ...Only to now see that there is an HXE 2.0 where the admin cockpit and fleshed out XSA are so radically different than previous incarnations that I am left wondering if I was in the "just too late, yet just too early" grey area, as well.

      Author's profile photo Elliott Bajema
      Elliott Bajema

      Great read, Paul.

      A lot of things hit close to home here, especially liked:

      Software life cycles have reduced to similar periods, so much so that by the time you understand how to best use a new product it is obsolete, leading to the situation where nobody knows how to use anything...

      Although frustrating, I love trying little weekend tasks like this as they usually force me to 'level-up' in different areas, particularly basis and general command line hackery. Gives a new appreciation for those conversations where you're tempted to say "Okay, just install it then we can start working!".