topic Re: SAP All-in-One Data Integration into Microsoft Fabric OneLake in Data Engineering

SAP All-in-One Data Integration into Microsoft Fabric OneLake

tan_thiamhuat — Thu, 17 Jul 2025 13:38:58 GMT

I am still confused of what are the best and neatest way to do it. I read that it can be done several ways:

a) via SAP Datasphere

b) via Open Mirroring

c) via Partners software (TheobaldSoftware, Dab, etc)

Definitely I would not go for Partners software because of the huge cost, but I am wondering if we can do it ourself since SAP itself is very complex.

Would appreciate some good suggestions.

Re: SAP All-in-One Data Integration into Microsoft Fabric OneLake

BalajiL — Thu, 17 Jul 2025 14:39:16 GMT

Fabric recommends using SAP-certified third-party solutions like DAB Nexus, Simplement, and Golden Gate, which support open mirroring.
SAP has restricted using ODP framework but the above given thrid party solutions not using ODP framework.
SAP Datasphere, with OneLake shortcuts, can also be used for data integration within Fabric.
Fabric supports on-premises data gateway to support various SAP applications. https://blog.fabric.microsoft.com/en-US/blog/integrate-your-sap-data-into-microsoft-fabric-2/

Re: SAP All-in-One Data Integration into Microsoft Fabric OneLake

tan_thiamhuat — Fri, 18 Jul 2025 01:38:11 GMT

thanks for your reply. So can I say if we use SAP Datasphere, most or all the SAP data & tables can be extracted to Fabric? how is the effort for this kind of work? is there some write-up or documentations for this kind of tasks?

Also for the Golden Gate, it is more for the Oracle product, and not SAP, isn't it?

Re: SAP All-in-One Data Integration into Microsoft Fabric OneLake

BalajiL — Fri, 18 Jul 2025 01:54:51 GMT

Yes using SAP datasphere you can integrate all SAP application like ECC ,S4HANA etc. Golden gate not only support oracle, it supports SAP application as well

Re: SAP All-in-One Data Integration into Microsoft Fabric OneLake

tan_thiamhuat — Fri, 18 Jul 2025 02:04:04 GMT

so can I say we can do it ourselves without the third-party partners, with Datasphere?

Use SAP "datasphere" to replicate to ADLS gen2 in near real time and shortcut from ADLS gen2 to Fabric.

Re: SAP All-in-One Data Integration into Microsoft Fabric OneLake

tan_thiamhuat — Fri, 18 Jul 2025 02:18:41 GMT

other way: Integrate Microsoft Fabric with SAP data with USB4SAP [in live and cached mode] | Microsoft Community Hub

Re: SAP All-in-One Data Integration into Microsoft Fabric OneLake

BalajiL — Fri, 18 Jul 2025 03:49:13 GMT

Yes that's right

Re: SAP All-in-One Data Integration into Microsoft Fabric OneLake

BhaveshPatel — Fri, 18 Jul 2025 08:27:14 GMT

You can perform all ETL, DWH and Data Lakehouse through Microsoft Fabric Dataflow Gen 2 and SAP . This is the Power Query Documentation.(Power Query documentation - Power Query | Microsoft Learn) It connects SAP HANA Database, SAP BW Application Server and SAP BW Message Server. Microsoft is adding more Get Data for ETL and DWH or Data Lakehouse.