As soon as I learned about SAP to Unveil SAP HANA 2, I wanted to get my hands on it, and with the release of the HANA 2, express edition this is in fact very easy. Had I not previously registered with SUSE to Secure my HANA, express edition, I would have just started from scratch with a new Virtual Machine Image. But since I have and would like to preserve it, I take a different approach:

  1. Increase memory to 8 GB
  2. Download Binary Installer
  3. Create temporarily user
  4. Uninstall HANA 1
  5. Install HANA 2
  6. Connect to HANA 2 Cockpit

In order to allow for the upgrade to HANA 2, I have to increase the memory of my virtual machine to 8 GB:

Then I download the Binary Installer with the HANA, Express Edition Download Manager 2.0:

And unpack it into a temporary location:

Next I create myself a temporary user, since user hxeadm will be temporarily deleted in the process:

Leveraging my temporary user, I uninstall HANA 1:

And subsequently install HANA 2 from the temporary location with instance number 00 to reuse my HANA Studio settings and browser bookmarks:

The base install can take a while, but eventually the resident hdblcm and AFL get installed:

So that the installation finishes successfully. Interestingly, the HANA 2, express edition comes already with a tenant database:

In HANA Studio, I can log into my 2.00.000.00 system including the AFL:

To explore the HXE tenant database, I connect the system to my standalone HANA 2 Cockpit and in fact see a second database Not running:

So I attempt to start it:

And in fact, after a short while, it is running just fine:

So that I can connect and monitor it from my standalone HANA Cockpit as well:

From here I will continue to explore the further options. Please send me any of your own discoveries and feedback.

Very best regards and thank you in advance

Frank

To report this post you need to login first.

6 Comments

You must be Logged on to comment or reply to a post.

  1. Ayman Salem

    Hi Frank,

    I have tested HANA Express 2.0, and I’ve found that some roles no longer exist.

    “sap.hana.admin.roles::Administrator” and “sap.hana.admin.roles::Monitoring”.

    HANA Express 2.0                                         HANA Express 1.0.12

    Missing those roles, prevent the activation of some delivery unit that need it.

    Example: When importing the “Smart Data Integration” delivery unit, it stops by activation with error:
    Can you confirm that you have the same error?

    Ayman

    (0) 
      1. Ayman Salem

        Hi Frank,

        It was SDI version 1.0 SP02 Patch 03.    I know this was for HANA 1.0, but I just tried to test it on my HANA Express 2.0 test env.

        I have found that the problem with roles is normal, as in “What’s New in the SAP HANA Platform 2.0 (Release Notes)” Document under “2.2.2 SAP HANA Database Security (New and Changed) / Authorization (New and Changed)”

        ….

        The following roles delivered in the these DUs are therefore no longer available:
        sap.hana.admin.roles::*
        ○ sap.hana.admin.cockpit.sysrep.roles::SysRepAdmin
        ○ sap.hana.backup.roles::*
        ○ sap.hana.security.base.roles::*
        ○ sap.hana.security.cockpit.roles::*
        ○ sap.hana.admin.cockpit.sysdb.roles::SysDBAdmin

        Still, it does not work for me even with the new version SDI 2.0 (which is available https://support.sap.com/content/dam/library/ssp/infopages/pam-essentials/TIP/PAM_HANA_SDI_2_0.pdf) because it requires “dpserver”, which is not possible to add it to the HANA Express 2.0 version.

        Thanks,

        Ayman

        (0) 
        1. Denys van Kempen

          Hi,

           

          HANA express is a multitenant system so you would need to add the dpserver to a tenant. Can you confirm that this is not possible?

          The roles are removed because with HANA 2, cockpit is no longer embedded into HANA but runs on a separate system (HANA express). So to administer HANA express with HANA cockpit, you need two systems. Have you tried installing SDI cockpit part into the cockpit system and the HANA part into the tenant on the HANA system?

          D

           

           

           

           

          (0) 
          1. Adriaan van der Bank

            I can confirm the same problem when trying to add a DP server to the tenant of a newly installed HXE 2.0. It would be quite unfortunate if SAP now disallow the use of SDI.

            ALTER DATABASE HXE ADD ‘dpserver’

            Feature not available in HANA Digital Edition 

            (0) 
            1. Denys van Kempen

              Thanks Adriaan,

              Interesting: “HANA Digital Edition”. There is no reference to this “edition” in any public documentation.

              According to blog Enable Smart Data Integration on your HANA, express edition, SDI could be enabled for HANA 1 but appears no longer to work for HANA 2.

               

              Another reference to this digital edition is mentioned in blog Getting started with Predictive on SAP HANA, express edition; here updating express to the latest version solved the issue.

              You try to download the latest version of the express VM (the download is updated regularly).

              However, according to the Feature Scope Description document for express, SDI is not supported.

              https://www.sap.com/documents/2016/09/3e24cc42-8a7c-0010-82c7-eda71af511fa.html

               

               

               

              (0) 

Leave a Reply