SAP HANA, express edition and SAP HANA smart data integration – Complete Tutorial

Task

Setup an environment to try and test the SAP HANA smart data integration on one individual device.

Reason of the Article

There are many documentations available which can be used to achieve the task. The aim of this article to collect these sites together and complete the available information with important details. Also, this is a step-by-step guide which goes through the process.

Definitions

The definitions of the components (Data Provisioning Server, Data Provisioning Agent) and the architecture is available here:

Smart Data Integration available for the SAP Cloud Platform

Architecture

In my scenario I am using Windows 10 operating system on my laptop. I am running SAP HANA, express edition (preconfigured) Server + applications virtual machine on VMware Workstation.

SAP HANA Smart Data Integrator on SAP HANA, express edition (HXE)

Prerequisites

Enable Data Provisioning Server

Enable the Data Provisioning Server to use SAP HANA smart data integration.

Configure the Data Provisioning Server

ALTER DATABASE HXE ADD 'dpserver' AT LOCATION 'hxehost';

In case if needs to revert:

ALTER DATABASE HXE REMOVE 'dpserver' AT LOCATION 'hxehost:39046';

 Download and Install Data Provisioning Agent

To download and install Data Provisioning Agent find the below documentation:

Hana Smart Data Integration – Installing the DP Agent

SAP HANA Academy: SDI & HaaS 02; DP Agent Install

HANA Cloud & SDI ; 04 DP Agent Install / Config

Data Provisioning Agent Service on Windows

The service can be run under Local System user.

Failed to start Dpagentconfigtool

In my case one of the installers were missing (Microsoft Visual C++ Redistributable x64) so I had to download and install it manually.

  • Microsoft Visual C++ 2010 x64 Redistributable
  • Microsoft Visual C++ 2013 Redistributable x64
  • Microsoft Visual C++ 2015 Redistributable x64

Configure Data Provisioning Agent

Setting-up the Data Provisioning Agent to Connect SAP HANA On-premise to SAP HANA Cloud

The configuration can be done only the command line Configuration Tool (Agent version 2.6.1.1).

Note: Data Provisioning Agent Graphical Mode had been deprecated!

Configuring the Agent in Graphical Mode [Deprecated]

——————————————
DPAgent Configuration Tool
——————————————

cd C:\usr\sap\dataprovagent\bin
C:\usr\sap\dataprovagent\bin>agentcli -configAgent
  1. Checking the Agent Version
  2. Setup SAP HANA Connection (JDBC)
  3. Setup Agent Registration
  4. Setup Adapter Registration
  5. Check the registered adapters
  6. Check the configuration

Configure Secure Storage

The configuration can be done by command line tool.

Configure SAP HANA service smart data integration for SAP BTP with the SAP HANA service for SAP BTP

– – > Step 4: Configure an access token

———————————
Secure Storage Utility
———————————

cd C:\usr\sap\dataprovagent\bin
C:\usr\sap\dataprovagent\bin>agentcli --setSecureProperty

Set the File Adapter Access Token “HANAToken”

Prepare a file

Configure SAP HANA service smart data integration for SAP BTP with the SAP HANA service for SAP BTP

– – > Step 5: Prepare a file for upload

This is the default directory in my case. ReadMe.txt and sample file were already in the directory.

C:\usr\sap\dataprovagent\workspace

Create a Remote Source

I have done this step in SAP HANA Studio not in SAP HANA database explorer.

Configure SAP HANA service smart data integration for SAP BTP with the SAP HANA service for SAP BTP

– – > Step 6: Create a Remote Source

I have created a separate REMOTE_DATA schema.

The data is available in SAP HANA server.

Conclusion

To setup and configure the SAP HANA smart data integration on your device is an easy and quick task. In this tutorial I have registered the ExcelAdaper and the FileAdapter but as the list shows there are many other possibilities available.

See Also

Enable Smart Data Integration on your HANA, express edition

Smart Data Integration: HanaAdapter from HANA Express to HANA as a Service

Question

Q&A link for SAP HANA, express edition: https://answers.sap.com/tags/73555000100800000651

Was this useful? Hit that “Like” button and remember to keep encouraging other community members who go out of their way to share their knowledge.