Skip to content
NextLytics
Megamenü_2023_Über-uns

Shaping Business Intelligence

Whether clever add-on products for SAP BI, development of meaningful dashboards or implementation of AI-based applications - we shape the future of Business Intelligence together with you. 

Megamenü_2023_Über-uns_1

About us

As a partner with deep process know-how, knowledge of the latest SAP technologies as well as high social competence and many years of project experience, we shape the future of Business Intelligence in your company too.

Megamenü_2023_Methodik

Our Methodology

The mixture of classic waterfall model and agile methodology guarantees our projects a high level of efficiency and satisfaction on both sides. Learn more about our project approach.

Products
Megamenü_2023_NextTables

NextTables

Edit data in SAP BW out of the box: NextTables makes editing tables easier, faster and more intuitive, whether you use SAP BW on HANA, SAP S/4HANA or SAP BW 4/HANA.

Megamenü_2023_Connector

NextLytics Connectors

The increasing automation of processes requires the connectivity of IT systems. NextLytics Connectors allow you to connect your SAP ecosystem with various open-source technologies.

IT-Services
Megamenü_2023_Data-Science

Data Science & Engineering

Ready for the future? As a strong partner, we will support you in the design, implementation and optimization of your AI application.

Megamenü_2023_Planning

SAP Planning

We design new planning applications using SAP BPC Embedded, IP or SAC Planning which create added value for your company.

Megamenü_2023_Dashboarding

Business Intelligence

We help you with our expertise to create meaningful dashboards based on Tableau, Power BI, SAP Analytics Cloud or SAP Lumira. 

Megamenü_2023_Data-Warehouse-1

SAP Data Warehouse

Are you planning a migration to SAP HANA? We show you the challenges and which advantages a migration provides.

Business Analytics
Megamenü_2023_Procurement

Procurement Analytics

Transparent and valid figures are important, especially in companies with a decentralized structure. SAP Procurement Analytics allows you to evaluate SAP ERP data in SAP BI.

Megamenü_2023_Reporting

SAP HR Reporting & Analytics

With our standard model for reporting from SAP HCM with SAP BW, you accelerate business activities and make data from various systems available centrally and validly.

Megamenü_2023_Dataquality

Data Quality Management

In times of Big Data and IoT, maintaining high data quality is of the utmost importance. With our Data Quality Management (DQM) solution, you always keep the overview.

Career
Megamenü_2023_Karriere-2b

Working at NextLytics

If you would like to work with pleasure and don't want to miss out on your professional and personal development, we are the right choice for you!

Megamenü_2023_Karriere-1

Senior

Time for a change? Take your next professional step and work with us to shape innovation and growth in an exciting business environment!

Megamenü_2023_Karriere-5

Junior

Enough of grey theory - time to get to know the colourful reality! Start your working life with us and enjoy your work with interesting projects.

Megamenü_2023_Karriere-4-1

Students

You don't just want to study theory, but also want to experience it in practice? Check out theory and practice with us and experience where the differences are made.

Megamenü_2023_Karriere-3

Jobs

You can find all open vacancies here. Look around and submit your application - we look forward to it! If there is no matching position, please send us your unsolicited application.

Blog
NextLytics Newsletter Teaser
Sign up now for our monthly newsletter!
Sign up for newsletter
 

SAP BW Bridge

What is SAP BW Bridge ?

Definition

SAP BW Bridge is a transition solution that enables organizations to migrate SAP BW (Business Warehouse) systems to SAP Datasphere (formerly SAP Data Warehouse Cloud).


It acts as a bridge between legacy on-premise BW environments and modern cloud-based data architectures, allowing enterprises to retain their existing BW investments while transitioning to a cloud-first strategy.

However, with the introduction of SAP Business Data Cloud (BDC), BW Bridge is no longer the only path for bringing your BW assets to the cloud. Organizations can now choose between the following options:

 

BW-Bridge-1

 

  • SAP BW Bridge
    Hybrid cloud approach, designed for those still relying on SAP ECC with legacy extractors that cannot connect to Datasphere Core. BW Bridge primarily serves as a staging area for data that cannot be processed otherwise.
  • BW Private Cloud Edition (PCE)
    BW on HANA or BW/4HANA hosted in a managed private cloud environment within SAP Business Data Cloud.
  • Direct Migration to SAP Datasphere
    Suitable for simpler BW landscapes, bypassing BW Bridge entirely, and allowing for parallel use of your existing BW system.

If you want to find out which of the three options suits you best, check out our project experiences and our decision tree in the whitepaper.

Download Whitepaper:
Is SAP BW Bridge a smart transition or rather a detour? 

BW Bridge or SAP BDC? Discover when each solution makes sense.
Compare features, migration hurdles and ABAP Cloud compatibility.
Learn from real project experience and avoid common pitfalls.
Download your free white paper now and make smarter cloud data decisions.  

Why should SAP BW Bridge interest you?

Many enterprises are under growing pressure to move towards scalable, flexible, and cost-efficient cloud strategies. However, BW systems hold decades of mission-critical data models, transformations, and governance structures that cannot simply be replaced without significant effort and risk.

SAP BW Bridge offers a structured, low-risk path, to modernization by ensuring:

  • Existing BW assets remain usable
    BW 7.5 objects and models can be leveraged without major redevelopment.
  • Seamless integration with SAP Datasphere
    Enables a hybrid approach, combining existing BW data with cloud-native innovations.
  • Security and governance continuity
    BW Bridge preserves access controls, authorizations, and governance models during migration.
  • Minimal impact on IT teams
    BW Bridge reduces the need for immediate retraining, especially if you are coming from a BW/4HANA System, allowing BW experts to transition gradually.

SAP BW Bridge is not just a migration tool, it serves as a strategic enabler for companies looking to modernize their analytics landscape while maintaining continuity, security, and cost-efficiency.

However, with the availability of SAP Business Data Cloud and BW Private Cloud Edition (PCE), organizations now have multiple paths to the cloud. Therefore, it’s essential to take a closer look at when BW Bridge remains a viable choice and when other solutions might be more suitable.

Non BDC

1.

SAP Datasphere with BW Bridge

  • Maintenance: until end of 2040
  • Costs: Capacity Units (regulated)
  • Migration effort: high
  • Prerequisite: none
  • BW-Reporting: not available
  • No planning / reporting

SAP Datasphere with BW Bridge

BDC

2.

SAP Datasphere with BW 7.5 PCE

  • Maintenance: until end of 2030٭
  • Costs: Capacity Units٭٭
  • Migration effort: low
  • Prerequisite: SAP RISE
  • BW-Reporting: available
  • Planning / Reporting available

SAP Datasphere with BW 7.5 PCE

BDC / non BDC

3.

SAP Datasphere with BW/4 (PCE)

  • Maintenance: until end of 2040
  • Costs: Licenses or Capacity Units٭٭
  • Migration effort: low
  • Prerequisite: SAP RISE / none
  • BW-Reporting: available
  • Planning / Reporting available

SAP Datasphere with BW/4 (PCE)

 ٭ extended maintenance free of charge      ٭٭ subsidized according to SAP (information without guarantee)

How does SAP BW Bridge fit in my Data Strategy and Architecture?

BW Bridge as a Transitional Layer in Your Data Architecture

BW Bridge acts as a bridge between on-premise BW systems and SAP Datasphere, facilitating a hybrid cloud architecture that supports legacy BW objects while enabling modern data use cases.

  • BW/4HANA
    You can utilize Model Transfer for a smoother migration to SAP Datasphere, minimizing redevelopment efforts.
  • BW on HANA
    A more detailed SAP Readiness Check is required to assess your BW objects and understand the effort needed for conversion.

In both cases, BW Bridge allows you to maintain historical transformations, governance structures, and extractors while transitioning to the cloud.

Future Data Strategy & the Role of BW Bridge

SAP's future data strategy is centered around SAP Datasphere and the SAP Business Data Cloud, the next-generation data platform for enterprise-wide analytics. As SAP moves further into the cloud, BW Bridge serves as an interim solution to safeguard existing investments without requiring immediate full-scale migration.

 

  • Early Cloud Adoption: Adopting BW Bridge earlier helps address challenges before BW environments become more complex.
  • Legacy System Continuity: Bridge ensures that historical investments and legacy systems remain operational and valuable within the modern data ecosystem.


BDC Alignment: While BW Bridge facilitates hybrid transitions, SAP Business Data Cloud now offers SAP BW in the cloud (PCE), providing an alternative path for organizations ready to fully embrace the cloud.

Architectural Benefits of BW Bridge in Data Strategy

BW Bridge brings several architectural advantages when used as part of a broader data strategy:

Hybrid Data Architecture
  • Operate legacy and modern systems in parallel during the transition period.
  • Integrate legacy data flows with SAP Datasphere while maintaining BW-based transformations.

Icon Data architecture

 

Modern Data Integration
  • In a hybrid approach, BW Bridge allows older data flows to integrate with modern platforms, such as Databricks for ML/AI applications and other third-party ecosystems.
  • With the introduction of SAP Business Data Cloud (BDC), native integration with Databricks is now available. This direct connectivity simplifies modern data workflows, reducing the need for BW Bridge as an intermediary for advanced analytics and AI use cases.

Data Strategy

 

Cost Efficiency & Reduced Redevelopment
  • Older BW objects are migrated and used in SAP Datasphere via remote tables, avoiding costly redevelopment.

Income

 

Long-Term Architectural Considerations

While BW Bridge facilitates a phased cloud transition, it's important to consider the long-term strategic fit of this approach:

  •  Wave-by-Wave Migration: BW Bridge supports incremental migration, allowing organizations to modernize their data architecture at their own pace. 
  • Cloud-Ready Platform: As BW/4HANA support ends in 2040, BW Bridge provides a pathway to standardized, enterprise-wide data models within SAP Datasphere.
  • BDC as the Future Standard: While BW Bridge ensures continuity, SAP Business Data Cloud offers a more streamlined, long-term solution for cloud-first enterprises.

BW-Bridge_2

 

Conclusion

BW Bridge fits well into your data strategy if:

  • You need a hybrid cloud approach, retaining BW assets while adopting modern cloud platforms.
  • You want to avoid redevelopment costs and preserve historical investments.
  • Your BW system is 7.5+, and you plan to migrate incrementally.

However, for organizations ready for a full-cloud transition, SAP Business Data Cloud (BDC) now provides a more future-proof, simplified architecture with BW/4HANA Private Cloud Edition (PCE), reducing the need for BW Bridge in many scenarios.

How does Governance in SAP BW Bridge work compared to SAP BW

Governance in SAP BW Bridge differs significantly from traditional SAP BW due to its cloud-centric design and tighter integration with SAP Datasphere. While SAP BW provided centralized, role-based governance, BW Bridge adopts a distributed governance model, leveraging Spaces within SAP Datasphere for more flexible, domain-specific data management.

 

Key Governance Changes in SAP BW Bridge

 

SAP BW

SAP BW Bridge

 Reporting Authorization 

 Analysis Authorizations for data access. 

 No direct reporting. Reporting happens in SAP Datasphere with DAC. 

User & Role Management 

 Managed within BW using a traditional role concept

 IAM-based user management in the BW Bridge Cockpit. 

Data Access Control (DAC)

 Role- and hierarchy-based data access. 

Managed via SAP Datasphere DAC, enabling row-level access

 IT Governance Strategy 

Centralized BW structure.

Decentralized governance using Spaces in SAP Datasphere. 

 

Governance Best Practices for BW Bridge

  • Restrict BW Bridge Access: Limit access to BW developers only.
  • Centralized IT Space: Use a dedicated IT Space within SAP Datasphere for global governance.
  • Implement DACs: Leverage Data Access Controls for row-level data access.

ABAP vs. ABAP Cloud: Understanding the Key Differences

The shift from Classic ABAP to ABAP Cloud represents more than just a technical change, it's a fundamental transformation in how ABAP development is approached within modern SAP environments. ABAP Cloud aligns with SAP’s cloud-first strategy, emphasizing security, API-based integration, and lifecycle management within platforms like SAP BTP and SAP Business Data Cloud (BDC).

Key Restrictions in ABAP Cloud Development

Only Released APIs Can Be Used

No Direct Database Access 
  • Classic Open SQL and direct DB operations are not supported. Only released database tables can be accessed directly in the ABAP Cloud Coding.
  • Alternative: Use CDS Views, AMDP (ABAP Managed Database Procedures), and ABAP SQL instead.
No SAP GUI
  • ABAP Development Tools (ADT) in Eclipse replaces SAP GUI as the primary development environment. Some functionality only available in Bridge Cockpit (e.g., communication agreement, process chain modeling and monitoring, technical monitoring & system analyses)

New Transport Mechanism
  • Transport management now relies on Git-based Change and Transport System (gCTS) rather than STMS.

Conclusion

The transition from Classic ABAP to ABAP Cloud represents a fundamental shift in how SAP development is approached within modern cloud environments. It enforces stricter governance, API-based development, and Git-based transport management, aligning with SAP’s cloud-first strategy.

Adopting ABAP Cloud is not optional for organizations moving to SAP BTP or SAP BW Bridge. It requires:

  • Skill adaptation:  Upskilling teams in CDS, RAP, and ABAP SQL.
  • Process change: Implementing gCTS for transport management.
  • Governance alignment: Enforcing API-based extensions and ATC checks.

However with SAP BW Private Cloud Edition (PCE) this is a different story.

  • ABAP Cloud is not strictly required. BW PCE retains Classic ABAP functionality.
  • Organizations can continue using SAP GUI and traditional development practices without adopting the ABAP Cloud model.
  • Upskilling in ABAP Cloud is optional, unless you plan to extend BW functionality using SAP BTP or cloud-native workflows.

In essence, while ABAP Cloud is mandatory for SAP BTP and BW Bridge, it remains optional for BW PCE customers, allowing them to maintain existing ABAP practices without immediate transformation.

What are the Skills I need on my team ?

Successfully adopting SAP BW Bridge and SAP Datasphere requires a blended skillset, combining traditional BW expertise with modern cloud-native competencies. While SAP BW Private Cloud Edition (PCE) retains Classic ABAP workflows, BW Bridge and Datasphere demand upskilling in ABAP Cloud, SQL-based modeling, and cloud transport management.

Key Skill Areas

SAP BW Bridge
  • ABAP Cloud: For custom developments in BW Bridge and BTP.
    • Not required for BW PCE, but essential if extending BW functionality to the cloud.
  • AMDP:  High-performance transformations.
  • BW Modeling Tools:  For Eclipse-based BW object modeling .
  • BW Bridge Cockpit:  System monitoring and user management.
  • gCTS (Git-based Transport):  Required for cloud transport in BW Bridge.
SAP Datasphere
  • SQL/SQLScript: Data transformation and querying.
  •  Modeling & Data Integration : Building Analytical Datasets and connecting sources.
  • CDS Views:  Creating and managing Core Data Services.
  •  Space Concept:  Managing governance and data flows across departments.
  • Data Catalog: Organizing metadata and ensuring data lineage.

Key Team Roles

The following table outlines key team roles, their primary responsibilities, and some additional skills that would be beneficial for success in each role. While these skills are not exhaustive, they complement the core competencies required for each position and help ensure smooth execution of tasks within an SAP environment .

 

 Responsibilities

 Required Skills 

 SAP BW Developer 

BW modeling, process chains, and SQL-based transformations 

ABAP, BW Tools, SQLScript 

 SAP BW Administrator 

System management, user roles, gCTS transport 

BW Bridge Cockpit, IAM, Space Management, gCTS 

 ABAP Developer 

Custom developments and API-based extensions

ABAP, ABAP Cloud, CDS, AMDP, gCTS

 Data Engineer (DSP) 

Data pipelines and modeling in SAP Datasphere 

SQL, Datasphere Modeling, Data Integration 

 Business Analyst 

Data cataloging and analytical modeling 

Datasphere Analytics, Space Concept, BI Tools (e.g. SAC) 

 

Conclusion

  • ABAP Cloud: Required for BW Bridge, but not needed for BW PCE unless extending into SAP BTP.
  • gCTS: Needed for cloud-based transports in BW Bridge. STMS remains standard in BW PCE.
  • Datasphere Readiness: Ensure skills in SQL, CDS, Space Management, and Analytical Models.

With BW PCE, you can maintain Classic ABAP workflows, while BW Bridge and Datasphere require cloud-oriented upskilling to ensure smooth operations and future compatibility.

Migration Paths and Steps

 When planning your move to SAP BW Bridge within SAP Datasphere, you should carefully consider which migration path best suits your goals and system landscape. 

Define Your Migration Goals

Before starting any technical migration, clarify what you want to achieve with BW Bridge:

 

Data Staging Only 

If you primarily need BW Bridge for data staging to connect ODP-based source systems with classic S-API extractors, you might keep most of your modeling in SAP Datasphere 

Modubild_Icons_Big-Data_5

 

Preserving Business Content 

If you want to maintain a large portion of your existing SAP BW business content (i.e., entire data flows including business logic through to CompositeProviders), plan accordingly. This approach may involve more effort but can preserve key parts of your legacy system. 

Modubild_Icons_Business-Project

 

Complex applications written in ABAP 

These cannot be transferred directly to Datasphere but need to be migrated. No big space needed, but still the need to adapt coding for ABAP Cloud.

Code

 

A clear scope definition helps determine which migration path (shell or remote) is most appropriate and ensures you anticipate important dependencies along the way. Alongside with that a SAP Readiness Check with the ABAP Program RS_B4HANA_CODE_SCAN should be done.

 

Remote Conversion

Shell Conversion

 Metadata Transfer 

✅  Automated 

✅  Automated 

Data Transfer 

✅  Automated 

❌  Manual 

Delta Queue Handling

✅  Automated clone

❌  Manual init 

Add-on  Requirement 

❌  DMIS required 

✅None

System Complexity 

⚠️ High

✅ Low

Flexibility 

⚠️  Less flexible 

✅  More flexible 

 

Possible Migration Paths

In principle, migration to BW Bridge can follow approaches similar to BW/4HANA. Two key strategies come into play:

1. Shell Conversion

  • Transfers only structures and objects, without historical data.
  • Suitable if you want a “clean” new setup and plan to reload data later.

2. Remote Conversion

  • Transfers both objects and existing data.
  • Ideal if you want to retain historical data and ensure continuity without a major data reload .

BW-Bridge_1-1

 

Regardless of the approach, it is essential to conduct a scope definition up front to decide which data flows, queries, and custom developments should actually be moved to BW Bridge.

Key Technical Considerations

 Migrating to BW Bridge goes beyond a simple “lift and shift.” While many BW features carry over, some objects and functionalities are changed, replaced, or require manual adaptation.

  • Supported Objects and Source Systems
    Not all classic BW objects are supported in BW Bridge (for example, BW planning objects). Source systems must be ODP-compatible (e.g., ODP-SAP, ODP-BW, ODP-CDS).
  • Custom ABAP  and Z-Tables
    Custom developments must be moved to the BW Bridge ABAP Cloud stack via ABAPgit. Pay special attention to dependencies: determine whether BW objects or custom code should be migrated first, ensuring everything is in sync for activation.
  • HANA Calculation Views
    Any BW models relying on HANA CalculationViews require additional effort. Migrate them to HDI containers first, then integrate them to Datasphere using SAP Business Application Studio or Cloud Foundry.

For further insights, download our whitepaper, where we share our experiences and key learnings from developing with BW Bridge.

Conversion Paths to SAP Datasphere, SAP BW Bridge:

SAP BW SAP Datasphere, SAP BW Bridge

Tool-Based / Manual / Semi-Automated

BEx Analyzer, BEx Web Templates, BEx Tools

SAP Analytics Cloud

BW Query (BEx Query Designer)

Model Transfer

Classic Object Types (InfoCube, DSO, MultiProvider, InfoSet...)

DataStore Object (adv.) & CompositeProvider

 Object Type InfoObject

InfoObject

Loading Object Types ( Transformation, DTP, Process Chain)

Transformation, DTP, BW Bridge Process Chain

SAPGUI Modeling & Workbench

Eclipse based BW Modeling Tools & BW Bridge Cockpit (UI5)

Source System types ERP Extractors (S-API), BW

Consolidation to ODP

Source System UD/DB Connect, Data Services

Consolidation to SAP Datasphere

Source System Types HANA, File

Consolidation to SAP Datasphere

PSA / InfoPackages

Operational Delta Queue, field-based DataStore Object (adv.)

BI Content Packages

SAP BW Bridge Content

Near-line Storage Partner Solutions, Near-line Storage SAP

HANA Data Lake Cold Storage

 

Migrating Queries to BW Bridge

Although SAP BW queries can be transferred to BW Bridge during migration, they cannot be executed in the same way as in a classic BW system or be used as a direct source for other data targets. Instead, they appear in BW Bridge purely as metadata.

  •  Foundation for SAP Datasphere 
    The query metadata from BW Bridge can be imported into SAP Datasphere, where it serves as a blueprint for creating Analytic Models. Once the Analytic Model is generated based on your query, you can refine or enhance key figures and dimensions directly in Datasphere, tailoring them for your future reporting strategy.
  • Reporting Strategy
    Decide early on how you plan to handle reporting within Datasphere and what part existing BW queries will play. It helps you determine how best to leverage existing BW logic for your future reporting and which elements (like key figures or hierarchies) should be re-created or refined in Datasphere.
  • Critical Limitations with Entity Import 
     Due to a restrictive set of supported query features, the import process often fails or omits key elements, leading to manually recreate advanced key figures in Datasphere (see SAP Note 2932647). In practice, focusing automation on CompositeProviders and rebuilding complex query logic by hand tends to be more efficient 


    BW Bridge Datasphere Shell Conversion

    Shell Conversion Example

Contact us - we will be happy to help you

Do you need help defining your data warehouse strategy? Or do you have questions about SAP Datasphere, SAP BW/4HANA, SAP HANA Data Warehouse or SAP Cloud Platform? We would be happy to advise you on all aspects of data warehousing, reporting and analysis.  

Would you like to learn more about SAP Data Warehouse?

Find interesting articles about this topic in our Blog

Best practices of implementing Change Data Capture (CDC) on CDS Views

A few weeks ago we have written about SAP’s Virtual Data Model and how well it fits together with ...

Best practices of implementing Change Data Capture (CDC) on CDS Views

Using Currency Conversion in SAP Datasphere with S/4HANA

Currency conversion is a foundational component in global business analytics. With organizations...

Using Currency Conversion in SAP Datasphere with S/4HANA

SAP Datasphere and SAP S/4HANA’s Virtual Data Model (VDM)

SAP S/4HANA’s Virtual Data Model (VDM) provides a semantically rich layer on top of raw HANA...

SAP Datasphere and SAP S/4HANA’s Virtual Data Model (VDM)
Table Of Contents
Whitepaper Pages Blogs