This blog post would guide you through setting up and configuring Data Provisioning agent (DP agent) for SAP Data Warehouse Cloud. SAP Data Warehouse Cloud leverages SAP HANA smart data integration and its Data Provisioning Agent to establish connection to on-premise data sources.
Data Provisioning Agent:
The Data Provisioning Agent, also called DP Agent, hosts all SAP HANA smart data integration Adapters and acts as the communication interface between SAP HANA, on which the SAP Data Warehouse Cloud is built. We can think of the DP Agent as the road infrastructure, while the connection between your systems and SAP Data Warehouse Cloud is the vehicle that transports the data to your data warehouse.
The DP Agent is installed on a server which belongs to the same network area as the on-premise system which has to be connected to SAP Data Warehouse Cloud.
Download DP agent:
Download the latest version of DP Agent from SAP Support Portal.
SAP Software Download Center > Support Packages and Patches > By Category > SAP IN-MEMORY (SAP HANA) > HANA PLATFORM EDITION > SAP HANA SDI > SAP HANA SDI 2.0 > COMPRISED SOFTWARE COMPONENT VERSIONS > HANA DP AGENT 2.0 > Latest Patch
(Below is the latest download as of 10/2020)
Install DP Agent:
Unzip the downloaded DP Agent file to any folder. Right-click on file “hdbsetup.exe” in the folder “HANBA_DP_AGENT_20_WIN_X86_64” and choose “Run as an administrator”
Choose the folder where DP Agent needs to be installed
Enter a name for the DP Agent
Username / Password for agent service should be operating system login credentials
Continue with the next steps
Register DP agent on SAP Data Warehouse Cloud:
Logon to SAP Data Warehouse Cloud tenant
To register a new Data Provisioning Agent, click “Create Agent Communication Credentials” and enter the new Agent Name
The next screen displays SAP HANA Server Information, user and password to register the Data
Provisioning Agent with SAP Data Warehouse Cloud. (Please leave this screen open) as we would need to input this information while configuring the DP Agent
Go to “<DP Agent Installation folder>/bin” and run the command
Enter option 2. Start or Stop Agent
Enter option 1. Start Agent
Enter option b to go back to the previous screen
Enter option 1. Agent Status – This confirms if the agent is running
Choose option 6: SAP HANA Connection
Choose option 2. Connect to SAP Data Warehouse Cloud via JDBC
Please copy and paste the details from SAP HANA Server Information screen in DWC.
Input true for ‘Do you want to save these connection settings? Any existing settings will be overwritten’. This will write entries into the dpagentconfig.ini file
Stop and Start the DP Agent again
Option 2. Start or Stop Agent
Option 2. Stop Agent
Option 1. Start Agent
Close the Agent setting window open on DWC tenant
Upon successful connection establishment, we would see the connected icon against the data provisioning agent.
Enable the adapter that would be required
In this blog post we learnt how to install and configure Data Provisioning Agent for Data Warehouse Cloud.
Please leave the comments/questions that you may have in the section below.