AI & Analytics Legends The knowledge platform for SAP Analytics
Academy module

SAC Data Integration

SAC connection types ranked by governance, with DAC as the shared trust layer — architecture diagram for SAC Data Integration, Analytics Legends Academy module M022

As of 2026-10-03

Edited by , sole editor and publication director — 27 years in the SAP ecosystem. How these pages are produced, and where automation is used.

4 connection types ranked: Live-to-DSP-AM (preferred) · Live-to-BW (migration period) · Live-to-HANA-Cloud (rare) · imported flat (last resort). Senior pattern: new stories Live-to-DSP exclusively, quarterly connection audit, DAC inheritance everywhere. Imported flat = no governance, tolerable only for exploration. BW migration timeline driven by the BW 7.5 clock (mainstream 2027-12-31, paid extension 2030-12-31) — not by BW/4HANA, maintained to 2040.

What you will learn

  • Rank the four SAC connection types (Live to Datasphere analytic model, Live to BW/4HANA, Live to HANA Cloud calculation view, imported flat) and justify the senior default.
  • Run a connection-consolidation audit that retires unused connections and migrates BW-connected stories ahead of the mainstream-maintenance cliff.
  • Verify DAC inheritance on every connection type before go-live, and explain why a DAC bypass is a GDPR exposure.
  • Position SAC data-integration choices in day-rate terms: what a governance-first connection strategy is worth to a buyer under audit pressure.

Module overview

SAC consumes data from multiple sources — Datasphere (the right answer), live HANA, BW/4HANA, S/4HANA, file uploads, OData, third-party connectors. The senior choice is almost always: Live to Datasphere analytic model, with DAC inheritance, glossary, lineage. Other paths exist for specific reasons; document the reason or you accumulate technical debt.

The 4 connection types ranked.

  1. Live to Datasphere analytic model (preferred). DAC inheritance, governed dim/measure, glossary attached, lineage automatic. New stories should use this exclusively.
  2. Live to BW/4HANA (acceptable for migration period). Existing BW models work. Plan migration to Datasphere within the BW retirement timeline (the clock is classic BW 7.5's: mainstream maintenance ends 31 December 2027, paid extension to 2030 — SAP maintenance announcement, 23 April 2020; BW/4HANA itself is maintained to at least 2040, so this is a direction-of-travel decision, not an expiry).
  3. Live to HANA Cloud calculation views (rare). Only when specific HANA-side computation can't move to Datasphere. Document deviation in ADR.
  4. Imported flat models (last resort). Static snapshots, no DAC, no glossary, no lineage. Tolerable only for one-off analyses + non-governed exploratory work.

Prerequisites

  • Review core concepts first: C019, C008, C020

Outcomes

  • Work through a realistic scenario: Group with 6 BW stories + 4 imported flat + 8 mixed. 12-week consolidation program.
  • Recognize and avoid the anti-pattern: Imported flat in regulated domains — GDPR risk, no DAC, no audit.
  • Apply the module's core decision: Connection type for new story — choose Live to Datasphere analytic model, exclusively, not Imported flat or HANA Calc View without justification.
  • Track mastery with the KPI: Live-to-DSP share (target: > 90 % of new stories; red flag: < 70 %).

Full module available to members. The full module adds: the decision framework · the end-to-end scenario walkthrough · the KPI scorecard · the anti-patterns · the code blocks · the knowledge check · the diagrams.

Open in the app →

Next in this track