Monday 24 October 2016

Enable Smart Data Integration on your HANA, express edition

  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
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:
SAP HANA Certification

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

Enable Smart Data Integration on your HANA, express edition

Currently, there is only the SYSTEMDB:

Enable Smart Data Integration on your HANA, express edition

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

Enable Smart Data Integration on your HANA, express edition

This can take a while:

Enable Smart Data Integration on your HANA, express edition

But eventually both databases are running fine:

Enable Smart Data Integration on your HANA, express edition

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

Enable Smart Data Integration on your HANA, express edition

With this I can import the SDI Delivery Unit into my database tenant:

Enable Smart Data Integration on your HANA, express edition

In my case from the Client:

Enable Smart Data Integration on your HANA, express edition

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:

Enable Smart Data Integration on your HANA, express edition

And System Privileges AGENT ADMIN and ADAPTER ADMIN:

SAP HANA Materials and Certifications

Then, I determine the SDI tenant indexserver SQL Port:

Enable Smart Data Integration on your HANA, express edition

And connect my SDI agent accordingly:

Enable Smart Data Integration on your HANA, express edition

Which is confirmed working:

Enable Smart Data Integration on your HANA, express edition

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

Enable Smart Data Integration on your HANA, express edition

Which again is confirmed accordingly:

Enable Smart Data Integration on your HANA, express edition

With the Agent Registration being updated:

Enable Smart Data Integration on your HANA, express edition

With this, all SDI functionality is available to me on my HANA, express edition.

Source: scn.sap.com

No comments:

Post a Comment