Technical Articles
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
- SAP HANA Smart Data Integrator on SAP HANA, express edition (HXE)
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.
- Frequently Asked Questions About SAP HANA®, Express Edition
- Server + Applications: SAP HANA, express edition and XSA – by the SAP HANA Academy
- SAP Help Portal – SAP HANA, express edition
- SAP Help Portal – Getting Started with SAP HANA 2.0, express edition (Virtual Machine Method)
- SAP Help Portal – Getting Started with SAP HANA 2.0, express edition (Virtual Machine Method) – PDF
Prerequisites
- Hypervisor (VMware Workstation Player 16)
- SAP HANA, express edition (version: 2.00.057)
Install SAP HANA 2.0, express edition on a Preconfigured Virtual Machine (with SAP HANA XS Advanced) - SAP HANA Studio (version: 2.3.63)
- Frequently Asked Questions About SAP HANA®, Express Edition
- Server + Applications: SAP HANA, express edition and XSA – by the SAP HANA Academy
Enable Data Provisioning Server
Enable the Data Provisioning Server to use SAP HANA smart data integration.
- Configure the Data Provisioning Server
- 2568617 – How to enable and add dpserver
- 2514575 – How to enable the Data Provisioning Server? – SAP HANA Smart Data Integration
ALTER DATABASE HXE ADD 'dpserver' AT LOCATION 'hxehost';
In case if needs to revert:
- 2812710 – How to disable Data Provisioning Server in Multi-database Container Scenario
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
- 2916079 – Failed to start Dpagentconfigtool due to error: Failed to load the JNI share library – SAP Smart Data Integration
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
- Checking the Agent Version
- Setup SAP HANA Connection (JDBC)
- Setup Agent Registration
- Setup Adapter Registration
- Check the registered adapters
- 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