Forum Discussion

andrewsommer's avatar
andrewsommer
Super User
1 year ago
Solved

Oracle Mirroring

Has anyone had success with mirroring an on-prem oracle db?  We are thinking the best path forward is to wait for Microsoft to release an official connector but wanted to see if anyone else had anyth...
data hub
one lake
  • NandanHegde's avatar
    NandanHegde
    1 year ago

    Based on my understanding, there is no direct mirroring functionality in fabric. You can have a copy data pipeline to sync data from oracle database to fabric via a meta data driven framework

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi andrewsommer ,

Thank you for reaching out to the Microsoft Fabric Community.

 

"You’re on the right track with the metadata-driven pipeline, as Fabric does not yet have a native Oracle mirroring connector. As NandanHegde  correctly pointed out that a Copy Data pipeline is the best approach for now. However, Microsoft’s Open Mirroring feature is evolving, and while an official Oracle connector hasn’t been announced, Oracle GoldenGate 23ai currently integrates with Fabric for real-time mirroring. Since you prefer not to use GoldenGate, your best option is to continue with the pipeline approach while monitoring Microsoft's updates for future Oracle mirroring support. Additionally, alternative solutions like Striim’s SQL2Fabric-Mirroring might be worth exploring."

I also recommend adding your feature requests or ideas to Microsoft using the following link, so they can consider implementing them in the future.

Fabric Ideas - Microsoft Fabric Community

 

I hope my suggestions give you good idea, if you need any further assistance, feel free to reach out.

If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.

 

Thank you.