Shakthi Teaches

Data Modeling in SAP Datasphere is quite interesting as it offers modelling capabilities based on the different user groups. Kudos Business users! Now you don't need your IT guy for everything :) Here Modeling is split into two layers - Business Layer and Data Layer. For the Business Analysts who has good understanding on the business, the Business Builder becomes the go-to place with no-code low-code interface. For the tech-savvy developers or Power users, we got Data Builder. Everyone are finally happy :) Data Builder is a place where we have all the basic modeling tools for creating views and tables to prepare data for our stories, and use entity-relationship models to visualize and make associations between artifacts. Business Builder allows users to create their own business models based on the business terms, meaning we can create business entities and fact models that would be acting as the foundation for consumption models which will be further used for reporting and protec...

Data Integration based on Data Flows: A Data Flow is used as per SAP Definition “to move and transform data in an intuitive graphical interface”. The Data Flow is created within the part of the Data Builder in SAP Datasphere, and it currently supports the following operators to be used within your transformation process:  Join Operator  Union Operator  Projection Operator  Aggregation Operator  Script Operator  As we are coming from a strong Business Warehouse background, we are always comparing things to the past. Which in our case would be a classical SAP BW on HANA or SAP BW/4HANA. We currently see the Data Flow as a substitute for what used to be in a BW system the transformation.   In the data flows, we will be able to use a series of standard transformations without the need of programming knowledge and in a graphic way, but we also have the possibility of creating transformations based on scripts. In a data flow, we will use views or tables...

SAP Datasphere provides a large set of default connections to access data from a wide range of sources, source from SAP as well as non-SAP sources or partner tools, residing in an cloud as well as on-premise environment. Connections are defined in a separate view which can be found in the main navigation window of the left. Connections are individual objects in SAP Datasphere. They are created and maintained per SAP Datasphere Space which means only members of a specific Space are able to make use of the related connections. These connections can be then be used within the different tools (like SQL View Builder, Graphical View Builder or Data Flow) for creating your data models. SAP Datasphere can integrate with both SAP or Non-SAP Source systems and it can be either cloud or on-premise. We have multiple connection types in SAP Datasphere. Each connection type supports a defined set of features. Depending on the connection type and the connection configuration, a connection can be used...