Eviden’s SAP Data Model for Databricks
Pre-Built Business Content Packages
Financial Suite
- General Ledger
- Accounts Payable
- Accounts Receivable
- Controlling and Profitability
- Asset management
Sales and Distribution Suite
- Sales
- Delivery
- Billing
- Shipments
Supply Chain Suite
- Invoice Verification
- Procurement
- Inventory Management
SAP Data Modeling:
🥉 Bronze
All raw tables are loaded without any transformation.
🥈Silver
Converting field names to readable form
Data types casting
Dimensions & Facts modeling
Aggregate tables creation
Hierarchies flattening
Texts + Master Data Integration (master tables to texts tables association)
Automated surrogate key creation (single column PK)
- Texts → Master Data
- Facts → Master Data
🥇Gold
Views for specific use-cases/reports
Features for ML models & predictions
Pre-built KPI application
Reporting views creation
High-level architecture of the Eviden’s SAP Accelerator
DEMO of SAP-like data structures in Databricks
Demonstration repository
The demonstration repository of our SAP accelerator’s Order to Cash module can be found at https://github.com/DataSentics/sap-order-to-cash
Technology stack
- business logic & transformations to produce tables in the Silver + Gold layers
- dbt-powered data models
- orchestrated using Databricks Workflows
- full Unity Catalog integration including data lineage
- CI/CD templates (GitHub, dbx for deployment)
