Oracle Mirroring to Fabric: 2-Wk Proof of Concept
CloudGate LLC
Oracle Mirroring to Fabric: 2-Wk Proof of Concept proves, on your own Oracle data, that Microsoft Fabric Mirroring can replicate your tables into OneLake in near real time, without ETL pipelines or a separate change data capture (CDC) product.
Everything is deployed in your environment: your Oracle database, your on-premises data gateway and your Fabric tenant. CloudGate hosts nothing and keeps no copy of your data. At the end of the two weeks you own a working mirror, the evidence to decide on production, and a plan to get there.
Who should be involved: Head of Data or Analytics, Oracle DBA, data engineers, network and security leads, and a business owner for the Power BI use case.
Week 1 – Prepare and mirror
- Kickoff: confirm scope (one Oracle database, up to 50 agreed tables), success criteria and a reporting use case
- Readiness check: Oracle version and hosting, Data Guard topology, data types, table keys and redo volume
- Prepare the Oracle database with your DBA: archive log mode, supplemental logging and a least-privilege sync user
- Install and register the on-premises data gateway; configure network and security
- Create the mirrored Oracle database in Fabric and complete the initial snapshot
Week 2 – Validate and plan
- Validate row counts, replication latency and schema change behaviour against the success criteria
- Measure the effect on the source database and on Fabric capacity
- Build a staging lakehouse and one Power BI report on the mirrored data
- Capacity sizing, cost model and production rollout plan
- Results readout with stakeholders
Deliverables
- Working Oracle mirror in your Fabric tenant for the agreed tables
- PoC results report: latency, source impact, capacity usage and any unsupported objects
- Target architecture and production rollout plan
- Fabric capacity sizing and cost model
- Configuration and handover documentation
Prerequisites: A non-production Oracle database (version 10 or later with LogMiner), DBA access, a Fabric workspace on a trial or paid capacity, a Windows server for the gateway, and network access from the gateway to Oracle and Fabric.
Pricing: USD 10,000 fixed price for the scope above.
Not included: Fabric, Oracle or Azure licenses and consumption, production rollout, mirroring beyond the agreed tables, and GoldenGate implementation.
Delivered remotely by CloudGate engineers working in your environment.