Never ETL again, thanks to Synapse Link. Really?
summary
Synapse Link claims a near-real-time push of selected OLTP tables into Azure Synapse by using a self-hosted integration runtime and landing data into ADLS Gen2 then a dedicated SQL pool (not serverless). It skips CDC/replication and uses a new change-detection algorithm, but has many limits: no text/XML/UDT columns, no replication/CDC on source, no ALTER/ADD/DROP or truncate, and large updates re-initialize destination (AdventureWorks person ~20k rows showed instant reload and temporary emptiness). Demo partly fails; service itself has indirect cost via Synapse compute.
AI-written summary · about
chapters (8)
- 0:00Introduction
- 1:05Synapse Link for SQL Server
- 3:54Restrictions and limitations
- 6:03Pre-demo setup
- 9:13Synapse Link connections
- 12:35Demo attempt and troubleshooting
- 17:29Data update behavior and costs
- 18:53Q&A
related talks
19mNever ETL again, thanks to Synapse Link. Really?
45mWhat's New and Cool in Azure Synapse Analytics
21mAzure Synapse Link for Dataverse Implementation
51mSupercharge Power BI with Azure Synapse Analytics
54mAn introduction to Azure Synapse Analytics!
21mA low cost serveless synapse data platform
49mAzure Synapse Analytics
50mWhen and how to migrate to Azure Synapse?