Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Showing results for 
Search instead for 
Did you mean: 
akhilesh_pandey
Explorer
Introduction:

This blog is about updating the SAP Data Provisioning agent which is also known as “DP Agent” (On windows). The Data Provisioning Agent provides secure connectivity between the SAP HANA database and you’re on premise, adapter-based sources. The DP Agent control all SAP HANA smart data integration (SDI)  Adapters and connections to HANA database. It acts as the communication interface between HANA and the Adapter.

SAP Datasphere allows you to use SAP HANA smart data integration (SDI) and its Data Provisioning Agent to enable on-premise connections. To do this, you first have to download and install the SDI Data Provisioning agent to a network location from which it can establish HTTPS connections to SAP HANA on Cloud.

With latest update of SAP Datasphere, it offers more Adapters – ABAP Adapter, HANA Adapter, MssqlLogReaderAdapter, OracleLogReader Adapter, CloudDataIntergation Adapter, CamelJdbc Adapter.


We will cover the upgrading the Data Provisioning Agent installed on windows box by running the installation program in update mode.

Pre-requisite:

As per SAP recommendation, before upgrading the Data Provisioning Agent, make sure that your SAP HANA server has already been updated to the same version of your target version of DP agent.

To check your current version (On windows): -

  • Open the versions.txt file. The default path to the file on windows is drive:****\dataprovagent\versions.txt and look for dpagent.version to confirm the Data Provisioning agent version. Example : dpagent.version=2.6.1.1


OR

Open windows command prompt and navigate to <DPAgent_root>/bin directory and enter the command to <DPAgent_root>/bin/\agentcli.bat –configAgent,




  • To view the version of DP agent, select Enter Option 11 and that’s shows your current version



 

Execution Steps as below:


Step1. Login to SAP portal - https://launchpad.support.sap.com/ and download the latest available DP Agent version (to download the software follow the patch shared in below screenshot) and extract this to an empty directory.



 

Step2. Stop the running SAP HANA Data Provisioning Agent service, in windows you can do it by using Option1- Services manager in Control Panel and other Option2 by command prompt using DP Agent Configuration Tool. Below screen show for Option 2.

Open cmd and enter the command to <DPAgent_root>/bin/\agentcli.bat –configAgent


further you can validate the services from services.msc

Step3. Now go to the directory where software is extracted & click on hdbinst.exe  and run as  administrator, there you will get list of all selection for existing DP agents installed and new installation option with detailed of there versions, here we are going with existing one and select the option accordingly-


Step4. So here I took option 1 to upgrade the version & further it will ask you to manually enter the Domain\username for agent service  & Password for Agent Service


Here, your upgarde completed and you can check the logs under path –                       C:\Users\****** \AppData\Local\Temp\hdb_dataprovagent_****

Step5. Validation – to check the version and Agent status, you can check with DPAgent Configuration tool - Open cmd and enter the command to <DPAgent_root>/bin/\agentcli.bat –configAgent



**you can check service in windows from servcies.msc as well and perform start/stop of servcies from DP agent configuration tool. Also in windows the agent service is re-created and started automatically

Since, the Agent is already registerd on your SAP Datasphere- you can validate the status by login to SAP Datasphere -> System->Configuration-> Data Integartion -> On premise Agents ->Adapters Tab


 

You will find the status must be green and showing the current updated version i.e 2.6.3.4 from 2.6.1.1

Conclusion:

This concludes the DP Agent upgrade to latest available version installed on windows box.

In Linux – steps will be same just below command will be different  

Start/stop services - navigate to <DPAgent_root>/bin, and run ./dpagent_servicedaemon.sh stop or start  & To start the installation manager run ./hdbsetup

Thanks for reading this article, Looking forward for your valuable feedback and comments !!

Reference:

https://help.sap.com/docs/HANA_SMART_DATA_INTEGRATION/7952ef28a6914997abc01745fef1b607/23b6324923dc4...

 

 
1 Comment
Labels in this area