Forum Discussion
fabric mirroring
hi im reading this article at https://learn.microsoft.com/en-us/fabric/mirroring/overview and wonder 2 things...
1) what if we want to mirror excel spreadsheet changes too?
2) one of our data sources is sap s4 hana. clearly mirroring does some sort of polling with some sort of frequency on the data source. the article suggests sap is an allowable data source but sap can mean anything and if im not mistaken can even mean the sap analytics layer which we may or may not have. the main question is "will/would the s4 users feel the impact of fabric mirroring continuously polling the sap data source for changes?" after all we are all trying to avoid pressure on source erp systems. i am aware that certain change data technologies poll logs which is supposed to be a zero impact approach but that is on sql server.
6 Replies
- db042190Impactful Individual
i dont know what datasphere is yet but this at least looks like how one gets started. there are many more steps after this but the overriding question is still what kind of impact will this have on s4 hana users. maybe datasphere is abstracted from the erp itself. i'm looking that up now.
- db042190Impactful Individual
it looks like sap datasphere is an sap console of some sort so that helps to fill in the puzzle. things u set up there are then plumbed to fabric so i kind of get the picture. so the question is what is the impact going to be on the erp users themselves? i dont think we'd do this at a database level. rather at a critical/core table level instead.
- db042190Impactful Individual
i just learned datasphere is expensive. and we dont have it.
- ShivekMaharajPower Participant
Hi db042190,
That changes the picture quite a bit.
For Microsoft’s native SAP Mirroring path, SAP Datasphere is currently part of the architecture. Microsoft documents the flow as:
SAP S/4HANA -> SAP Datasphere replication flow -> ADLS Gen2 -> Fabric Mirroring -> OneLakeThe Datasphere replication flow handles both the initial snapshot and subsequent change records, and Fabric then continuously merges those changes into the mirrored database.
Microsoft documents that architecture here: Mirroring SAP in Microsoft Fabric.
So if you do not have SAP Datasphere, I would not expect to be able to enable that exact native SAP Mirroring experience directly against S/4HANA.
You do still have other options though.
If your S/4HANA system exposes data through SAP ODP, Microsoft’s SAP CDC capabilities can extract incremental changes from sources such as ABAP CDS views rather than repeatedly polling the whole source. Microsoft documents that the SAP CDC connector supports S/4HANA and does not rely on simple watermark-based extraction.
That architecture is more along the lines of:
S/4HANA / ODP -> SAP CDC -> Fabric ingestion -> OneLakerather than native Fabric Mirroring.
Another option is Open Mirroring through one of Microsoft’s partner integrations. Microsoft currently lists solutions such as CData Sync that can mirror SAP sources into Fabric through Open Mirroring.
So I would separate the choices like this:
- Have SAP Datasphere: use Microsoft’s native SAP Mirroring path
- No Datasphere, but SAP ODP/CDS is available: investigate SAP CDC
- Want a mirroring-style experience without Datasphere: evaluate an Open Mirroring partner
- Simple periodic extraction is enough: a normal pipeline/copy approach may still be perfectly reasonable
On your earlier question about telling S/4 users that data has changed, I would also avoid trying to force that notification into the mirroring layer itself. Mirroring/CDC is mainly about capturing and propagating the change. I would usually detect the business-significant change downstream in Fabric and trigger the notification from there.
So no, I would not treat lack of Datasphere as meaning Fabric cannot work with your S/4HANA data. It mainly means the native SAP Mirroring architecture is probably not the route available to you.
AI-assisted drafting: AI was used to help structure and phrase this response. I reviewed and validated the technical content before posting.
- v-aatheequeCommunity Support
Hi db042190
Following up to confirm if the earlier responses addressed your query. If not, please share your questions and we’ll assist further.
- v-aatheequeCommunity Support
Hi db042190
Have you had a chance to look through the responses shared earlier? If anything is still unclear, we’ll be happy to provide additional support.