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.
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=126.96.36.199
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 188.8.131.52 from 184.108.40.206
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 !!