Azure Synapse Analytics
real-time ingestion
TwinCommit applies changes to Azure Synapse Analytics with exactly-once, commit-ordered semantics from any of 9 log-based sources, including Oracle, MySQL, SQL Server and Db2. ADLS-staged COPY INTO plus MERGE for dedicated SQL pools.
Azure Synapse Analytics
Synapse dedicated SQL pools (Gen2) · Microsoft Fabric Data Warehouse
- ✓An ADLS Gen2 staging container
- ✓A service principal or managed identity with db_ddladmin and db_datawriter
- ✓ADMINISTER DATABASE BULK OPERATIONS for COPY INTO
Apply
How TwinCommit writes to Synapse
Micro-batches are staged as Parquet in Azure Data Lake Storage, loaded with COPY INTO and applied with MERGE in one transaction together with the checkpoint. Tables are created hash-distributed on the primary key.
Synapse target docs →Synapse connector FAQ
Which Synapse versions does TwinCommit support?
+
Synapse dedicated SQL pools (Gen2) · Microsoft Fabric Data Warehouse.
How does TwinCommit write to Synapse?
+
Micro-batches are staged as Parquet in Azure Data Lake Storage, loaded with COPY INTO and applied with MERGE in one transaction together with the checkpoint. Tables are created hash-distributed on the primary key.
Replicate your first table in five minutes.
Download the free Developer edition, or have one of our replication engineers walk you through a migration plan.