Reference: Microsoft Fabric SAP Solutions - Simplement

Hi Surendra,

We had previously spoken to the LAM Research team about using Azure SQL Database Mirroring into Fabric (https://learn.microsoft.com/en-us/fabric/database/mirrored-database/azure-sql-database). This should work based on existing capabilities.

Also, given one of your critical sources is the SAP HANA database the method for HVR to write to Azure SQL Database, followed by mirroring into Fabric, would work out of the box.

On the other hand, open mirroring into Fabric would not work since changes require full row images (https://learn.microsoft.com/en-us/fabric/database/mirrored-database/azure-sql-database). SAP HANA is incredibly sparse in its log records and there is no way for us to use log-based change data capture, and retrieve the full row image (for updates and for deletes that is; inserts do get the full row image). So even if we built support for open mirroring into Fabric it would not work for an SAP HANA database source.

Please do let me know if you have this requirement for non-SAP HANA sources.

Thanks,
Mark.