What is Data Mission Sync?
Data Mission Sync is a cloud-based service that automatically synchronizes your Microsoft Dataverse data to your own Azure SQL database. It gives you full control over your business data for reporting, analytics, and integration — without building custom APIs or managing complex data pipelines.
With Data Mission Sync, your data flows from Dataverse to Azure SQL on a schedule you control. After an initial full load, only changed records are synchronized, keeping your target database current with minimal overhead.
Key Benefits
| Benefit | Description |
| Turn Your Data Into Insights | Access your Dataverse data in Azure SQL where you can connect Power BI, Excel, or any analytics tool. Run complex queries and build reports without impacting your production Dataverse environment. |
| Integrate and Automate With Ease | Azure SQL works with virtually any tool or platform. Connect to data warehouses, trigger workflows, or feed downstream systems — all from your synchronized data. |
| Keep Control and Stay Compliant | Your data stays in your Azure SQL database. You decide where it lives, how it's backed up, and who can access it — ensuring compliance and continuity at every step. |
| Simple Setup, No Coding Required | Configure your sync in minutes using our guided wizard. No APIs to build, no ETL pipelines to maintain, no specialized skills required. |
Key Features
| Feature | Description |
| Incremental Synchronization | After the initial full load, only changed records are synchronized. This keeps your data current while minimizing processing time and resource usage. |
| Delete Tracking | Choose how deleted records are handled: Soft Delete marks records as deleted while preserving them for audit trails, or Hard Delete removes them permanently to mirror your source exactly. |
| Automatic Schema Evolution | When your organization extends Dataverse tables with new columns, Data Mission Sync automatically detects and applies those schema changes to your Azure SQL target. Your synchronized tables always reflect your current Dataverse structure. |
| Flexible Scheduling | Syncs run automatically on a regular schedule. Configure quiet time windows to pause synchronization during maintenance or peak usage periods. |
| Real-Time Monitoring | Track sync status, view run history, monitor row counts, and receive email notifications for failures — all from the control plane dashboard. |
| Multi-Region Support | Choose from five Azure regions (Canada, US East, US West, UK, Europe) to process your data close to your database and meet compliance requirements. |
Who Is Data Mission Sync For?
Data Mission Sync is designed for organizations using Microsoft Dynamics 365, Power Platform, or any Dataverse-based application who need reliable access to their data outside of those platforms.
Common use cases include:
| Use Case | Example |
| Business Intelligence | Connect Power BI directly to Azure SQL for faster, more complex reporting than Dataverse connectors allow. |
| Data Warehousing | Feed your data warehouse or lakehouse with clean, structured Dataverse data. |
| System Integration | Use Azure SQL as a hub to connect Dataverse data with other business systems. |
| Backup & Compliance | Maintain an independent copy of your data in a location and format you control. |
| Development & Testing | Work with production-like data in isolated environments without affecting live systems. |
Simple, No-Brainer Pricing
Data Mission Sync follows a straightforward pricing model with no hidden costs or usage limits:
| Plan | Details |
| First Environment | $60 USD per month. Includes one Dataverse environment, full feature access, automatic updates, and support. |
| Additional Environments | $30 USD per month each. Add as many as you need — no contracts, cancel anytime. |
| Free Trial | No credit card required. Full access to all features during the trial period. |