Omnata's Dynamics 365 Synapse Link Plugin directly ingests from the Dynamics family of apps to Snowflake using Microsoft's own Synapse Link mechanism — running as a Native App inside your Snowflake account, with no external infrastructure and no data handled by Omnata.

How it works

Microsoft Synapse Link for Dataverse continuously replicates your Dynamics 365 tables to Azure Data Lake Storage Gen2 in Common Data Model (CDM) format. That's Microsoft handling the export from their side.

Omnata picks up from there. The plugin reads directly from that Azure Data Lake, automatically detects the CDM schema, maps field types to Snowflake-native types, identifies composite primary keys, and loads data incrementally — only fetching what's changed since the last sync. The result is Snowflake tables that mirror your Dynamics 365 data, kept current on a schedule you control.

This two-step approach — Synapse Link first, then Omnata — is the recommended architecture from Microsoft for a reason: reading from the Data Lake avoids placing any load on the Dynamics 365 APIs directly. Tools that hit the Dynamics APIs for replication risk contention with your live system. Synapse Link decouples the export from the source, so your Dynamics environment isn't affected by sync schedules or query volume.

Omnata Sync is the simplest way to get Dynamics 365 data into Snowflake

Save yourself from wiring up Azure Data Factory jobs, or setting up extra infrastructure in Snowflake. You configure everything through Omnata's Native UI. No SQL, no custom pipeline code. Plus, the native architecture saves you from another security review and another data processing agreement.

• Truly native — runs inside your Snowflake account, no external infrastructure to manage

• No data leaves your environment — Omnata never handles your data; it connects directly from within the account boundary

• Flat fee, unlimited records — no per-row pricing; sync as much as you need without watching the meter

• Automatic sync strategies — Incremental fetch with merge or append mode, and deduplication

• Automatic schema handling — CDM field types mapped to Snowflake-native types, composite primary keys identified, incremental loads managed for you

Get started now

Just install the Omnata Sync Engine (free listing) and Dynamics Synapse Link Plugin for a 30-day free trial.

All Omnata connectors charge a flat fee for unlimited records, and you can pay using Snowflake Credits (if in an eligible region).

Documentation