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

[haruki]

(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 Datasphere. 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 Datasphere 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 Datasphere 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 SAP Datasphere and source systems, you need to add a global address of the source systems on the SAP Datasphere 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 Datasphere)

 

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 SAP Datasphere

First, register DP Agent on SAP Datasphere. Logon to SAP Datasphere 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 SAP Datasphere 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 SAP Datasphere 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 SAP Datasphere 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 SAP Datasphere 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 SAP Datasphere 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 SAP Datasphere 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 SAP Datasphere in another blog.

 

[ravicondamoor]

hi,

Would  customers ever need to go thru' Cloud Connector when connecting DWC to on-prem S4/ECC/BW or DPAgent alone will be sufficient to address all on-premise deployments?

Thanks

-ravi

[AndyZhang1]

Hi Ravi,

DPAgent is sufficient for on-premise data source exposure.

Regards,

Andy

[sandeepkarnati]

Hello Ravi,

It depends on the connection you are trying to create on DWC.

for instance if you want to create a BW4 model transfer connection on DWC,you have to configure both cloud connector and DPA (basically you need both for this type of connection )

 

Thanks

Sandeep Karnati

[dkle]

Newer instances of the DWC Trial (>= 2021?) seem to have no more "allow all IPs" whitelisting preconfigured, so I propose to add the following ranges to the whitelist before step 1.3 to allow all IPs in Trial environments:

1.1.1.1/1

128.1.1.1/1

Thanks Takao for creating this blog, IMO you could state that your instructions are for installations on Windows OS, and refer to the official instructions for installations on Linux: https://help.sap.com/viewer/7952ef28a6914997abc01745fef1b607/2.0_SPS05/en-US/dd8aaa71a6d4490485b8eb5...

[NazeerAhamad_M]

Hi Experts,

Thanks for sharing the details to connect S4-> DWC and then consume the data in DWC.

We are looking for a solution/steps to connect DWC to S4 and then push/fetch the DWC table data into S4 system tables either direct or in-directly.

Any suggestions would be appreciated.

Thanks,

Nazeer

[former_member318610]

Hello everyone ,  In my case I need to connect SAP DWC to S/4HANA System (currently in November 2022) I followed the 4 procedures mentioned in the link: https://help.sap.com/docs/SAP_DATA_WAREHOUSE_CLOUD/9f804b8efa8043539289f42f372c4862/f1a39d1a763e48c8...

My questions are:

1. Why in the procedure mentioned lines above is not mentioned the creation of a connection inside of a space?

2. Is correct the procedure that I am following? or I need some steps to do?

I want to be sure if I am following the correct order to realise the goal to connect  SAP DWC to SAP  S/4HANA on premise

Thanks for your explanations in advance

[ravindrapawar]

Hello Experts,

Is it passible to add a REST API as a source / connection in SAP DWC or SAP Datasphere?

Thanks,

Ravindra

[ravindrapawar]

Hello Experts,

Is it possible to connect to Azure MySQL in SAP DWC or SAP Datasphere?

Thanks,

Ravindra

 

[dasari_reddy_ext]

Hi All,

Hana adapter is grayed out for us in SAP Datasphere, do you know what could be the possible reason?

 

Regards

 

[steven_foo]

We are using cloud connector to connect SAP DataSphere back to our S/4 HANA on-prime.

We are ask the enter the application server, system number and etc.

In one of the area Credential. For this user what are the authorization object that we should provide in our backend S/4 HANA, The documentation is badly done and does not specify anything.