Technology Blogs by SAP
Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

SAP Data Warehouse Cloud & SAP BW (or BW/4HANA) – Step by Step Part 2 of 4

IngoH
Active Contributor
‎10-29-2020 10:44 PM
In the first part of this blog series we talked about the set of steps we will discuss as well as the components that we will require for the integration of SAP BW 7.5 with SAP Data Warehouse Cloud and the integration of SAP BW/4HANA with SAP Data Warehouse Cloud. This time we will create the connection between SAP Data Warehouse Cloud and SAP BW 7.5.

So we need

  • ... to install and configure the DP Agent

  • ... ensure we have the IP whitelisted

  • ... to setup the connection from SAP Data Warehouse Cloud to SAP BW 7.5


In my scenario I am running a SAP BW 7.5 system and it is hosted inside of AWS and I also created a brand new system in AWS for the DP Agent. Technically you could install the DP Agent on the same hardware as the SAP BW system, but by keeping it separate I also have the option to assign dedicated IP numbers as well as the option to size the hardware, in case that is needed.

SAP Data Provisioning Agent (DP Agent) Installation


As mentioned in the previous blog, 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.





  1. Go to the option Support Packages & Patches

  2. Click on Access Downloads

  3. In the search box at the top enter the search terms HANA DP AGENT.

  4. Select the entry HANA DP AGENT 2.0 from the search result.

  5. Ensure you select your operating system. In my example, I am using a Windows Server 2016.

  6. Download the most recent version of the DP Agent.

  7. Unzip the downloaded file.

  8. Before you start the installation, please ensure - for Windows operating system - that these are installed:


  9. Start the installation of the DP Agent.

  10. In my example, I am using the folder \usr\sap\dataprovagent as installation folder.





  1. I am then being asked to provide the details for my DP Agent installation.

  2. 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.



 

  1. Click on the tab IP Whitelisting





  1. Here you can - as self service - now add the IP numbers that need to be whitelisted.

  2. Click Add to add the new entry.

  3. 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.



 

  1. Click the "+" sign to start the configuration for a new DP Agent.

  2. Enter a name for the new DP Agent.

  3. Click OK.





  1. 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.

  2. Navigate to the folder where you installed the DP Agent. In my example: /usr/sap/dataprovagent.

  3. Open the file dpagentconfig.ini for editing.

  4. 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




 

  1. After the changes we have to re-start the DP Agent.

  2. 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.



  3. Now we need to configure the User and password.

  4. Use the Quit option to close the options as part of the command prompt.

  5. 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

    • Use Option 2 to set the HANA XS User Password

    • Use the option Quit to close the options.



  6. 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 7.5 system.

 

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





  1. 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 7.5 system.

 

Connection to SAP BW 7.5


You can use an existing space or create a new Space in SAP Data Warehouse Cloud for this step.

  1. Open the menu Space Management

  2. Either use an existing Space or create a new Space. In case you decide to create a new Space, please do not forget to add yourself to the list of assigned members.





  1. Navigate to the Connections area.

  2. Use the "+" sign to start the process to create a new connection.





  1. Select the tile "SAP BW" (we will use the BW/4HANA Model Transfer in one of the next blogs as part of this series)





  1. Enter a Name and a Technical Name.

  2. Ensure you select your DP Agent from the list.

  3. Click Next Step



 

  1. Now enter the details of your SAP BW system.

  2. Click Create Connection.


 

If everything is configured correct and working, the dialog should close and the connection should be listed as part of your Space.

Just to do a quick check now (as we discuss the details in the next blog).

  1. Navigate to the Data Builder.





  1. Select the option New Graphical View.

  2. In the new Graphical View select the option Sources on the left hand side.



 

You should see your connection towards your SAP BW system and your should be able to open the details.

 

In case you would to follow the step by step guidance, you can register for a free SAP Data Warehouse Cloud Trial here.
3 Comments
Labels in this area
Popular Blog Posts