Skip to Content

After having setup SDI on my HCP account following this excellent blog series by Ben Hofmans, I was wondering whether I could do the same on my HANA, express edition. This turned out to be absolutely possible and if fact quite straight forward:

  1. Increase the virtual machine memory to 12GB
  2. Create a tenant database with the Data Provisioning Server enabled
  3. Import the Smart Data Integration delivery unit
  4. Configure the Smart Data Integration agent
  5. Verify the Smart Data Integration agent connection
  6. Create a Remote Source
  7. Create a Virtual Table

To make room for an additional HANA database container, I increase the memory of my HANA, express edition from its the 9GB after the upgrade to 12GB:

Then I log into the HANA Cockpit with my SYSTEM user and automatically get the required roles assigned:

Currently, there is only the SYSTEMDB:

So I create a new tenant database including the dpserver Service:

This can take a while:

But eventually both databases are running fine:

The issues come from the HANA, express edition log mode and can be ignored for such sandbox systems:

After downloading the SDI Delivery Unit:

I can import it into my database tenant:

In my case from the Client:

And after a short while, the import is completed successfully:

With this I create an SDIUSER with the required Application privilege sap.hana.im.dp.admin::Administrator:

And System Privileges AGENT ADMIN, ADAPTER ADMIN and CREATE REMOTE SOURCE:

Then, I determine the SDI tenant indexserver SQL Port:

And connect my SDI agent accordingly:

Which is confirmed working:

Finally, I register my SDI agent with my HANA, express edition:

Which again is confirmed accordingly:

With the Agent Registration being updated:

To verify this on the HANA, express edition side, I register my tenant database for HTTP and HTTPS access:

ALTER SYSTEM ALTER CONFIGURATION ('xsengine.ini', 'database', 'SDI') SET 
('public_urls', 'http_url') = 'http://sdihost:8000' WITH RECONFIGURE;

ALTER SYSTEM ALTER CONFIGURATION ('xsengine.ini', 'database', 'SDI') SET 
('public_urls', 'https_url') = 'https://sdihost:4300' WITH RECONFIGURE;

And adjust the respective database property:

To see the Agent Monitor tile in the HANA Cockpit, my SYSTEM user needs role sap.hana.im.dp.monitor.roles::Monitoring:

Which shows under HANA Data Provisioning Monitoring:

And clicking on the tile, the agent details get displayed:

With this, all SDI functionality is available to me on my HANA, express edition so that I can complete Ben Hofmans blog series locally. For this I first assign my SDIUSER role sap.hana.ide.roles::Developer:

To then start my local HANA Web-based Development Workbench:

Where I create a new remote data source:

On which basis I create a respective virtual table:

To finally access my data file contents in my HANA, express edition catalog:

To report this post you need to login first.

14 Comments

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

  1. Nooruddin Shaikh

    Hi ,

    Nice blog. Just a quick question how could you able to resolve the issue of DPServer while creating the Tenant Database ?

    The creation of Tenant Database is failing when marking the DPServer as a service.

    Appreciate your response.

    Thanks

    Noor Shaikh

    (0) 
    1. Frank Schuler Post author

      Hello Noor,

      For me the creation of the tenant database finished successfully including the dpserver option. Have you assigned sufficient memory to your virtual machine? I tried different amounts of memory and 12GB seemed the minimum to make it work, but with more memory the process was smoother.

      Best regards

      Frank

      (0) 
  2. Nancy Smallwood

    Hi Frank,

    Really great blog post.  I am having the same issue not being able to create a tenant database with the dbserver service.  The VM is setup to use 17G of memory.

    The dpserver alert trace files report “TREXIndexServer.cpp(02040) : Feature not available in HANA Digital Edition. Stopping and disabling service…”  So perhaps we just the wrong version of Hana Express?

    Any help would be greatly appreciated.

     

    Regards,

    Nancy

    (0) 
      1. Nancy Smallwood

        Hi Frank,

         

        I was able to apply the updates for SUSE per the instructions in the “secure your hana express”, but am unable to mount the VM Tools in the “upgrade hana express” blog.

        I stepped away from this task for a few days, so sorry it took me a bit to reply. Hopefully later this week I’ll be able to get back on it and if I continue to have troubles, I will post a comment on the “upgrade hana express” blog.

         

        Thanks!

        (0) 
  3. Axel Mohnen

    Hi Frank,

     

    I install the HXE 2.0 from scratch and tried to following your instructions in order to configure SDI.

    Unfortunately, I have the same issue, couldn’t create Tenant DB with “dpserver”.

    Did you test your solution with HXE 2.0?

    Thanks in advance

    Axel

    (1) 
  4. Denys van Kempen

    Hi,

    Per the Feature Scope Description for SAP HANA, express edition

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

    (https://www.sap.com/developer/topics/sap-hana-express.resources.html)

    SDI is not supported for express.

    You might get it to work, like Frank described for the 1.0 SPS 12 version, but apparently this procedure no longer works for 2.0 SPS 00.

    For SDI, you will need to use the regular platform edition (on premise or hosted).

    D

     

     

     

    (0) 
  5. Axel Mohnen

    Hi Denys,

    not yet, but I will start as soon as I have pimped my Laptop with new RAM 😉

    I will let you know….

    Kind regards

    Axel

    (0) 

Leave a Reply