Preparing Your Space and Integrating Data

Users with a space administrator or integrator role can create connections to source systems and databases and can schedule and monitor data replication and other data integration tasks. Space administrators are, additionally, responsible for controlling user access to their space, creating data access controls to secure data, enabling other forms of data integration, transporting content between tenants, and monitoring and otherwise managing the space.

This topic contains the following sections:

Prepare and Manage Your Space

An administrator will assign you the DW Space Administrator role, create your space, and assign you to it. Once this is done, you can prepare your space as follows:

Assign SAP Datasphere users to your space (see Control User Access to Your Space).
Transport objects securely to and from your space (see Transporting Content Between Tenants).
Use various monitoring and logging tools to manage your space (see Managing Your Space).

Create Connections to Source Systems

Space administrators and integrators can create connections to source systems to allow space users to acquire data from those systems (see Integrating Data via Connections).

Integrate Other Data Sources

Space administrators can integrate data from other sources:

Create database users to allow external tools to connect to the space and write data to Open SQL schemas associated with the space (see Integrating Data via Database Users/Open SQL Schemas).
If your space has access to the SAP HANA Cloud, data lake, you can access it via an Open SQL schema (see Integrating Data to and From SAP HANA Cloud Data Lake).
Add SAP HDI containers to your space (see Exchanging Data with SAP HANA for SQL Data Warehousing HDI Containers)
Generate a time table and associated time dimension views for use in the space (see Create Time Data and Dimensions).

Import Business and Sample Content

SAP and our partners provide business content to support end-to-end business scenarios for various industries and lines of business via the Content Network and our Community Content Information published on non-SAP site site (see Importing SAP and Partner Business Content from the Content Network).

You can move your own content from tenant to tenant via the Transport app (see Transporting Content Between Tenants).

We also support direct import and export of many objects via CSN file (see Importing and Exporting Objects in CSN/JSON Files).

Prepare Data Security

We recommend that you create data access controls, which can be applied to views to provide row-level filtering of your space data (see Securing Data with Data Access Controls).

Manage and Monitor Data Integration Tasks

You can enable, run, schedule, and monitor data replication tasks in the  (Data Integration) (see Managing and Monitoring Data Integration).