Forum Discussion
pmscorca
Post Prodigy
1 year agoUsing the Mirroring feature in a data warehouse project
Hi, I need to design a data warehouse to feed with data coming from some database sources. Could be a good thing using the Mirroring feature at bronze layer instead of implementing a lakehouse in o...
- 1 year ago
Yes, Mirroring is a great accelerator for bronze if you want that layer to be raw, untransformed data from your source environment. I've used mirroring in a medallion architecture with good success. At that point it's Delta tables sitting in your OneLake, which can be consumed for processes to move your data into silver.
pmscorca
Post Prodigy
1 year agoHi, thanks for your reply.
It seems that Mirroring supports only some data sources. Could I use Mirroring for an Oracle or MySQL source? Open mirroring?
Thanks
DataBard
Most Valuable Professional
1 year agoIn current state, you'd have to use Open Mirroring for Oracle or MySQL.