How to Connect a Data Provisioning Agent
Continue your learning journey in the SAP Data Warehouse Onboarding Guide!
The Data Provisioning Agent, also called DP Agent, hosts all SDI Adapters and acts as the communication interface between HANA, on which the SAP Data Warehouse Cloud is built, and the Adapter. You 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.
Let’s now look at how to connect a DP Agent to SAP Data Warehouse Cloud that is run on HANA.
WHITELISTING THE DP AGENT
When connecting the data provisioning agent to SAP Data Warehouse Cloud, the public, external facing IP address of the server the data provisioning agent is installed on has to be whitelisted in SAP Data Warehouse Cloud. Unless the IP is whitelisted the data provisioning agent cannot connect to SAP Data Warehouse Cloud and the agent’s status will stay disconnected.
Only when the IP is whitelisted the agent can be connected once configured correctly and the configured adapters can be used in SAP Data Warehouse Cloud. The whitelisting of the public, external facing IPs of any client that connects to SAP Data Warehouse Cloud is a mandatory prerequisite for security reasons as described in note SAP Note 2894588 – IP Whitelisting in SAP Data Warehouse Cloud.
CONFIGURING THE DP AGENT
After logging in, go to the Administration tab, where you’ll get the list of the registered agents.
Click on Create Agent Communication Credentials in order to create a new agent.
Create an Agent name.
The Agent settings will appear. You’ll get all the necessary details which you will have to enter into your local agent’s configuration:
- the HANA Server
- the HANA Port
- HANA via JDBC
- HANA use SSL
- your HANA User name for Agent Messaging
- your HANA User password for Agent Messaging
Please note: Adapters can only be registered or unregistered when the agent is connected.
CONNECTING THE DATA PROVISIONING AGENT
In order to now connect to the data provisioning agent, log into the machine in your network where the agent is installed. Ensure to use a dedicated user to install and start the DP agent with the minimal set of authorization required to work with the agent to avoid security issues. In this example, I’ve installed the agent on a machine running in my local network. I’m using a dedicated user dpagentadmin to log into the machine.
Enter your password and then navigate to the location where the agent is installed.
You can see that the directory contains all the necessary files, including the configuration file. And this is where we will maintain all the configurations.
Starting with the Agent’s name, copy from the generated Agent settings in SAP Data Warehouse Cloud and insert it into the configuration table.
Next, is the HANA information. You can copy and paste all the relevant information into your configuration. Please note: the host and port information must be entered twice.
Save the file.
Now you’re ready to start the agent, using the config agent property.
Please note: starting the agent can take a few moments based on how big or small your machine is.
Once it starts, you can see the Agent name, as well as the Server and Port.
Next, set the username and password. Again, you can simply copy and paste it over from the generated Agent settings in SAP Data Warehouse Cloud. You might not see on the screen what you typed, but that’s ok. It is still reacting.
Now, restart the agent for the changes to take effect. This might again take a little while.
Check the status and wait until the agent is running.
This is everything we need to do in the machine. Now, go back to the UI of SAP Data Warehouse Cloud.
Enable the Agent Adapters you would like to use by clicking on them.
Refresh the registered agent list, and you’ll see that the agent is now connected.
Now, you can create a new connection: go to the Connection tab on the left-hand main menu, through the ABAP system, for instance. And using the agent you just installed.
And that’s it. The connection was successfully created.
And then, of course, check if the connection is valid, by clicking on the status symbol to the left of your new connection.
That’s it! Congratulations!
To read more about connecting SAP Data Warehouse Cloud to S/4 HANA & (OnPremise/Cloud)SAP HANA, click here.
To learn more about connection types, click here.
Please note: from version 2021.04 on, users can directly connect to SAP S/4HANA Cloud Edition tenant. From now on, there will be dedicated connection tile for SAP S/4HANA Cloud Edition, making it easier to connect. The connection can be used for federated and replicated data access in View Builder and Data Flow.
To connect to SAP S/4HANA Cloud Edition, user can select the tile “SAP S/4 HANA Cloud” while creating new connection in Space.