Technology Blogs by SAP
Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

SAP Datasphere – Enable SAP HANA Development Infrastructure (HDI)

Gopi_Singamsett
Product and Topic Expert
Product and Topic Expert
‎02-13-2024 8:29 AM

Introduction

Use SAP SQL Data Warehousing to build calculation views and other SAP HANA Cloud HDI objects directly in SAP Datasphere run-time database and then exchange data between HDI containers and SAP Datasphere spaces. SAP SQL Data Warehousing can be used to bring existing HDI objects into  SAP Datasphere environment, and to allow users familiar with the HDI tools to leverage advanced SAP HANA Cloud features.

Following are the steps required to followed

  1. Gather the relevant information
  2. Create SAP Support ticket to mapping/sharing DWC HANA Cloud to SAP Datasphere tenant space
  3. Create a HDI service instance on SAP Cloud Platform (SCP) under SAP Datasphere space  
  4. Create roles on HDI container by using HANA Web IDE (BAS)
  5. Add/Deploy HDI Container instance into SAP Datasphere 
  6. Conclusion

1. Gather the relevant information

To Enable HDI container on DWC in SAP Datasphere User must require below details:

  1. SAP Datasphere Tenant ID
  2. SAP Business Technology Platform Org GUID
  3. SAP Business Technology Platform Space GUID

Follow below Procedure to collect above details 

  • To collect the SAP Datasphere Tenant ID user should be part of any one of this roles DW Administrator, System Owner
    • Go to Expand Navigation bar ==>System==> About==> Tenant

Gopi_Singamsett_0-1707733538181.pngGopi_Singamsett_1-1707733553381.png

  • To collect the SAP Datasphere Tenant ID & Space GUID user should be part of any one of this roles SAP HANA Cloud Administrator, Space Developer
    • Go to SAP BTP Cockpit==>Global account==>Subaccount==>SAP Datasphere Space

Gopi_Singamsett_0-1707902548821.png

2.Create SAP Support ticket to mapping/sharing DWC HANA Cloud to SAP Datasphere tenant space

Create a Request to Product team under DS_SM category along with below details:

  • SAP Datasphere Tenant ID :
  • SAP Business Technology Platform Org GUID :
  • SAP Business Technology Platform Space GUID:

In the Schema Access area, go to HDI Containers and click Enable Access. A pop-up window appears there is need to open a support ticket so Product team can map the HDI containers with SAP Datasphere space. Please add the above-mentioned details into that ticket.

Notification will be shared once the ticket has been Processed/Mapping is completed.

3.Create a HDI service instance on SAP Cloud Platform (SCP) under SAP Datasphere space

To create HDI Service instance on SCP user should be part of any one of this roles SAP HANA Cloud Administrator, Space Developer

  • Go to SAP BTP Cockpit==>Global account==>Subaccount==>SAP Datasphere Space
  • Under Instances Tab Click on Create button by selecting service instance type .
  • Select the service type as an SAP HANA Schemas & HDI Containers & Plan is hdi-shared & Instance Name is name (ex: DSP_HDI_PLAY) of  HDI Container. Click on NEXT and add here Schema name with JSON format (ex: {"schema":"DSP_HDI_PLAY"}) . This is how User can define HDI Container own Schema name again this is not an mandatory to add here Schema name if left with blank this field then that schema name will  autogenerated number format one. Click NEXT and Click Create.

Now HDI Container getting creating like below with staring of the statusGopi_Singamsett_3-1707733758447.png

Gopi_Singamsett_4-1707733819532.png

With this status now have successfully created HDI Container.

For more details about HDI container service you will find in this SAP help page: HDI Container Setup 

4. Create roles on HDI container by using HANA Web IDE

Create the required roles to allow SAP Datasphere to read from and, optionally, write to the container.

Must define the roles DWC_CONSUMPTION_ROLE and DWC_CONSUMPTION_ROLE# (with grant option) in the container to allow to add into DSP space and allow to exchange data between the container and the space. 

  • To Create this roles on HDI Container  user should be part of this roles Business_Application_Studio_Developer on BTP Subaccount & Space Developer on BTP space.
  • Login tot the Business Application Studio (BAS) and create Dev Space by selecting SAP HANA Native Application.

Gopi_Singamsett_5-1707734065066.png

  • Open Dev Workspace and Create one SAP HANA Database project
  • Click on New Project from Template and select Create SAP HANA Database project click start.

Gopi_Singamsett_6-1707734110978.png

  • Enter the project name (ex: TEST) and SAP HANA Database Version should be an SAP HANA CLOUD
  • Login to CF account by using credentials authentication method (By entering SAP Email and SAP Global Password) and then click Sign in

Gopi_Singamsett_0-1707902174183.png

 

  • Select the CF target details Subaccount/organization and CF space

Gopi_Singamsett_1-1707902307279.png

 

  • And then Bind to HDI Container Service like below

Gopi_Singamsett_9-1707734172038.png

  • Click on Finish Button and with this step User have successfully created SAP HANA Database Project.

Can also verify either User have connected to correct HDI container or not by checking the service key on HDI container.

Once Project get created it will also generate and Create one service key "SharedDevKey" for the Cloud Foundry service instance "<HDI Container_name>"

  •  Create a DWC_CONSUMPTION_ROLE and DWC_CONSUMPTION_ROLE# roles under this Project on BAS.
    • Under db==>src folder User will have to create above two roles like below

Role Name -1

DWC_CONSUMPTION_ROLE_WITH_GRANT.hdbrole

Gopi_Singamsett_14-1707735648475.png

 

 

{    "role": {"name": "DWC_CONSUMPTION_ROLE#",
               "schema_privileges": [{"privileges_with_grant_option":[ "SELECT","SELECT METADATA","EXECUTE" ]}]}}

 

 

Role Name -2

DWC_CONSUMPTION_ROLE.hdbrole

Gopi_Singamsett_13-1707735516686.png

 

 

{    "role": {"name": "DWC_CONSUMPTION_ROLE",
              "schema_privileges": [{"privileges":[ "SELECT","SELECT METADATA","EXECUTE" ]}]}}

 

 

Add HDI container info into mta.yaml file:

Gopi_Singamsett_17-1707738530505.png

And then try deploy this into Database connection like below

Under SAP HANA PROJECTS folder see all the files and then click on bind icon on project folder like below

Gopi_Singamsett_16-1707736845317.png

Make succeeded (0 warnings): 2 files deployed (effective 2), 0 files undeployed (effective 0), 0 dependent files redeployed.  Making... ok (0s 303ms)

With this now have successfully created roles into HDI Container.

5. Add/Deploy HDI Container instance into SAP Datasphere

To Deploy the HDI Container into SAP Datasphere Space user should be part of any one of this roles DW Administrator, System Owner, Space Owner

    • Go to Expand Navigation bar ==>Space management==> <Select the space>==> Database Access ==>HDI Containers

Gopi_Singamsett_18-1707739059262.png

Select the HDI Container by click on +

Deploy the space by Click on Deploy button.

If deployment went successful then HDI container successfully added into SAP Datasphere space.

To verify this HDI container is deployed successfully or not check/test this HDI container is appearing under Data Builder application

Gopi_Singamsett_19-1707739093046.png

*** Content provided based on real time project experience ***

6.Conclusion

This blog post is intended to provide a quick information to set up & Deploy/ enable the  HDI container within the SAP Datasphere. The above procedure serves only as a recommendation and orientation. 

Thanks for reading! I hope you find this post helpful. For any questions or feedback just leave a comment below this post.

6 Comments
Labels in this area
Popular Blog Posts