Skip to Content
Technical Articles
Author's profile photo Nidhi Sawhney

Develop on SAP Data Warehouse Cloud using SAP HANA Deployment Infrastructure(HDI)

In this blog post I will do a quick walkthrough of the steps needed to make SAP Data Warehouse Cloud (DWC) tenant access and use views created using SAP HANA Deployment Infrastructure (HDI).

SAP HDI provides services to manage and deploy database artefacts, which can be found in the reference manual here. That combined with the power of SAP WebIDE provides version controlled management of design time artefacts via integration with git.

With SAP DWC you can access and consume the artefacts created as HDI objects and use it for further data modelling via Data Builder and dashboarding via Story Building or through embedded SAC in DWC.

Note: The access works only for SAP DWC tenants and SCP spaces in the same datacenter.

The below high-level architecture that supports the above is very well described in this blogpost from Axel Meier

In the example below we will use SAP WebIDE tooling to create an HDI container the contents of which can then be accessed by the SAP DWC tenant.

Step 1 : Open ticket to connect your SAP Cloud Platform (SCP) space to your SAP DWC tenant

First you will need enable access from SAP DWC Space Builder Area.

In the Schema Access area, go to HDI Containers and click Enable Access. A pop-up window appears informing you that you need to open a support ticket so we can map the HDI containers with your SAP Data Warehouse Cloud space. The details required for the ticket are described here.

Step 2 : Create an HDI container and build and/or deploy it in the HANA Cloud (HC) instance of the  SAP DWC

Once the ticket confirms that your SCP space is mapped to your DWC tenant, you can create or deploy an existing HDI container to the HANA Cloud instance of you DWC tenant.

Using SAP WebIDE we have here a sample project which provides the minimum needed to create an HDI container that can be accessed via DWC.


Sample HDI MTA Project


DWC_access is an MTA(Multi Target Application) project with a single HANA DB Module called dwcaccess_db.

In the mta.yaml file you need to edit the config for database_id and provide the database id of the HANA Cloud tenant from DWC. This can be obtained from the DWC tenant Space Builder, the hostname provides the id needed by the mta.yaml file above.


Get HANA Cloud Database Id


In addition the project must provide the following DWC access roles to enable the HDI container to be accessible from DWC







Then Build your HDI Project. Once your project is successfully built it is ready to be access from DWC.

Step 3: Access the HDI content from SAP DWC

In the SAP DWC Space Builder HDI Containers you can now add the HDI container using the + option


Once you have added the HDI Container, it is available as a Source in the Data Builder in SAP DWC and can be used to build views etc for consumption.


HDI Source


Thats it for now, happy DWC developing with the power of HDI!

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Enio Terra
      Enio Terra

      Excellent Nidhi! SAP DWC is a great tool and is getting better! Thanks for sharing.


      Enio Terra

      Author's profile photo Sarath Kannan
      Sarath Kannan

      Please tell me how we can connect to a On -premise system instead of Hana cloud

      Author's profile photo Axel Meier
      Axel Meier

      Hi Sarath,

      pls feel free to check below Blog post describing the topic.




      Author's profile photo Nidhi Sawhney
      Nidhi Sawhney
      Blog Post Author


      Hi Sarath,

      I am not sure what you mean, SAP DWC is Data Warehouse Cloud so its cloud application and in the above scenario we are deploying to the HANA Cloud within DWC. There isnt an On-Prem equivalent of it. You can ofcourse deploy HDI containers on On-Prem via HANA XSA



      Author's profile photo Chang Run Lin
      Chang Run Lin

      Hi Nidhi,

      Will the same work for BAS (Business Application Studio)?



      Author's profile photo Nidhi Sawhney
      Nidhi Sawhney
      Blog Post Author

      Yes, the same applies for developing in BAS.