A practical example of the three different types of Data Access Controls (DACs) in Datasphere  Introduction  The SAP documentation on the topic is quite extensive, so our aim today is to give you an example of how the actual implementation looks and to provide our recommendations.  Protecting your data with Data Access Controls  In SAP…

Continue Reading

Automating SAP Datasphere Task Chains with CLI Wrapping: FastAPI Integration with SAP Analytics Cloud  Introduction  When working with SAP Datasphere, triggering task chains is often a crucial part of automating data processes. SAP Datasphere provides the ability to start task chains using CLI (Command Line Interface) commands, which offer a powerful way to control these…

Continue Reading

SAP Datasphere – How to integrate Open SQL Procedures in a Task Chain  Introduction  Within SAP Datasphere a task chain is a structured sequence of tasks or operations designed to be executed in a specific order or concurrently. It automates the process of running multiple related tasks, ensuring that they are executed in a predefined…

Continue Reading

Data Flows – The Python Script Operator and why you should avoid it  When using SAP Datasphere to transform data for persistence, the Data Flow provides the necessary functionality. We recently compared various basic transformation tasks using different modeling approaches. Therefore, we tried four different approaches to implement a certain logic:  1. Modelling with the…

Continue Reading

ZPARTNER @ DSAG TT 2024  Wir waren auch dieses Jahr wieder bei den DSAG-Technologietagen vertreten. Besonders hat uns natürlich die SAP Analytics Agenda interessiert. Aber auch Hamburg hat, abgesehen vom Wetter 😉 , viel zu bieten. Was nehmen wir also mit?  Künstliche Intelligenz  Beeindruckend waren die praktischen Anwendungsfälle zur Künstlichen Intelligenz. In den Vorträgen wurde…

Continue Reading

DATA FLOWS IN SAP DATASPHERE (DSP) – Part 4: Using Dataspheres HANA Cloud Instance with Table Functions and how to integrate them seamlessly   Introduction  In the final part of this series, we want show how to use the HANA cloud instance and its functionalities and consume them within SAP Datasphere and Data Flows. Therefore,…

Continue Reading

DATA FLOWS IN SAP DATASPHERE (DSP) – Part 3: Using SQL Table Functions and incorporate them into your Data Flow Disclaimer SAP recently announced the launch of SAP Datasphere, which is the next generation of SAP Data Warehouse Cloud. Therefore, also the name from SAP Data Warehouse Cloud changed to SAP Datasphere. This blog, which…

Continue Reading

DATA FLOWS IN SAP DATASPHERE (DSP) – Part 2: Comparing Performance – The Script Operator Performance vs. SQL View Functions in Data Flows Disclaimer  SAP recently announced the launch of SAP Datasphere, which is the next generation of SAP Data Warehouse Cloud. Therefore, also the name from SAP Data Warehouse Cloud changed to SAP Datasphere….

Continue Reading

DATA FLOWS IN SAP DATASPHERE (DWC) – Part1: Introduction  Disclaimer  SAP recently announced the launch of SAP Datasphere, which is the next generation of SAP Data Warehouse Cloud. Therefore, also the name from SAP Data Warehouse Cloud changed to SAP Datasphere. This blog, which was posted ahead of this change, refers to SAP Data Warehouse…

Continue Reading