What’s New with SAP Connectivity in Microsoft Fabric

For most enterprises, 𝐒𝐀𝐏 𝐢𝐬 𝐧𝐨𝐭 𝐣𝐮𝐬𝐭 𝐚𝐧𝐨𝐭𝐡𝐞𝐫 𝐬𝐲𝐬𝐭𝐞𝐦, 𝐢𝐭'𝐬 𝐭𝐡𝐞 𝐜𝐨𝐫𝐞 𝐨𝐟 𝐭𝐡𝐞𝐢𝐫 𝐛𝐮𝐬𝐢𝐧𝐞𝐬𝐬 𝐨𝐩𝐞𝐫𝐚𝐭𝐢𝐨𝐧𝐬. From finance and logistics to HR and procurement, critical business data lives within SAP environments. That’s why when organizations adopt Microsoft Fabric for unified analytics and AI, one of the first questions they ask is: “How can I bring my SAP data into Fabric, efficiently, securely, and at scale?”

Over the past year, we’ve been listening to this need closely. We’ve been working to enhance SAP integration options in Microsoft Fabric, giving customers more flexibility, better performance, and support for the unique complexities of SAP systems.

In this blog, we’re excited to share the 𝐥𝐚𝐭𝐞𝐬𝐭 𝐮𝐩𝐝𝐚𝐭𝐞𝐬 (𝐚𝐬 𝐨𝐟 𝐉𝐮𝐥𝐲 2025) that make it easier than ever to connect, transform, and analyze SAP data inside Microsoft Fabric.

𝐖𝐡𝐲 𝐒𝐀𝐏 𝐈𝐧𝐭𝐞𝐠𝐫𝐚𝐭𝐢𝐨𝐧 𝐌𝐚𝐭𝐭𝐞𝐫𝐬

Data silos are one of the biggest challenges in building a modern data estate. And in many organizations, 𝐒𝐀𝐏 𝐢𝐬 𝐭𝐡𝐞 𝐥𝐚𝐫𝐠𝐞𝐬𝐭 𝐚𝐧𝐝 𝐦𝐨𝐬𝐭 𝐬𝐢𝐥𝐨𝐞𝐝 𝐝𝐚𝐭𝐚 𝐬𝐨𝐮𝐫𝐜𝐞. Business users need to combine SAP data with other sources, like CRM, Azure SQL, Excel files, and external APIs, for full visibility.

Whether you're a data engineer preparing enterprise pipelines, a BI analyst blending SAP data with Power BI dashboards, or a data scientist building ML models on customer operations, 𝐢𝐧𝐭𝐞𝐠𝐫𝐚𝐭𝐢𝐧𝐠 𝐒𝐀𝐏 𝐝𝐚𝐭𝐚 𝐜𝐥𝐞𝐚𝐧𝐥𝐲 𝐢𝐧𝐭𝐨 𝐅𝐚𝐛𝐫𝐢𝐜 𝐢𝐬 𝐜𝐫𝐢𝐭𝐢𝐜𝐚𝐥.

That’s why we’ve continued to invest in making SAP connectivity more powerful, versatile, and accessible, no matter where your SAP systems are hosted or how your teams use them.

𝐓𝐡𝐫𝐞𝐞 𝐖𝐚𝐲𝐬 𝐌𝐢𝐜𝐫𝐨𝐬𝐨𝐟𝐭 𝐅𝐚𝐛𝐫𝐢𝐜 𝐄𝐧𝐚𝐛𝐥𝐞𝐬 𝐒𝐀𝐏 𝐈𝐧𝐭𝐞𝐠𝐫𝐚𝐭𝐢𝐨𝐧

Fabric is designed to support all data personas, technical and non-technical alike. Our approach to SAP integration reflects that. Today, we offer three broad methods to bring SAP data into Fabric:

1. 𝐁𝐮𝐢𝐥𝐭-𝐢𝐧, 𝐨𝐮𝐭-𝐨𝐟-𝐭𝐡𝐞-𝐛𝐨𝐱 𝐜𝐨𝐧𝐧𝐞𝐜𝐭𝐨𝐫𝐬 that cover most standard SAP scenarios.

2. 𝐒𝐮𝐩𝐩𝐨𝐫𝐭 𝐟𝐨𝐫 𝐩𝐚𝐫𝐭𝐧𝐞𝐫-𝐛𝐮𝐢𝐥𝐭 𝐜𝐨𝐧𝐧𝐞𝐜𝐭𝐨𝐫𝐬 𝐚𝐧𝐝 𝐬𝐨𝐥𝐮𝐭𝐢𝐨𝐧𝐬 for niche or advanced cases.

3. 𝐃𝐞𝐞𝐩𝐞𝐫 𝐢𝐧𝐭𝐞𝐠𝐫𝐚𝐭𝐢𝐨𝐧𝐬 𝐰𝐢𝐭𝐡 𝐒𝐀𝐏’𝐬 𝐚𝐧𝐚𝐥𝐲𝐭𝐢𝐜𝐬 𝐩𝐥𝐚𝐭𝐟𝐨𝐫𝐦𝐬 like SAP Datasphere (coming soon).

This post focuses on the first two options: built-in and partner-enabled integrations. The third, strategic SAP-Microsoft integration, will be the subject of a future blog.

𝐁𝐮𝐢𝐥𝐭-𝐢𝐧 𝐒𝐀𝐏 𝐂𝐨𝐧𝐧𝐞𝐜𝐭𝐢𝐯𝐢𝐭𝐲 𝐢𝐧 𝐌𝐢𝐜𝐫𝐨𝐬𝐨𝐟𝐭 𝐅𝐚𝐛𝐫𝐢𝐜

The core of Microsoft Fabric’s integration capabilities is 𝐃𝐚𝐭𝐚 𝐅𝐚𝐜𝐭𝐨𝐫𝐲, which includes a vast catalog of connectors 170+ and counting. It supports both batch and near real-time ingestion, and is used across pipelines, dataflows, and copy activities.

SAP systems are unique in their structure, protocols, and performance requirements. That’s why we’ve focused on providing 𝐝𝐞𝐝𝐢𝐜𝐚𝐭𝐞𝐝 𝐜𝐨𝐧𝐧𝐞𝐜𝐭𝐨𝐫𝐬 that can handle SAP's complexity at enterprise scale.

Here’s what’s available today:

🟩 𝐒𝐀𝐏 𝐇𝐀𝐍𝐀 𝐂𝐨𝐧𝐧𝐞𝐜𝐭𝐨𝐫

𝐈𝐧𝐭𝐫𝐨𝐝𝐮𝐜𝐞𝐝: March 2024 𝐀𝐯𝐚𝐢𝐥𝐚𝐛𝐥𝐞 𝐢𝐧: Dataflows Gen2, Pipelines, Copy Jobs

SAP HANA is one of the most common backbones in modern SAP landscapes. The SAP HANA connector provides:

• Scalable data extraction using partitioning

• Support for parameterized SQL queries

• Access to HANA Calculation Views and SQL artifacts

Ideal for structured, high-performance extraction tasks, this connector is used across both operational and analytical scenarios.

🟩 𝐒𝐀𝐏 𝐁𝐖 𝐂𝐨𝐧𝐧𝐞𝐜𝐭𝐨𝐫

𝐀𝐯𝐚𝐢𝐥𝐚𝐛𝐥𝐞 𝐢𝐧: Dataflows Gen2

SAP BW (Business Warehouse) and BW/4HANA systems are rich sources of multidimensional analytics data. This connector enables access to:

• BW InfoProviders, cubes, and ADSOs

• Pre-aggregated business logic and reporting layers

• Analytic content consumed by Power BI or Excel

It’s especially useful for business analysts who want to build dashboards or reports based on curated SAP data models.

🆕 𝐒𝐀𝐏 𝐓𝐚𝐛𝐥𝐞 𝐂𝐨𝐧𝐧𝐞𝐜𝐭𝐨𝐫

𝐍𝐞𝐰 𝐢𝐧 2025 𝐀𝐯𝐚𝐢𝐥𝐚𝐛𝐥𝐞 𝐢𝐧: Pipelines

This was one of the 𝐦𝐨𝐬𝐭 𝐫𝐞𝐪𝐮𝐞𝐬𝐭𝐞𝐝 𝐟𝐞𝐚𝐭𝐮𝐫𝐞𝐬 by SAP customers.

The SAP Table connector provides direct access to:

• SAP data dictionary tables (DDIC)

• Views and ABAP CDS Views in ECC and S/4HANA

• Custom Z-tables and standard SAP transactional data

It supports 𝐩𝐚𝐫𝐭𝐢𝐭𝐢𝐨𝐧𝐢𝐧𝐠, critical for extracting high-volume data safely and efficiently.

🆕 𝐒𝐀𝐏 𝐁𝐖 𝐎𝐩𝐞𝐧𝐇𝐮𝐛 𝐂𝐨𝐧𝐧𝐞𝐜𝐭𝐨𝐫

𝐍𝐞𝐰 𝐢𝐧 2025 𝐀𝐯𝐚𝐢𝐥𝐚𝐛𝐥𝐞 𝐢𝐧: Pipelines

This connector is designed for 𝐥𝐚𝐫𝐠𝐞-𝐬𝐜𝐚𝐥𝐞 𝐞𝐱𝐭𝐫𝐚𝐜𝐭𝐢𝐨𝐧𝐬 from SAP BW using OpenHub destinations. It connects to BW InfoProviders such as ADSOs and InfoCubes and enables:

• Controlled data extraction

• Support for external ETL/ELT processes

• Use in robust enterprise data pipelines

🟦 𝐎𝐃𝐚𝐭𝐚 𝐂𝐨𝐧𝐧𝐞𝐜𝐭𝐨𝐫 𝐟𝐨𝐫 𝐒𝐀𝐏 𝐒𝐞𝐫𝐯𝐢𝐜𝐞𝐬

𝐀𝐯𝐚𝐢𝐥𝐚𝐛𝐥𝐞 𝐢𝐧: Pipelines, Dataflows Gen2

Many SAP solutions expose data via OData services, especially in SAP S/4HANA, ECC, SuccessFactors, and SAP C4C. This connector is your go-to option for those use cases.

It supports:

• RESTful API access to SAP business objects

• Secure token-based authentication

• Support for incremental loading in OData v4

🟦 𝐎𝐃𝐁𝐂 𝐂𝐨𝐧𝐧𝐞𝐜𝐭𝐨𝐫 𝐟𝐨𝐫 𝐒𝐀𝐏 𝐇𝐀𝐍𝐀 𝐚𝐧𝐝 𝐃𝐚𝐭𝐚𝐬𝐩𝐡𝐞𝐫𝐞

𝐀𝐯𝐚𝐢𝐥𝐚𝐛𝐥𝐞 𝐢𝐧: Pipelines, Dataflows Gen2

ODBC remains a versatile way to connect to SQL-based SAP systems. If you’re working with SAP HANA, SAP HANA Cloud, or SAP Datasphere, this connector offers:

• SQL access to tables and views

• Flexible data integration into Lakehouse and Data Warehousing workloads

𝐀𝐫𝐜𝐡𝐢𝐭𝐞𝐜𝐭𝐮𝐫𝐞 𝐍𝐨𝐭𝐞: 𝐃𝐨𝐧’𝐭 𝐅𝐨𝐫𝐠𝐞𝐭 𝐭𝐡𝐞 𝐆𝐚𝐭𝐞𝐰𝐚𝐲

All built-in SAP connectors leverage the 𝐎𝐧-𝐩𝐫𝐞𝐦𝐢𝐬𝐞𝐬 𝐃𝐚𝐭𝐚 𝐆𝐚𝐭𝐞𝐰𝐚𝐲 (𝐎𝐏𝐃𝐆) to establish secure communication between your SAP systems and Microsoft Fabric.

Make sure the following prerequisites are in place:

• The OPDG is installed on a VM or server that can access your SAP environment

• SAP client libraries are installed (e.g., SAP .Net Connector, SAP HANA ODBC driver)

• Network rules and firewalls are configured for bi-directional access

𝐒𝐮𝐦𝐦𝐚𝐫𝐲: 𝐂𝐡𝐨𝐨𝐬𝐢𝐧𝐠 𝐭𝐡𝐞 𝐑𝐢𝐠𝐡𝐭 𝐂𝐨𝐧𝐧𝐞𝐜𝐭𝐨𝐫

Here’s a quick reference guide to help you choose the right connector based on your source system and integration goal:

𝐖𝐡𝐚𝐭’𝐬 𝐍𝐞𝐱𝐭?

While we’ve covered the built-in SAP connectivity capabilities available today, we’re not stopping here. Our engineering teams are actively working on 𝐝𝐞𝐞𝐩𝐞𝐫 𝐢𝐧𝐭𝐞𝐠𝐫𝐚𝐭𝐢𝐨𝐧 𝐰𝐢𝐭𝐡 𝐒𝐀𝐏’𝐬 𝐚𝐧𝐚𝐥𝐲𝐭𝐢𝐜𝐬 𝐞𝐜𝐨𝐬𝐲𝐬𝐭𝐞𝐦, particularly SAP Datasphere and SAP Business Data Cloud. These enhancements will unlock:

• Bi-directional data flows

• Unified governance and semantics across platforms

• Modern hybrid data mesh architectures

Stay tuned for upcoming announcements, demos, and architectural guidance in the next phase of our SAP-Fabric integration journey.

Final Thoughts

SAP data is rich, powerful, and often underutilized due to integration challenges. With Microsoft Fabric, we’re making it easier for enterprises to 𝐥𝐢𝐛𝐞𝐫𝐚𝐭𝐞 𝐭𝐡𝐚𝐭 𝐝𝐚𝐭𝐚, combine it with other sources, and create a foundation for 𝐚𝐧𝐚𝐥𝐲𝐭𝐢𝐜𝐬, 𝐫𝐞𝐩𝐨𝐫𝐭𝐢𝐧𝐠, 𝐚𝐧𝐝 𝐀𝐈 at scale.

Whether you're just getting started with SAP connectivity or looking to modernize your entire data estate, Fabric is ready to meet you where you are.

👉 𝐇𝐚𝐯𝐞 𝐪𝐮𝐞𝐬𝐭𝐢𝐨𝐧𝐬 𝐨𝐫 𝐟𝐞𝐞𝐝𝐛𝐚𝐜𝐤? Connect with us through the Microsoft Fabric community.