Mirroring from an Oracle on-premise source in Fabric

[pmscorca]

Hi,

I'd like to know if it is possible to use the Fabric mirroring feature for an Oracle on-premise source: reading the official documentation it seems that it isn't possible.

Otherwise, which requirements does the Oracle source have to meet? F.e. does the Oracle Change Data Capture feature need to be enabled?

Many thanks

[V-yubandi-msft]

Hi @pmscorca ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[pmscorca]

Hi,

I think it is important to have a native mirroring feature for an Oracle on-premise source, without using the open mirroring.

Consider to vote this idea Add on-premise Oracle for Fabric mirroring - Microsoft Fabric Community

Thanks

[V-yubandi-msft · Accepted solution]

Hi @pmscorca ,

Thank you for being a part of the Microsoft Fabric Community.  Special thanks to @suparnababu8 , for sharing an accurate and helpful explanation.

You're correct Microsoft Fabric currently does not support native mirroring for on premises Oracle databases. However, as @suparnababu8  mentioned, you can work around this limitation using the Open Mirroring partner ecosystem, specifically with Oracle GoldenGate 23ai, which enables change data capture without relying on Oracle native CDC.

FYI:

Currently, the following external databases are available

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.

[suparnababu8]

Hi @pmscorca 

yes you are correct, Fabric doesn;t support natively for mirring the on-premises Oracle databases. But theres is a possiblity, you can achive this by using open mirring partner eco ssystem which was Oracle GoldenGate. Oracle change data capture not required, as  GoldenGate method handles the data chnages.

If you haven;t gone thorugh this, pls read this articles, it might helps you

Accelerate AI on Oracle Databases with Open Mirroring, Fabric Data Agent, and Azure AI Foundry | Mic...

Open Mirroring Partner Ecosystem - Microsoft Fabric | Microsoft Learn

Thank you!

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!