Skip to content
This repository has been archived by the owner on Dec 18, 2024. It is now read-only.

Latest commit

 

History

History
100 lines (67 loc) · 7.27 KB

README.md

File metadata and controls

100 lines (67 loc) · 7.27 KB
Raw

Set Up SAP Datasphere

To set up SAP Datasphere, use the following resources:

Create and Set Up Space in SAP Datasphere

SAP Datasphere serves as the repository for master data, which is readily accessible to SAP Build Apps through a CAP application. The transactional data, entered via the SAP Build Apps application, complements the master data. Additionally, SAP Datasphere facilitates the creation of an analytical model, leveraging the master and transactional data, specifically designed for data analysis within SAP Analytics Cloud.

Log In to SAP Datasphere

When you are added as a user to SAP Datasphere, you receive a welcome email. Choose Activate Account to connect to the server and set your password. The main panel of the SAP Datasphere Home screen gives you access to shortcuts to help you get started.

Create Space

All data acquisition, preparation, and modeling happen inside spaces. A space is a secure area - space data cannot be accessed outside the space unless it is shared to another space or exposed for consumption.

  1. In the side navigation area, choose Space Management and then choose Create.

  2. In the Space Name field, enter a name for the space, for example Tank Farm.

  3. In the Space ID field, enter an ID for the space, for example TANK_FARM. See Create Space.

  4. Choose Create.

  5. In the Members section, choose + to add users as members of this space.

  6. Choose Deploy in the upper right corner to save and deploy your space to the database. See Assign Members to Your Space.

  7. Once the space is created, it is listed in Space Management.

Create Technical Database User

To access SAP Datasphere artifacts, which are exposed for consumption as sources from the CAP application, you must create a database user with the appropriate privileges, create a user-provided service in the SAP BTP cockpit, and configure your HDI project.

To create a database user, follow these steps:

  1. In the side navigation area, choose Space Management, locate your space tile, and choose Edit to open it.

  2. In the Database Users section, choose Create to open the Create Database User dialog.

  3. In the Database User Name Suffix field, enter TECH_USER.

  4. Select the Enable Read Access (SQL) checkbox.

  5. Select the Enable HDI Consumption checkbox. Choose OK in the confirmation dialog box if any.

  6. Select the Enable Write Access (SQL, DDL, & DML) checkbox, if it is not selected already.

  7. Choose Create.

  8. Once the user is created, a message may pop up saying Database User Created.

    Note: Recent activities can be viewed from the upper right corner menu Notification as well.

  9. Choose Deploy in the upper right corner.

  10. Once the deployement is completed, in the Database Users section, choose the info icon from the database user (FARM_TANK#TECH_USER) to open the Database User Details dialog.

  11. In the Password section, choose Request New Password.

  12. In the HDI Consumption section, choose Copy Full Credentials.

  13. IMPORTANT: Store this copied info in secure place to use it later including the password.

See:

Enable SAP HANA Deployment Infrastructure (HDI) Mapping in the Space

The SAP HANA Deployment Infrastructure (HDI) uses containers to store design-time artifacts and the corresponding deployed run-time (catalog) objects. By deploying it into SAP HANA Cloud underneath the SAP Datasphere, you can write into SAP Datasphere space.

To enable the option to add an HDI Container into the SAP Datasphere space, follow these steps.

  1. In the side navigation area, choose Space Management, locate your space tile (Tank Farm), and choose Edit to open it.

  2. Go to the HDI Containers section. If it is not available, make sure that you have DW Scoped Space Administrator role for the space.

    Note:

    1. If you are a System Owner, you may not have the HDI Containers section by default. In this case, you will need to have the DW Scoped Space Administrator as well.
    2. No users can assign roles to themselves, even if you are a System Owner. Roles must be assigned by another DW Administrator user.

  3. In the HDI Containers section, if the + button is not available, then you need to raise a ticket following the dialog instruction.

    This creates instance mapping between SAP BTP space and SAP Datasphere database. Since the mapping is tied to a particular SAP BTP space, it is necessary to create a unique mapping for each space in use. To create this mapping, you will be required to provide the ID of the SAP BTP Organization, Space ID, and SAP Datasphere tenant as essential details.

    Note: For SAP internal users, create a JIRA ticket containing the following information: Project: FPA35 - Ops Request (Andreas); Component: Service Request; Include details about BTP Org ID, BTP Space ID, datasphere tenant and Datasphere tenant url.

See:

Link SAP Datasphere and SAP Analytics Cloud

Linking SAP Datasphere and SAP Analytics Cloud makes easier to switch between these two products.

See Enable the Product Switch to Access an SAP Analytics Cloud Tenant.

You can find the linked products in the top right corner under the label Product Switch, allowing you to switch easily between them.

Summary

With SAP Datasphere successfully set up, you can now proceed to prepare your CAP application to interact with it. You have the capability to both read from and write into SAP Datasphere using an HDI Container. This integration allows your CAP application to seamlessly access and manipulate data within the SAP Datasphere environment.