Enable SAP HANA for SQL Data Warehousing on Your SAP Datasphere Tenant

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

Prerequisites

To enable SAP HANA for SQL data warehousing on your SAP Datasphere tenant, you must have a global role that grants you the following privileges:
  • Data Warehouse General (-R------) - To access SAP Datasphere.

  • System Information (-RU-----) - To access the System tool.

The DW Administrator global role, for example, grants these privileges. For more information, see Privileges and Permissions and Standard Roles Delivered with SAP Datasphere.

Context

To enable SAP HANA for SQL data warehousing on your SAP Datasphere tenant, you must map your tenant to your SAP Business Technology Platform account.

A tenant may have both Kyma mappings and Cloud Foundry mappings simultaneously. You can also map instances using the Instance Mapping REST API (see Create and Manage Instance Mappings Using the REST API in the SAP HANA Cloud Administration Guide).

For information about working with SAP Datasphere and HDI containers, see Exchanging Data with SAP HANA for SQL Data Warehousing HDI Containers.

Procedure

  1. In the side navigation area, click (Configuration) Start of the navigation path Next navigation step Instance MapingEnd of the navigation path.
  2. Add a mapping for one of these environment types: Cloud Foundry or Kyma.

    Environment Type

    Environment Instance ID and Group

    Cloud Foundry

    Enter the organization and space GUIDs that you are mapping to:

    • Your SAP Business Technology Platform organization GUID.

    • [Optional] Your SAP Business Technology Platform space inside the organization. If you only specify the organization GUID, the instance is mapped to all spaces in that organization.

    Kyma

    Enter the cluster ID and namespace that you are mapping to:

    • Your cluster ID. The cluster ID must be a GUID and the namespace can be no longer than 64 characters. Allowed characters are all lowercase letters, numbers, and dash (-).

    • [Optional] Your namespace. If no namespace is provided, the instance is mapped to all namespaces in the cluster.

    For more information, see SAP HANA Instance Mapping in the SAP HANA Cloud Administration Guide.
  3. Click the Save button to apply your changes.
    Your tenant is mapped to another environment context. You can now create HDI containers outside of SAP Datasphere.
  4. Build one or more new HDI containers in the SAP Business Technology Platform Space and they will be created in the SAP Datasphere run-time database (identified by the Database ID on the SAP Datasphere About dialog).

    For information about setting up your build, see Binding Applications to an SAP HANA Cloud Instance.

Next Steps

When one or more HDI containers are available in your tenant, users with a space administrator role can work with them (Exchanging Data with SAP HANA for SQL Data Warehousing HDI Containers).