SQLBits 2023

Never ETL again, thanks to Synapse Link. Really?

Let's take a look at Synapse Link - it's capabilities and restrictions! Synapse Link is Microsoft's new solution to push your OLTP data in near-real time to Azure Synapse for analytical purposes.

Thanks to a feature called Synapse Link, Microsoft now allows you to push your OLTP data, for example from an on-prem SQL Server, in near-real time to Azure Synapse for analytical purposes.

No more pipelines, SSIS Packages etc. - all out of the box.

Sounds too good to be true? Let's explore the capabilities and restrictions of this feature to see, if it can take all your ETL away just yet.

Speaker

Ben has been working with SQL Server since SQL Server 6.5, mainly in the BI/Datawarehousing field. He is a Data Platform MVP, MCSE, MPP and a BimlHero Certified Expert. He is also a regular speaker at international events and an author.