Data Builder
Data Builder is the core modeling workspace in SAP Datasphere used to create graphical and SQL views, entity relationship models, and table definitions that transform raw source data into consumable, semantically rich objects for reporting in SAP Analytics Cloud and other consumers. This topic covers its purpose, object types, modeling patterns, deployment lifecycle, and how it fits into a broader Datasphere space and connection landscape.
Overview
Data Builder is the core modeling workspace in SAP Datasphere used to create graphical and SQL views, entity relationship models, and table definitions that transform raw source data into consumable, semantically rich objects for reporting in SAP Analytics Cloud and other consumers. This topic covers its purpose, object types, modeling patterns, deployment lifecycle, and how it fits into a broader Datasphere space and connection landscape.
Lessons in this topic
- Introduction to the Data Builder: Purpose and Object TypesUnderstand why the Data Builder exists in SAP Datasphere, what object types it supports, and how it fits into the broader modeling and consumption architecture alongside spaces and SAC.
- Building Transformation Flows and Persisted Views in Data BuilderLearn how to design Data Flows and persisted graphical views in Datasphere Data Builder to transform, cleanse, and materialize data for reliable, performant consumption.
- Building Graphical Views: Nodes, Associations, and Semantic EnrichmentLearn how to construct graphical views using projection, join, union, and aggregation nodes, apply semantic types, and configure associations for reusable, performant modeling in Datasphere.
- Data Builder Fundamentals: Purpose, Object Types, and Workspace LayoutIntroduces why Data Builder exists in SAP Datasphere, the categories of objects you can create there, and how the workspace is organized so new consultants can navigate it confidently.
- Building Graphical Views: Joins, Unions, Associations, and Deployment FlowExplains how to construct graphical views in Data Builder using joins, unions, projections, and associations, and walks through the design-to-deployment runtime flow with troubleshooting guidance.
- Building Data Flows and Task Chains for Scheduled Data IntegrationLearn how to design data flows for transformation-heavy loads and orchestrate them with task chains in Data Builder, including scheduling, dependencies, and monitoring for production data integration.