Skip to content
SAP2Snowflake Book

SAP BW exit · Snowflake destination

Get off SAP BW.
Land on Snowflake.

Your extractors changed in June 2026 and BW maintenance ends in 2027. DI Squared runs the whole route: estate assessment, target architecture, conversion, reconciliation and cutover, on an extraction path SAP permits.

Three dates that set the timetable

BW exit has moved from a strategy question to a scheduling one.

9 June 2026

ODP-RFC extraction blocked

SAP began enforcing Note 3255746. Third-party tools calling the ODP Data Replication API over RFC, including Fivetran, Azure Data Factory, Qlik Replicate and Informatica, lost unrestricted access.

December 2026

The revert workaround expires

SAP made a time-limited option available to restore unrestricted ODP-RFC calls. It ends in December 2026. Pipelines relying on it stop working then.

2027

SAP BW mainstream maintenance ends

Estates still running on BW face an extension, an upgrade or an exit. Assessment and migration together take longer than the time most landscapes have left.

Assessment plus migration takes longer than the time most landscapes have left. Starting in 2027 costs more and leaves fewer options.

What the target looks like

SAP stays the system of record. Snowflake becomes the place the questions get answered, fed through routes SAP permits.

SAP to Snowflake target architecture SAP ECC, S/4HANA and BW feed Snowflake through SAP-permitted routes: BDC Connect, CDS views and OData, SLT, or database-level replication. Snowflake holds a raw landing zone, dbt models carrying converted BW logic, and a semantic layer. Consumption covers BI and reporting, applications, and AI and machine learning. ODP-RFC extraction by third-party tools has been blocked since 9 June 2026. SAP SOURCES SAP ECC Tables, extractors SAP S/4HANA CDS view layer SAP BW InfoProviders, queries INGESTION, SAP-PERMITTED SAP BDC Connect Zero-copy share CDS views / OData Application level SLT Trigger replication Database-level Check licensing SNOWFLAKE Raw landing Source-faithful dbt models Converted BW logic Semantic layer Replaces BEx CONSUMPTION BI and reporting Qlik, Power BI, Tableau Applications Operational feeds AI and ML Governed SAP data ODP-RFC via third-party tools Blocked since 9 June 2026. Temporary revert expires December 2026. Governance, lineage and cost model span every layer. Route chosen per source system and per latency requirement.
Target architecture. The ingestion route is chosen per source system and per latency requirement, not once for the whole landscape.

What our accelerator does

BW migrations get into trouble over scope and over reconciliation. Our tooling addresses scope before the first sprint is planned.

Object inventory

Every InfoProvider, transformation, DTP, routine and query in the estate, cataloged.

Usage analysis

What has been read, and when. Most BW estates carry a large inactive tail. The assessment tells you how large yours is.

Lineage mapping

Source through to report, so you know what breaks when an object is retired.

Complexity scoring

Per-object effort estimates that turn a vague program into a costed wave plan.

Our consultants then convert your BW transformation logic into Snowflake SQL and dbt models, working from the lineage map as the specification. The tooling reduces the scope and gives the estimate a basis. The conversion itself is still engineering work.

How the engagement runs

  1. 01 Discovery and scope
  2. 02 Estate assessment
  3. 03 Target architecture
  4. 04 Build and convert
  5. 05 Reconciliation and parallel run
  6. 06 Cutover and handover

Every phase, with named deliverables and what goes wrong →

Who you would be working with

DI Squared has guided more than 200 companies through data work since 2008, including warehouse migrations, BI consolidations and the retirement of legacy reporting estates. We are a Snowflake Select Partner.

DR

Doug Robbins

Founder

40+ years in enterprise IT and data architecture.

RM

Rakesh Mehta

Founder

26+ years building data platforms. SAP source systems and extraction.

TS

Trey Smith

Principal, Data Platforms

Snowflake architecture and dbt. Qlik Luminary Alumni.

D

Dee

Principal Consultant, SAP BW

BW estates, transformations and migration mechanics.

Start with the BW Estate Assessment

3 to 4 weeks. $25,000 to $40,000, scoped by landscape size. You finish it knowing what is in your estate, what can be retired and what the migration costs.