topic How to Connect SAP ECC to Microsoft Fabric – No Native Support in Pipelines

How to Connect SAP ECC to Microsoft Fabric – No Native Support

Anonymous — Thu, 01 May 2025 07:45:12 GMT

Hi Fabric Community Team,

I am currently working on a project that involves extracting data from SAP ECC into Microsoft Fabric, and I have attempted to use both Copy Data Assistant and Dataflows Gen2 for this integration.

However, I am facing limitations as there appears to be no native SAP ECC connector available on either of these tools. I have explored options like ODATA services and ODBC via Data Gateway, but they require significant setup, custom exposure of data in SAP, and are not always feasible in enterprise environments.

Given the widespread use of ECC in enterprises, it would be extremely helpful to have:

A native SAP ECC connector in Copy Data Assistant and Dataflows Gen2
Support for standard extraction mechanisms like Direct table readings.

Can the Fabric team please advise:

If SAP ECC connectivity is currently supported or planned?
Are there any recommended patterns for ECC data extraction using only Fabric-native tools?

Any guidance or roadmap insights would be appreciated.

We badly struck there after F64 procured. not able to move even a single step there. NEED COMMUNITY ASSISTANCE IMMEDIATELY

Ramana Reddy

Thank you!

Re: How to Connect SAP ECC to Microsoft Fabric – No Native Support

Anonymous — Thu, 01 May 2025 11:03:10 GMT

Hi Anonymous ,

Thank you for reaching out to Microsoft Fabric Community Forum.

1. Is SAP ECC connectivity currently supported or planned in Microsoft Fabric?

As of now, Microsoft Fabric does not natively support direct connectivity to SAP ECC through tools like Copy Data Assistant or Dataflows Gen2.

There has been no official announcement from Microsoft about a planned native connector for SAP ECC specifically within Fabric.

However, SAP integration (especially SAP BW and SAP HANA) has been a common request, and it's possible that future updates may include improved support. For now, SAP ECC connectivity requires using external tools to extract and stage the data before bringing it into Fabric.
we recommend posting or upvoting this feature on the Microsoft Fabric Ideas forum to help bring visibility to it.

2. Are there any recommended patterns for ECC data extraction using only Fabric-native tools?

At this time, there are no fully Fabric-native patterns for extracting data directly from SAP ECC.

Fabric tools cannot connect directly to ECC systems or read tables without help from external systems.

That said, a common and recommended workaround is:

Extract data from SAP ECC using external tools like:

Azure Data Factory (ADF) with the SAP ECC or SAP Table connector
Custom ABAP programs exporting flat files
ODBC connectors via On-Premises Data Gateway (complex setup)

Land the data in Azure Data Lake or Blob Storage
Use Fabric-native tools (Copy Data Assistant, Dataflows Gen2, or Lakehouse Shortcuts) to bring that data into Fabric for transformation, modeling, and reporting

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!

Regards,

B Manikanteswara Reddy

Re: How to Connect SAP ECC to Microsoft Fabric – No Native Support

Anonymous — Mon, 05 May 2025 07:00:13 GMT

Hi Anonymous ,

We wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?

If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,

B Manikanteswara Reddy

Re: How to Connect SAP ECC to Microsoft Fabric – No Native Support

Anonymous — Thu, 08 May 2025 11:46:57 GMT

Hi @Ramanareddyp ,

We wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?

If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,

B Manikanteswara Reddy

Re: How to Connect SAP ECC to Microsoft Fabric – No Native Support

Anonymous — Mon, 12 May 2025 04:40:02 GMT

Hi Anonymous ,

May I ask if you have gotten this issue resolved?

If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

Regards,

B Manikanteswara Reddy

Re: How to Connect SAP ECC to Microsoft Fabric – No Native Support

ajay_0036 — Tue, 30 Jun 2026 12:48:36 GMT

Hi everyone,

I'm currently working on a project where I need to ingest data from an SAP ECC on-premises system into Microsoft Fabric without establishing a VPN connection between the on-premises environment and Azure.

While going through the documentation, I came across a couple of possible approaches:

Self-hosted Integration Runtime (SHIR) for securely accessing on-premises systems from Microsoft Fabric/Data Factory.
SAP OData APIs exposed through an API Gateway (or reverse proxy) so Fabric can consume the APIs over HTTPS.

I would appreciate some guidance from the community on the following questions:

Are these the recommended approaches for connecting SAP ECC on-premises to Microsoft Fabric without a VPN?
Which approach is generally preferred in production environments, and why?
What are the prerequisites on the SAP side (SAP Basis, ABAP, Gateway, network, security, etc.) for each option?
Is SHIR required when consuming SAP OData APIs, or can Fabric directly call externally exposed APIs over HTTPS?
Are there any other recommended enterprise-grade approaches that I should consider (for example, SAP connectors, Azure Relay, or other secure connectivity options)?
If you've implemented a similar architecture, could you share the high-level architecture and any lessons learned or best practices?

My goal is to build a secure, scalable, and production-ready integration between SAP ECC on-premises and Microsoft Fabric while avoiding a VPN.

Thanks in advance for your insights!