Skip to Content
Technical Articles

Connecting from SAP Data Warehouse Cloud to S/4HANA & (OnPremise/Cloud)SAP HANA

(Japanese version)

 

Overview

In this blog, I will share the configuration steps for connecting to SAP Applications (S/4HANA) and SAP HANA (On-Premise and Cloud) from SAP Data Warehouse Cloud (DWC). I would like you to understand that it is easy to connect with source systems, even if DP Agent is installed.

The environment is as follows:

  • SAP Data Warehouse Cloud version 2020.9.47 (trial version)
  • SAP HANA DP Agent 2.0 SP04 Patch 24
  • SAP S/4HANA 1909
  • SAP HANA 2.0 SPS04 Revison 42
  • SAP HANA Cloud

This takes place in the following steps:

  1. Configure DP Agent
  2. Connect to S/4HANA
  3. Connect to On-Premise SAP HANA
  4. Connect to SAP HANA Cloud

 

 

1. Configure DP Agent

SAP Data Warehouse Cloud utilizes the Data Provisioning Agent (DP Agent) of SAP HANA Smart Data Integration (SDI), which is the ETL functionality of SAP HANA, to connect with various systems. You can access SAP HANA, SAP applications (e.g. S/4HANA or BW/4HANA), Oracle, MS SQL Server, and so on via this DP Agent,

The DP Agent is usually installed on a dedicated server. In this blog, it is installed on the Windows server of the same network area as S/4HANA and On-Premise SAP HANA.

* When connecting with DWC and source systems, you need to add a global address of the source systems on the DWC’s IP Whitelist (as of April 2020, you need to create a support ticket). The Trial environment that is being used in this blog is configured to allow all IPs, so I skip this step. (SAP Note 2894588 – IP Whitelisting in SAP Data Warehouse Cloud)

 

1.1 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

 

1.2 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”.

The installer pops up, select any folder as installation folder.

Enter the agent name (used as the suffix of the service name, a string that will be unique on the host to be installed), and enter the user and password for the host OS that you want to install, and then install the DP Angle.

 

1.3 Configure DP Agent

Once you have installed the DP Agent, you can make the settings of the DP Agent. Refer to SAP Help and this guide for how to set up.

 

1.3.1 Register DP Agent on DWC

First, register DP Agent on DWC. Logon to DWC and click gear icon (bottom left) to go to “Administrators”.

At “Data Provisioning” tab, click “+ Create Agent Communication Credentials”.

Enter any name.

The screen appears as follows. Leave this screen visible and make the settings for the DP Agent.

 

1.3.2 Edit DP Agent configuration file

Go to DP Agent installation folder and open configuration file “dpagentconfig.ini”.

Edit following fields with reference to SAP Help. The host name and port number is displayed in “Agent Settings” (1.3.1).

Save the file once you completed editing.

 

1.3.3 Start DP Agent

Run command prompt as an administrator to start DP Agent.

Go to “<DP Agent Installation folder>/bin” and run the command below.

agentcli.bat –configAgent

Choose “2. Start or Stop Agent” and then choose “2. Stop Agent” to stop DP Agent. Then, select “1. Start Agent” to start DP Agent. Confirm that DP Agent is started by “3. Ping Agent”, end the command with “q. Quit”.

 

1.3.4 Set user and password

Next, set the user and password by the command below. The user and password is displayed at “Agent Settings” (1.3.1).

agentcli.bat –setSecureProperty

Choose “1. Set HANA XS Username” and enter the HANA user name, then choose”2. Set HANA XS Password” to enter the password”

 

1.3.5 Restart DP Agent

Restart the DP Agent as same as 1.3.3.

 

1.3.6 Confirm the connection

Go back to DWC and close “Agent Settings” screen. Wait for a while and confirm the status become “CONNECTED”. (You need to push refresh button. It may take a few minutes to be connected.)

 

1.3.7 Activate Adapter

Click the pencil icon to open “Agent Settings” screen again. Check “ABAP Adapter” and “HANA Adapter” and then close the screen.

 

Configuration of DP Agent has been finished. Now DWC can connect to source systems like SAP Applications (e.g. S/4HANA, BW/4HANA) and SAP HANA.

Now I will connect to S/4HANA, On-Premise SAP HANA and SAP HANA Cloud.

 

 

2. Connect to S/4HANA

2.1 Connection setting

Connection settings are made in each spaces.

Click “Space Management” on the left side of DWC to go to space management screen. (If you have not created the spaces yet, create it from here.)

Choose a space.

Click “+” button on “Connection” to create a new connection.

The available connection types are displayed. Select “SAP ABAP”.

Enter the name (both business name and technical name) of the connection and choose the DP Agent which was created before in “Data Provisioning Agent”.

Enter host name, client number, instance number, user, password of S/4HANA, then click “Create Connection” to create connection.

2.2 Validate Connection

New connection has been created. Select the connection and click “Validate Connection” icon.

Confirm that the connection is valid.

The connection settings of DWC and S/4HANA has been completed. Next, create connection to SAP HANA as same procedure as this.

 

 

3. Connect to On-Premise SAP HANA

3.1 Connection setting

Create a new connection as same procedure as 2.1 and select “SAP HANA” as connection type.

Enter host name, SQL port number, user and password of SAP HANA. In this blog, “SSL Encryption” is set to “False” (disabled). Click “Create Connection” to create a new connection.

 

3.2 Validate Connection

New connection has been created. Select the connection and click “Validate Connection” icon.

Confirm that the connection is valid.

The connection settings of DWC and On-Premise SAP HANA has been completed. Next, create connection to SAP HANA Cloud as same procedure as this.

 

 

4. Connect to SAP HANA Cloud

4.1 Connection setting

Create a new connection as same procedure as 2.1 and select “SAP HANA” as connection type.

Enter host name, SQL port number, user and password of SAP HANA Cloud. Click “Create Connection” to create a new connection.

The host name and port number can be confirmed at Endpoint of SAP HANA Instance on the SAP Cloud Platform Cockpit.

 

4.2 Validate Connection

New connection has been created. Select the connection and click “Validate Connection” icon.

Confirm that the connection is valid.

 

 

The settings for DP Agent and the connection settings for SAP S/4HANA, On-Premises SAP HANA and SAP HANA Cloud has been completed.

You have confirmed that you can easily connect to various systems once you have installed and configured DP Agent. You could have imagined that the concept of positioning the DWC as a gateway for corporate data could be easily realized.

In this blog, only SAP ABAP connection and SAP HANA connection were used, but at this time (April 2020), it is possible to connect to Oracle DB and MS SQL.

I will introduce the actual creation and visualization of a data model using DWC in another blog.

 

Be the first to leave a comment
You must be Logged on to comment or reply to a post.