Skip to Content
Author's profile photo Frank Schuler

Enable Smart Data Integration on your HANA, express edition

After having setup SDI on my HCP account following this excellent blog series by Former Member, 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 Former Member 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:

Assigned tags

      15 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Ashok Babu Kumili
      Ashok Babu Kumili

      Thanks for the blog, the screen shots shared are very helpful. Thank you.

      Author's profile photo Former Member
      Former Member

      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

      Author's profile photo Frank Schuler
      Frank Schuler
      Blog 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

      Author's profile photo Former Member
      Former Member

      Hello Frank,

      Currently I have 12GB assigned to the VM and it is failing . Are there any thing i need to look into in particular.

       

      Thanks,

      NS

      Author's profile photo Frank Schuler
      Frank Schuler
      Blog Post Author

      Hello Noor,

      Did you Upgrade your HANA, express edition as per my respective blog?

      Best regards

      Frank

      Author's profile photo Nancy Smallwood
      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

      Author's profile photo Frank Schuler
      Frank Schuler
      Blog Post Author

      Hello Nancy,

      Did you Upgrade your HANA, express edition as per my respective blog?

      Best regards

      Frank

      Author's profile photo Nancy Smallwood
      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!

      Author's profile photo Axel Mohnen
      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

      Author's profile photo Former Member
      Former Member

      Tenant database with 'dpserver' is not available in HXE version. also, it's mentioned here.

      https://blogs.sap.com/2016/10/27/create-tenant-database-sap-hana-express-sap-hana-academy/

       I tried with HXE SP12 & HXE 2.0 no luck.... 🙁

      Author's profile photo Denys van Kempen
      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

       

       

       

      Author's profile photo Axel Mohnen
      Axel Mohnen

      Hi Denys,

      Thanks for the info.

      Is it possible to do a Data Replication to SAP HXE using Direct Extractor Connection (DXC)?

      The documentation says that  HANA XS Engine is needed, which is included in HXE 2.0.

      https://blogs.sap.com/2014/02/25/data-replication-to-sap-hana-using-dxc-method/

       

      Kind regards

      Axel

       

      Author's profile photo Denys van Kempen
      Denys van Kempen

      Hi Axel,

      You are welcome.

      I have not received any information on the contrary but have not been able to test this. Have you tried it?

      Thanks,

      Denys

      Author's profile photo Axel Mohnen
      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

      Author's profile photo Bill Liu
      Bill Liu

      now hana express edition 2.0 has a script to enable HXE database for SDI readiness and deploy the monitoring tool. check the HXE guide.