Unlocking New Potential in Fabric Mirroring Through Open Mirroring A Live Demo of Salesforce Mirroring with CData Sync

This video explains the content of this slide.
https://youtu.be/1oNksjE9ceU?si=FDDGvL6jVcx8cmME
（This video has been translated from Japanese audio using AI. Some parts of the audio may sound a bit strange, so please refer to the text on the slides when that happens.）

# Target Audience
・Those who want to mirror SaaS or external services in Fabric that are not supported by native mirroring
・Those who want to mirror Salesforce in Fabric

# Table of Contents
・Overview of Fabric Mirroring
　・What is Fabric Mirroring? ~Introducing the benefits~
　・Why do we mirror? ~Four common requirements~
　・Steps 4 leveraging mirrored data ~Mirroring is only the starting point~
　・Types of Mirroring ~Depending on whether the data source is officially supported or not~
・Utilizing Open Mirroring
　・Open Mirroring and partner solutions ~CData Sync is highly recommended!~
　・Trying Open Mirroring with CData Sync!
　・Salesforce Mirroring
　　・Prerequisites
　　・Setup procedure overview
　　・Architecture and mirroring time results
　　・Initial mirroring (1,000 records): approx. 6 minutes
　　・UPDATE (1 record): approx. 6 minutes
　　・INSERT (1 record): approx. 3 minutes
　　・Scheduling with CData Sync
　　・Key benefits, points of caution, and challenges
・Summary
・References

👉 Related Qiita Articles:
・Complete Guide to Fabric Mirroring: From Basics to Open Mirroring, Costs, and Use Cases
　　https://qiita.com/ReijiOtake/items/578ecd9a2e4b97792339
・How to Mirror Salesforce in Fabric: Achieve Near Real-Time Integration with Open Mirroring and CData Sync
　　https://qiita.com/ReijiOtake/items/e5b4cf4aae550dddd8d2
・How to Mirror Kintone in Fabric: Achieve Near Real-Time Integration with Open Mirroring and CData Sync
　　https://qiita.com/ReijiOtake/items/26c8a1b2b2e193cd091a

Transcript

1. Microsoft Data Analytics Day (Online) 2025.10.06. Reiji Otake Unlocking New Potential in Fabric Mirroring Through Open Mirroring A Live Demo of Salesforce Mirroring with CData Sync
2. Overview of Fabric Mirroring
3. Overview of Fabric Mirroring ~Highlight the benefits~ Near real-time data replication is possible. The latest data from external system can be brought into Fabric. Avoiding complex ETL process. Integration is simple — just a few clicks to get started. Both of mirroring and mirroring storage are free of charge. Example：if you have F64 capacity, you get 64 TB for free The source database is not affected by analytical workloads. The replicated data on OneLake can be fully utilized for analytics in Fabric. Direct Lake mode is supported. Power BI can access the replicated data quickly and efficiently. With the mirroring feature, data can be replicated without ETL, Enabling near real-time analysis on Fabric.
4. Migration Temporary use doing system migration Integration Bring siloed data together in OneLake Analysis Use AI and BI in Fabric without putting any load on the source systems Share Share data that used to be isolated within a specific department through OneLake Why do we use mirroring？~Classifying common requirements into four groups~
5. Step for Utilizing Mirrored Data ~Mirroring is just the starting point~ Lv.1 Using it as is（querying from SQL endpoint） Preview the mirrored table or analyze it directly with SQL. Lv.2 Create a Power BI report Create asemantic model from the mirrored table, then build a report. If your mirrored table is at the Gold level, this approach is recommended. Lv.3 Utilizing shortcuts to the fullest Shortcut the mirrored table from LH. This step is essential for performing Level 4 and subsequent actions. Lv.4 ETL Perform ETL on the shortcut table using Fabric ETL items, just like a regular table. If your mirrored table is at the Bronze or Silver level, this approach helps promote it to Silver or Gold. Lv.5 Reverse ETL Rewrite the data processed by Fabric ETL items back to source systems using pipelines.
6. Open Mirroring allows you to mirror data sources that Fabric does not officially support. Fabric treats it as one consolidated item. Using partner solutions is common practice. Mirroring Types ~Does the data source have official support?~ Native Mirroring Database Mirroring・Metadata Mirroring Open Mirroring You can mirror the 9 data sources that officially supported by Fabric.
7. Open Mirroring Demo
8. Data Sync | Start Your ETL/ELT Pipeline Without Writing Code It’s easy to set up using the GUI You don’t need to write any code; just by clicking through the interface, you can complete the connection to mirroring. Comprehensive support is available Wide range of connectors Supports hundreds of SaaS applications and databases, including on-premises systems. Open Mirroring requires the use of partner solutions Open Mirroring and Partner Solutions ~CData Sync is the recommend solution!~
9. I tried Open Mirroring using CData Sync! And other.. KintoneをFabricにミラーリングする方法~Open Mirroringと CData Syncの活用でニアリアルタイムでの連携が可能~ #kintone - Qiita SalesforceをFabricにミラーリングする方法~Open Mirroringと CData Syncの活用でニアリアルタイムでの連携が可能 #fabric - Qiita IBM Db2をFabricにミラーリングする方法~Open Mirroringと CData Syncの活用でニアリアルタイムでの連携が可能~ #ibmcloud - Qiita
10. Salesforce Mirroring ~Prerequisites~ You will need the following Fabric Capacity Trial capacity also OK This time use F64 Salesforce（Sales Cloud） This time use Trailhead CData Sync Both on-premise and cloud versions are available. Trial version also available Trial period： On-premise ver：30 days Cloud ver ：14 days Start building data pipelines today with a free CData Sync trial.CData Sync: No-code ETL/ELT pipelines made easy.
11. Create a Mirrored Database Establish Connection with the Mirrored Database Establish Connection with the Salesforce Create a Job Check the Mirroring Results Summary of Configuration Steps Image：Screen of the Connection Created by CData Sync Image：Screen of the Create a Job by CData Sync Salesforce Mirroring ~Summary of Configuration Steps~
12. Account Table Salesforce Mirroring ~Configuration Diagram and Mirroring Process Time Results~ Reflection Time (Until Table Conversion) First Mirroring(1000 records) About 5m 51s UPDATE(1 record) About 5m 54s INSERT(1 record) About 3m 07s Create Connection Run Job Mirroring Mirroring Process Time Results Create Connection
13. Salesforce ミラーリング ~初回ミラーリング(1000レコード)：約6分~
14. Salesforce ミラーリング ~UPDATE(1レコード) ：約6分~
15. Salesforce ミラーリング ~INSERT(1レコード) ：約3分~
16. Salesforce ミラーリング ~CData Syncによるスケジュール設定~
17. Strengths • Near real-time integration is possible with simple configuration. • CData Sync is easy to set up! • Default configurations is enough.（Incremental check columns、Parquet file deletion logic, primary keys, schema changes, etc…） • There is some flexibility for customization.（scheduling, modifying column names and types using SQL, mapping, parallel execution, notification settings etc…） • References：Summary of CData Sync Job Setting –Configuration Options for Use Fabric Open Mirroring- Issues and Concerns • The reflection to the landing zone is immediate, but converting Paquet files into tables takes some time. • The mirroring process probably depends on spec of FSKU. • The status of the mirroring process cannot be monitored through the Metric apps. • We hope that the GUI will allow us to view more detailed execution status. • Currently, it is necessary to create a real-time dashboard on your own • References movie：Getting Started with Workspace Monitoring: Monitoring RTI, Semantic Models, and Mirroring • When you run SQL against mirrored tables, CU consumptions occurs based on the analytical processing, which naturally results in additional costs. Salesforce Mirroring ~Impressions~
18. Summary
19. Fabric Open Mirroring + CData Sync Bring your desired data together in Fabric in near-real time, without the need to develop complex systems. High-cost performance Low cost for both implementation and operation, yet flexible for expansion. Near-real time Refract the latest source data in Fabric within a few minutes. Potential ∞ With CData Sync’s wide variety connectors, you can mirror virtually any system. Just a few click No complex configuration required, all through a GUI. Say goodbye to data silos with Open Mirroring! Even SaaS and external services that native mirroring couldn’t handle can now be seamlessly integrated into Fabric
20. References ▼ What is Mirroring What is Mirroring in Fabric? Microsoft Fabric pricing| Microsoft Azure ▼ What is Open Mirroring Open mirroring in Microsoft Fabric Open mirroring landing zone requirements and format Frequently asked questions for open mirroring in Microsoft Fabric Open mirroring partner ecosystem ▼CData CData Sync Expands MS Fabric Support with Open Mirroring CData Sync strengthens integration with Microsoft Fabric, now supporting replication to OneLake and Open Mirroring