SAP Data Warehouse Cloud & SAP BW/4HANA Model Transfer – Part 3

In the first blogs on this topics, we ensured that our SAP BW/4HANA System is up-to-date, and we configured a Tunnel connection from SAP Analytics Cloud to our SAP BW/4HANA System.

As next step we need to setup the DP Agent.

SAP Data Provisioning Agent (DP Agent) Installation

You can find also the installation details here.

1. Logon to the SAP Support portal to download the software for the DP Agent – https://support.sap.com/en/my-support/software-downloads.html
2. Logon with your credentials.
3. Go to the option Support Packages & Patches
4. Click on Access Downloads
5. In the search box at the top enter the search terms HANA DP AGENT.
6. Select the entry HANA DP AGENT 2.0 from the search result.
7. Ensure you select your operating system. In my example, I am using a Windows Server 2016.
8. Download the most recent version of the DP Agent.
9. Unzip the downloaded file.
10. Before you start the installation, please ensure – for Windows operating system – that these are installed:
    • Microsoft Visual C++ 2013 Redistributable x64 -https://support.microsoft.com/en-us/help/3138367/update-for-visual-c-2013-and-visual-c-redistributable-package#:~:text=When%20you%20use%20Microsoft%20Visual%20C++%202013,%20you,redistributable%20package,%20binaries%20for%20non-target%20architectures%20are%20removed.or
    • Microsoft Visual C++ 2015 Redistributable x64https://www.microsoft.com/en-us/download/confirmation.aspx?id=52685see also the following SAP Note: https://launchpad.support.sap.com/#/notes/0002916079
11. Start the installation of the DP Agent.
12. In my example, I am using the folder \usr\sap\dataprovagent as installation folder.

11. I am then being asked to provide the details for my DP Agent installation.
12. I use the following details:
    • Agent Unique Name: DPAGENT02
    • I use an administrative user account to start the service
    • I leave the rest with the default values.

When the installation is finished, I restart the system and then start the DP Agent. In my example, as we are using Windows 2016 as operating system, the DP Agent is also being installed as a service.

IP Whitelisting

We will need to whitelist the IP number for our DP Agent. In my example the DP Agent runs on AWS, so I will whitelist the external as well as the internal IP number.

1. Logon to your SAP Data Warehouse Cloud tenant.
2. Navigate to the bottom left and click on Administration.

3. Click on the tab IP Whitelisting

4. Here you can – as self service – now add the IP numbers that need to be whitelisted.
5. Click Add to add the new entry.
6. Click Save (top right) to save the changes.

DP Agent Configuration

At this point we have the DP Agent running and we have the IP number configured as part of the whitelisting on SAP Data Warehouse Cloud. As next step we need to configure the DP Agent to basically “talk” to our SAP Data Warehouse Cloud tenant.

1. Logon to your SAP Data Warehouse Cloud tenant.
2. Navigate to the bottom left and click on Administration.
3. Navigate to the tab Data Integration.

4. Click the “+” sign to start the configuration for a new DP Agent.
5. Enter a name for the new DP Agent.
6. Click OK.

7. You now received the details as shown above and need to configure your DP Agent with the given details.Please leave this screen open, as you will need the values.
8. Navigate to the folder where you installed the DP Agent. In my example: /usr/sap/dataprovagent.
9. Open the file dpagentconfig.ini for editing.
10. Now enter the details as shown on the screen from the previous steps (with the values from your Data Warehouse Cloud tenant):
    • agent.name = Agent Name that you entered, in my example DPAGENT02
    • hana.port = HANA Server Port from the previous step
    • hana.onCloud = false
    • hana.useSSL = true
    • hana.server = HANA Server Name from the previous step
    • jdbc.enabled = true
    • jdbc.host = HANA Server Name from the previous step
    • jdbc.port = HANA Server Port from the previous step
    • jdbc.encrypt = true

11. After the changes we have to re-start the DP Agent.
12. For Windows:
    • open a command prompt and navigate to the folder for the DP Agent installation
    • Navigate to the subfolder /bin
    • execute : agentcli.bat –configAgent
    • Use the option to Stop the agent.
    • afterwards use the option to Start the agent.
13. Now we need to configure the User and password.
14. Use the Quit option to close the options as part of the command prompt.
15. For Windows:
    • • Enter : agentcli.bat –setSecureProperty
      • Use Option 1 to set the HANA XS User Name and enter the value from the field HANA User Name for Agent Messaging
16. Use Option 2 to set the HANA XS User Password
17. Use the option Quit to close the options.
18. Stop and Start the DP Agent again.

At this point of the configuration you can close the screen we had left open from SAP Data Warehouse Cloud.

1. In SAP Data Warehouse Cloud navigate back to the Administration.
2. Click on the tab Data Integration.
3. You might have to click Refresh Agents.
4. Your agent should show a green status and should be listed as “connected”.

This basically means, that the DP Agent is running, our configuration has worked (including HANA user and password) and our IP Whitelisting has worked.

So what’s left now is to configure the Adapters and then we can establish the connection to our BW/4HANA system.

1. With the DP Agent in front of us, use the Edit option.

2. You can then simply enable the Adapters for HANA, and the ABAP Adapter, and the CDI Adapter. For Oracle and Microsoft SQL we would also have to configure the driver libraries (will come to that in another blog).

Now we have everything in place to establish the connection to our BW/4HANA system.

In the next blog, we will setup the connection, and take a look at how we can release Analytical Queries.

In case you would to follow the step by step guidance, you can register for a free SAP Data Warehouse Cloud Trial here.