New Features in Version 2021.19
New or changed features are available in SAP Data Warehouse Cloud version 2021.19.
Administration
-
Monitoring Tasks, Logs and Schedules With Dedicated Monitoring Views
Four monitoring views dedicated to SAP Data Warehouse Cloud are available in the DWC_GLOBAL schema to monitor tasks, logs and schedules within a space.
For more information, see Working with SAP HANA Monitoring Views
-
Access Additional Monitoring Views
Users assigned to the monitoring space can now access additional monitoring views: SAP HANA views from the _SYS_STATISTICS schema and monitoring views dedicated to SAP Data Warehouse Cloud from the DWC_GLOBAL schema.For more information, see Configure Monitoring.
-
Grant Write Access to Tables for Data Flows
You can now grant write access to tables located in Open SQL schemas, HDI containers, and SQL User Group schema, and use them as targets in a data flow.
For more information, see Allow the Space to Access the Open SQL Schema, Allow Your Space to Write to Your HDI Container, and Allow a Space to Write to the Database User Group Schema.
Data Integration
-
CSN Export of Remote Tables from One Space to Another
When you create a connection, the space name is no longer hardcoded as a prefix in the connection technical name. This change lets you export remote tables from one space to a CSN file and then import the file into another space that contains a connection with the same name.For more information, see Importing Objects from a CSN/JSON File.
-
Remote Query Monitor: Check the running statement to identify root cause issues
From the Remote Query Monitor, administrators can now display the original SQL statement for a query that is currently running and track the root cause of the error. Using the Statement ID, they can additionally connect to the SAP HANA Cockpit and get deep dive information.
For more information, see Monitoring Remote Queries.
-
Redesigned Dialog Box for Scheduling Data Integration Tasks
The dialog box for scheduling data integration tasks has been redesigned and includes these features:-
Schedule Data Integration Tasks by Entering Cron Expression
You can now create a schedule by entering directly a cron expression in the scheduling dialog box, so that your tasks run multiple times a day or run on specific days and months. For more information, see Schedule a Data Integration Task (with Cron Expression).
-
Specify an Offset for Hourly Schedules
When you define a simple schedule to run tasks hourly, you can now specify an offset of more than one hour. For example, a task will run every 2 hours starting from 1:30 AM (offset). For more information, see Schedule a Data Integration Task (Simple Schedule).
-
Data Modeling
-
Data Flow Upsert Option
When using the Append mode in your data flows, you can now enable the new Update Records By Primary Key (UPSERT) option to instruct the flow to update, where appropriate, existing target table records.
For more information, see Add or Create a Target Table in a Data Flow.
-
Add Open SQL Schema Objects or HDI Containers as Targets in Data Flow
You can now add Open SQL schema objects or HDI containers to a data flow as sources or targets .
For more information, see Creating a Data Flow.
Data Privacy and Protection
-
Importing SAP BW∕4HANA Analysis Authorizations
You can now import analysis authorizations defined in SAP BW∕4HANA v2.0 and higher systems into SAP Data Warehouse Cloud to provide row-level protection for data in remote tables imported from these systems. The Import Permissions wizard allows you to select tables to protect and will, for each selected table, create a view to calculate its permissions, a data access control to consume them, and a second protected view to wrap the remote table and apply the data access control.
For more information, see Import SAP BW and SAP BW∕4HANA Analysis Authorizations.
General
-
Simplified Space Handling
Users who are members of only one space will no longer be asked to select that space before entering the Data Builder and other applications.
Space Management
-
Saving a Space and Deploying it as Two Distinct Actions
Now, when you save a space, it is not automatically deployed to the database. You can then choose to deploy the space when you are ready.
For more information, see Save and Deploy Your Space.
Related Information
To access the SAP Datasphere roadmap, visit the SAP Roadmap Explorer
.