Eviden’s SAP Data Model for Databricks

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.


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


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)

Return to SAP ERP data integration to Databricks