Access HANA Cloud Database Service (BTP) as source in SAP DWC

[sukanya_krishnan]

Overview

SAP DWC can connect to several SAP and Non-SAP sources. It can connect to SAP sources -  S/4HANA , SAP ECC , SAP Success Factors etc. ; SAP Data Warehouses -  SAP BW4HANA , SAP HANA Database ; Open Connectors , oData/REST API's etc. Let's understand how SAP DWC can connect to HANA Cloud database service, up and running in SAP BTP.

Integrate SAP DWC and HANA Cloud Service in SAP BTP

Two options to integrate

1. Use the HANA cloud underneath of DWC  - read/write data from HDI container in DWC


2. If separate HANA Cloud instance is running as service in BTP, same can be used as source in DWC

• For the first option, we need to map the HDI Container (created in BTP) with DWC tenant . Support ticket needs to be raised for this with DWC tenant details , BTP Organization and Space. This mapping can be possible only if "The SAP Data Warehouse Cloud tenant and SAP Business Technology Platform organization and space are in the same data center (for example, eu10, us10)."


• For the second option, we can access HDI container of HANA Cloud (database service in BTP) in SAP DWC by just leveraging the run time credentials

In this blog we would be focusing on second option

Pre-requisites

• Access to BTP  ( In this blog, I leveraged trial version)


• HANA database as service in BTP


• Ensure you have subscription to BAS - Business Application Studio and your dev space is up and running

Now let's create a project with HANA artifacts and access the same from DWC

• Create a project leveraging HANA artifacts. I have created a calculation view accessing SBOOK table o SFLIGHT schema and calculated the "Number of booking made per Agency on specific dates"

 

Now let's access this view in DWC

• Identify the run time credentials to be leveraged for DWC

• In the BTP cockpit, you will find the new HDI project that's created "TheProj-hdidb-ws-tbgc4" and service key associated to it. Click on the Key.
  
  
  
  • Row 12 has the runtime user ( one with suffix _RT)
  
  
  • Row 9 has the password
  
  
  • Copy the host id from Row 8
  
  
  • Copy the certificate enclosed between "BEGIN CERTIFICATE" and  "END CERTIFICATE" and create a *.cer file
  
  
  
  

• DWC accepts only "Base 64 encoded X.509" certificate format .In case your certificate is not in this format, you can export to required format. Click on "Copy to File" button in Details tab

 

 

 

 

 

 

 

 

 

 

 

 

Now log into DWC

• In the configuration tab, upload the certificate just created

• Go to Connections and create the connection with the credentials we noted down above

• Both data flows and remote tables can be created leveraging this connection. Now we can access the view we create in BTP HANA Cloud

Summary

We have now created a connection between HANA Database service in BTP and SAP DWC. Using this we can access the tables in HANA and create the modelling here in DWC or directly access the calculation views created in HANA. HANA & DWC artifacts can also be exposed as oData Services.