Introduction

In the following lessons, you gain an insight into the capabilities of SAP Datasphere, covering additional aspects of data ingestion and modeling. The lesson builds on the previously defined data model. However, it is self-contained and can be worked through independently of other lessons. The focus is on the introduction to a specific topic, and less on a complete end-to-end scenario to further expand the existing data model.

Here, you will find an overview of the topics:

Integrating Data via Database Users/Open SQL Schemas

Users can create database users to read data exposed by the SAP Datasphere space and to write data to Open SQL schemas attached to space, providing a secure method for exchanging data with the space via ODBC access to the run-time SAP HANA Cloud database.

In this lesson, we integrate data via database users and their Open SQL Schemas. With the help of the SAP HANA Database Explorer, we create a table and insert the table data records. The result is exposed to SAP Datasphere.

Data Access Control

Data access controls allow you to apply row-level security to your objects. Once a data access control is applied to an object, any user viewing its data either directly or via an object using it as a source, will see only those records they are authorized to view, based on the specified criteria.

In this lesson, we define an authorization table and a data access control. The data access control is linked to a fact view to illustrate the restriction of view records.