SAP BW → BDC
Visual course summary · SAP Learning

Transforming SAP BW with SAP Business Data Cloud

A simple mental model for the course: move SAP BW safely into a private-cloud edition, expose BW assets as governed data products, then gradually shift innovation toward SAP Business Data Cloud, SAP Datasphere, SAP Databricks, SAP-managed data products, and modern planning.

The course in one flow

The transformation is not “rewrite everything in the cloud tomorrow.” It is a controlled path that preserves BW value while opening BW data to a business data fabric, data mesh, AI/ML, and open ecosystem tools.

Step 01

Optimize

Reduce the BW footprint. Offload data that is no longer needed for reporting or late postings into the object store based on SAP HANA Data Lake Files. Then move eligible BW systems into SAP BW, private cloud edition in SAP Business Data Cloud.

Step 02

Modernize

Use the Data Product Generator to replicate BW InfoProvider data into SAP Datasphere local tables/files, then publish these tables as custom data products.

Step 03

Innovate

Share data products with SAP Databricks, SAP Snowflake, SAP Datasphere, and SAP Analytics Cloud. Replace selected BW use cases over time with SAP-managed data products, clean-core models, and modern planning.

Why transform BW with SAP Business Data Cloud?

The benefits combine continuity and innovation: keep existing BW investments, but make the data easier to share, cheaper to store, and more useful for AI/ML and cloud analytics.

Preserve investmentsExisting BW models and expertise remain useful; you do not rebuild everything from scratch.
Lower storage pressureObject-store architecture decouples storage from compute and supports large BW footprints.
SAP-supported pathBW NetWeaver 7.5 support extends to 2030 when moved into BW private cloud edition; BW/4HANA and Datasphere are supported at least until 2040.
Zero-copy sharingBidirectional sharing with tools such as SAP Databricks avoids redundant copies.
AI/ML readinessBW data becomes available for Databricks, predictive analytics, data engineering, and future AI agents.
Data product deliveryBW data can be published as discoverable, governed data products for broader organizational consumption.
Datasphere combinationLegacy BW data and new sources can be combined using SQL-based modeling in SAP Datasphere.
Open ecosystemIntegrates with non-SAP and semi/unstructured data, reducing the silo effect of a traditional warehouse.
Self-service directionBusiness users can move toward cataloged products, semantic models, SAC stories, and planning workflows.
Commercial flexibilitySAP BW services in BDC use Capacity Units under the same cloud contract as BDC, simplifying cloud-service consumption.

Moving BW into SAP BW, private cloud edition

The move is an “as-is” modernization route. Converting BW NetWeaver to BW/4HANA is not required before moving to SAP Business Data Cloud, though it can still be done later.

Eligible starting points

  • SAP BW NetWeaver earlier than 7.5
  • SAP BW NetWeaver 7.5 on any DB or SAP HANA
  • SAP BW/4HANA 1.0, 2.0, 2021, or 2023

Minimum prerequisites

  • BW NetWeaver 7.5: SPS 24+ and SAP HANA database
  • BW/4HANA 2021: SP4+
  • BW/4HANA 2023: SP0+
  • Core actions: get onto SAP HANA and upgrade to the required release

Data Product Generator: the operational heart

The Data Product Generator turns BW InfoProvider data into SAP Datasphere local tables/files. Those tables become the base for custom data products in SAP Business Data Cloud.

01Select BW sourceInfoProvider / ODP-BW provider
02Create subscriptionFull or delta; projections and filters
03ActivateCreates the local table/file in Datasphere
04RunBW pushes data to inbound buffer
05MergeDatasphere merge task updates delta table
06PublishCreate and list a custom data product
07ShareConsume in Databricks / BDC catalog
ConceptMeaningKey details from the course
Source typesBW objects exposed via ODP-BWInfoObject, DSO, advanced DSO, InfoCube, CompositeProvider, MultiProvider, Query as InfoProvider. Hierarchies are not yet supported.
Extraction modesHow data is replicatedFull extraction loads a snapshot. Delta extraction loads initial data and then changes where supported by the object type and BW release.
Local table/fileDatasphere target artifactActivation creates the table/file in an SAP BW space using SAP HANA Data Lake Files; running the subscription fills it.
Scenario GeneratorMass generation for complex BW modelsIn BW Modeling Tools, it collects top-level objects plus dependencies, builds a scenario tree, and generates/activates subscriptions while preserving relationships.
SchedulingAutomation of extraction + mergeUse BW process chains for data subscription runs and SAP Datasphere task chains for merge tasks; BW can trigger Datasphere task chains.
TransportLifecycle movementTransportable subscriptions use TLOGO type DSUB, active state, package, and transport request. Legacy local SUBS can be migrated using RSDDS_DSUB_MIGRATION.

Configuration checklist

Connectivity foundation

  • Admin installs DPG components; detailed steps are in SAP Note 3590400.
  • BW connects to SAP Datasphere via RFC destination of type “HTTP Connection to External Server” using OAuth 2.0.
  • BW connects to the object store using another HTTP RFC destination and a self-signed certificate.
  • Task list SAP_BW_BDC_CONFIGURATION creates/updates OAuth, certificates, target SAP BW space, and HANA Data Lake Files connection.

Operational tuning

  • Technical User OAuth in Datasphere is optional but strongly recommended after initial setup.
  • Multiple targets can be different tenants or spaces; target names must be identical across system tiers for transport.
  • Queued Task Manager can use up to 75% of batch work processes by default.
  • RSDDS_PACKSIZE_CSV controls package size; DPG 3.0 enables parallel processing by default.

Lesson-by-lesson summary

Open each lesson card for a compact explanation of what matters and what to remember.

Lesson 01

Key benefits

BDC lets companies keep BW investments while using object storage, managed access, data product delivery, zero-copy sharing, Datasphere modeling, and Databricks AI/ML.

  • Best summary: stable BW core + cloud agility.
  • Important support point: BW 7.5 in BDC gets mainstream maintenance to 2030.
Lesson 02

Transformation path

The course frames the journey as Optimize → Modernize → Innovate. Optimize footprint and move; modernize by creating custom BW data products; innovate by sharing and replacing use cases over time.

Lesson 03

Move to BW private cloud edition

Prepare BW by meeting release/database prerequisites, then move as-is. BW NetWeaver does not need to be converted to BW/4HANA first.

  • BW 7.5: SPS24+ on HANA.
  • BW/4HANA 2021: SP4+; 2023: SP0+.
Lesson 04

DPG capabilities

DPG creates, activates, runs, and monitors subscriptions on BW data. It supports full and delta extraction depending on BW object/release and uses ODP-BW as source type.

Lesson 05

DPG configuration

Admin configures OAuth, certificates, RFC destinations, SAP BW Datasphere spaces, and object-store connection. Multiple targets and performance settings are supported.

Lesson 06

Define a data subscription

Use BW/4HANA Cockpit app Data Subscriptions or SAP GUI transaction RSDPS. Define source, target, extraction mode, selections, projections, and process-chain variant. Activation deploys the local table/file.

Lesson 07

Scenario Generator

For complex BW models, Scenario Generator in BW Modeling Tools builds a dependency tree, avoids duplicate subscriptions, supports transport settings, and mass-generates subscriptions.

Lesson 08

Run a subscription

Running an activated subscription loads data to the local table/file. Success changes “Has Data” to Yes; data can be checked in SAP Datasphere Data Builder.

Lesson 09

Schedule subscriptions

Automation combines BW process chains and Datasphere task chains: BW extracts to inbound buffer, then Datasphere merge task consolidates into the delta table.

Lesson 10

Maintain subscriptions

Before the first run, more settings are editable. After the table/file is deployed and data exists, only description remains editable. Deletion in BW does not automatically delete the Datasphere local table/file.

Lesson 11

Transport subscriptions

Transportable subscriptions are DSUB objects in Active state assigned to package and transport request. Local SUBS subscriptions can be migrated using RSDDS_DSUB_MIGRATION.

Lesson 12

Create custom data products

In Datasphere Data Sharing Cockpit, create a data provider profile, choose Formations visibility, select local table/file(s), save Draft, then switch status to Listed. This creates Delta Share endpoint and ORD document.

Lesson 13

Share BW data products

Data products can be shared from the BDC catalog to SAP Databricks or consumed by creating a catalog from Delta Share. Data scientists use SQL/Python notebooks, then publish new delta shares back as data products.

Lesson 14

Innovation strategy

The strategic shift is from BW objects at the center to business data products at the center. Keep BW where it is strong, but grow cloud-native data products, AI/ML, self-service, and open ecosystem use cases.

Lesson 15

Managed data products + Datasphere

Use SAP-managed data products for greenfield/clean-core use cases. Use Datasphere artifacts when SAP content needs extension. For transitional cases, preserve historic BW data as custom data products and combine with managed data products.

Lesson 16

Seamless Planning

For BPC planning transitions, SAP recommends Seamless Planning in BDC: SAC dashboards write entered planning values to local tables in Datasphere. Hybrid models can consume BPC and BW-based data products.

Lesson 17

Transformation support

SAP points to RISE with SAP System Transition Workbench, architecture guidance, BW modernization partner/assessment resources, and SAP Road Map Explorer for Business Warehouse Modernization.

Innovation strategy: choose the right replacement depth

The course does not recommend a single replacement pattern for every BW model. It recommends a phased portfolio decision: keep what needs BW reliability, replace what benefits from cloud-native semantics, and use data products as the bridge.

Keep BW logic

For complex ABAP/BW transformations, regulated reporting, additive delta logic, and trusted financial/legal calculations.

Expose as custom product

Use DPG and Scenario Generator to preserve historic BW data or feed existing BW semantics into Datasphere/BDC.

Extend in Datasphere

Replace CompositeProviders and BW Queries with views, analytic models, data access controls, and SAC stories where suitable.

Replace with managed products

For clean-core domains like SuccessFactors or S/4HANA where SAP-managed data products and intelligent content are available.

Cut-over warning: if replacing BW DTP-based loading with BDC/Datasphere replication from the same source, define a clean modification-time cut-over. BW handles records before the date; the new replication handles records from that date onward.

Phased roadmap from the course

AStrategyClassify BW use cases; check SAP-managed data product availability and roadmap.
BFoundationSet up BDC, connectivity, roles, targets, spaces, and governance.
CQuick winsInstall managed products, generate BW custom products, adopt semantic layer, enable SAC.
DEnhancementMove complex transformations to Datasphere; use Databricks/Snowflake/Azure for AI/ML.
EExpansionGrow catalog, self-service, advanced AI, and topic spaces.
FReplacementLong-run: replicate remaining BW data, restructure, and eventually decouple BW.
GSupportUse assessments, partner guidance, Road Map Explorer, and transition tooling.

Remember this

What is the big shift?

From BW objects as the center of analytics to discoverable, governed business data products as the center.

What does DPG actually do?

It creates subscriptions that replicate BW InfoProvider data into SAP Datasphere local tables/files, which can then become custom data products.

Why use Scenario Generator?

It reduces manual work for complex BW models by collecting dependencies and generating multiple subscriptions consistently.

What is the scheduling pattern?

BW process chain runs the subscription; Datasphere task chain runs the merge task. BW can trigger the Datasphere task chain.

What is the safe migration posture?

Preserve reliable BW logic while gradually moving cloud-suitable use cases to SAP-managed data products, Datasphere models, and open ecosystem tools.

What support exists?

System Transition Workbench, SAP architecture guidance, BW modernization assessment, partner resources, and Road Map Explorer.

Glossary

SAP Business Data Cloud

SAP’s cloud environment for governed data products, Datasphere, Databricks integration, catalog, and business data fabric direction.

SAP BW, private cloud edition

Private-cloud deployment path for BW NetWeaver/BW/4HANA in BDC, preserving BW features while connecting to cloud innovation.

Data Product Generator

Tool for creating, activating, running, and monitoring data subscriptions from BW to Datasphere local tables/files.

Data Subscription

Definition that specifies BW source, target, extraction mode, projections, selections, and process-chain integration.

Local Table/File

Datasphere artifact backed by SAP HANA Data Lake Files where replicated BW data lands.

Delta Share

Open sharing mechanism used to deliver data products to consumers such as SAP Databricks.

ORD

Open Resource Discovery metadata standard used for describing data products and their capabilities.

DSUB / SUBS

DSUB is transportable data subscription TLOGO type; SUBS is older local/non-transportable type.

Seamless Planning

Planning approach where SAC captures planning inputs and writes them to local tables in SAP Datasphere.

Source lessons

  1. Key benefits of transforming SAP BW with SAP Business Data Cloud
  2. Transformation path for SAP BW with SAP Business Data Cloud
  3. Moving an SAP BW system to SAP BW, private cloud edition
  4. Data Product Generator capabilities
  5. Data Product Generator configuration
  6. Defining a data subscription
  7. Scenario Generator
  8. Executing a data subscription
  9. Scheduling data subscriptions
  10. Maintaining data subscriptions
  11. Transporting data subscriptions
  12. Creating a custom data product
  13. Sharing SAP BW data as custom data product
  14. Innovation strategy for SAP BW
  15. SAP-managed data products and SAP Datasphere
  16. Seamless Planning
  17. Support for transformation of SAP BW