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

[IngoH]

In the first part of our blog series, we made sure that our SAP BW/4HANA environment fulfills all the minimum requirements and we made sure we have all the required services up and running on the SAP BW/4HANA system - so basically our backend system is ready.

Now we will setup the necessary steps to establish a Tunnel Connection from the embedded SAP Analytics Cloud system to our SAP BW/4HANA system. SAP Data Warehouse Cloud will re-use that connection as part of the Model Transfer Integration between SAP Data Warehouse Cloud and SAP BW/4HANA.

For the Tunnel Connection, we need a Cloud Connector setup, so we need to first install the cloud connector.

Cloud Connector Installation

You can find the complete details here : Cloud Connector Installation - SAP Help.

You should ensure that the system you are using for the Cloud Connector

• ... does have Microsoft Visual Studio C++ 2013 runtime libraries installed (for Windows OS based)


• Java 7 or Java 8 should be installed. You can also use SAP JVM, which you can download here : SAP Development Tools for Eclipse.


• JAVA_HOME and PATH should be set to point to the JVM

 

SAP Cloud Platform Account

You will also need access to the SAP Cloud Platform account that is available in your SAP Data Warehouse Cloud Tenant.

To check on the SAP Cloud Platform account you can navigate in SAP Data Warehouse Cloud to  My Products (top right corner) > Analytics >> System > Administration > Data Source Configuration > SAP Cloud Platform Account.

Here you receive the Subaccount, Region, and User - all information we will need in the next step.

 

Cloud Connector Configuration

For the full details, please follow this link: Configure Cloud Connector for SAP Analytics Cloud Tunnel Connection

After the installation of the Cloud Connector has finished and the Cloud Connector is up and running, we need to do the initial configuration.

1. Logon to the Cloud Connector Administration page, which should be https:// < Cloud Connector Host > :8443 as default.

2. You now need to fill in the details:
   
   
   
   • Region : Select the Region matching your account information
   
   
   • Subaccount: Enter the Subaccount details from the previous steps.
   
   
   • Login eMail / Subaccount User : This should be the eMail / S-User account linked to the SAP Cloud Platform account
   
   
   • Enter the Password.
   
   
   • Location ID: You can leave this empty and it will then use the Default location in SAP Analytics Cloud. I would recommend you enter a Technical ID / Technical Name as Location ID.
   
   
   
   


3. Save the details.

You should then receive a screen that looks like the image shown below:

 

Now we need to add the link to our SAP BW/4HANA System.

4. In the navigation panel on the left in the Cloud Connector, select the option Cloud to On-Premise.


5. Navigate to the Access Control tab.

6. Use the "+" sign (top right) to add a new System Mapping.


7. The dialog will come up and you can enter the following details:
   
   
   
   • Backend Type: ABAP System
   
   
   • Protocol : HTTPS
   
   
   • Internal Host / Internal Port: This is the host name and port to reach your SAP BW/4HANA System via HTTPS
   
   
   • Virtual Host / Virtual Port : You can use the same details as for the Internal Host / Internal Port.
   
   
   • Principal Type : None
   
   
   • Host in Request Header : Use Virtual Host
   
   
   • Check Internal Host : Enabled.
   
   
   
   

After you entered those details you should see the entry listed in the mapping and the status should show "Reachable".

8. In the Resources of section, click the "+" icon to add a URL Path.


9. Enter the URL Path.


10. Select the Access Policy Path and All Sub-Paths.


11. Click Save.


12. Perform these steps for the following URL Paths:
    
    
    
    • /sap/opu/odata/sap/ESH_SEARCH_SRV/SearchQueries
    
    
    • /sap/bw4/v1/dwc/dbinfo
    
    
    • /sap/bw4/v1/dwc/metadata/queryviews
    
    
    • /sap/bw4/v1/dwc/metadata/treestructure
    
    
    • /sap/bw/ina
    
    
    
    

 

SAP Analytics Cloud Configuration

At this point we should have all the elements in place, so that we can establish the Tunnel connection from the embedded SAP Analytics Cloud to our SAP BW/4HANA System.

1. Logon to SAP Data Warehouse Cloud.


2. In the top right - select the option My Products.

3. Select the option Analytics.


4. Within SAP Analytics Cloud navigate to System > Administration > Datasource Configuration.


5. Scroll down to the option Live Data Sources.


6. Click on the pencil icon (top right corner) to open the Edit mode.


7. Enable the option Allow Live Data to securely leave my network.


8. Save the changes.

 

In case you did enter a Location ID (and did not leave it empty), you also need to configure this location in SAP Analytics Cloud.

9. Within SAP Analytics Cloud navigate to System > Administration > Datasource Configuration.


10. Scroll down to the option On-Premise Data Sources.


11. Add a new Location.


12. Enter the Location ID


13. DO NOT enable the Agent.


14. Click Create.

IP Whitelisting

You also need to IP Whitelist your Cloud Connector

1. Within SAP Data Warehouse Cloud, navigate to Administration > IP Whitelisting


2. Add the IP for the Cloud Connector host.

SAP Analytics Cloud Connection

Now we should have all elements, so that we can create the Tunnel Connection

1. In SAP Analytics Cloud select the menu Connection.


2. Click the "+" icon to add a new Connection.


3. Open the list of Live Data Source.

4. Select the entry SAP BW.

5. Enter a Name and Description.


6. Set the Connection Type to Tunnel

7. Select the Location you created


8. Enter the BW4HANA System Details: Host, Port, Client, Language.


9. Set the Authentication Method to User Name and Password


10. Enter User and Password


11. Enable the option Save this credential for all users on this system


12. Click OK.

 

Please note, that the user leverage here will need the following authorizations in BW/4HANA:

• Authorization object S_BW4_REST (authorization field: BW4_URI, value: /sap/bw4/v1/dwc*)


• Authorization object SDDLVIEW (authorization field: DDLSRCNAME, value: RSDWC_SRCH_QV)


• Read authorizations for SAP BW/4HANA metadata (Queries, CompositeProviders and their InfoProviders)

You can also use the SAP BW/4HANA authorizations to restrict to a subset of Queries / InfoProviders.

 

So far we configured our backend system and we configured the Cloud Connector. In the next part we will have to configure our DP Agent and then setup the Data Warehouse Cloud SPACE with the connection.

 

So in case you want to follow the steps along, perhaps sign up for a trial and get a system ready to leverage information from your SAP BW system in combination with SAP Data Warehouse Cloud.