The Data Provisioning Agent, also called DP Agent, hosts all SAP HANA smart data integration 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.
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!