{"id":46240,"date":"2022-09-22T08:00:00","date_gmt":"2022-09-22T15:00:00","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?p=46240"},"modified":"2024-04-19T10:27:56","modified_gmt":"2024-04-19T17:27:56","slug":"azure-synapse-link-for-sql","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/09\/22\/azure-synapse-link-for-sql\/","title":{"rendered":"Azure Synapse Link for SQL"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\" id=\"near-real-time-analytics-for-transactional-workloads\">Near-real-time analytics for transactional workloads<\/h2>\n\n\n\n<p><em>Part of the&nbsp;<a href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/tag\/sql-server-2022-blogging-series\" target=\"_blank\" rel=\"noreferrer noopener\">SQL Server 2022 blog series<\/a><\/em>.<\/p>\n\n\n\n<p>Traditionally, data to serve analytical systems have been extracted from operational data stores using custom-built extract, transform, and load (ETL) processes.&nbsp;These processes are often long-running, exert pressure on the source systems, and only run periodically in batch mode.&nbsp;While this kind of latency and overhead may be acceptable for some workloads, more and more companies are finding themselves in a place where they need to do analytics over operational data closer to real-time\u2014something that traditional ETL systems cannot support.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"enter-azure-synapse-link-for-sql\">Enter Azure Synapse Link for SQL.<\/h3>\n\n\n\n<p><a href=\"https:\/\/aka.ms\/sl4sgettingstarted\">Azure Synapse Link for SQL<\/a> provides an automated way to extract data from source operational systems without having to build custom ETL processes.&nbsp;Some of the benefits of Azure Synapse Link for SQL are:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Low code\/no code solution: With Azure Synapse Link for SQL, you don\u2019t need to build custom processes to extract the data and load it into an analytical system.&nbsp;You choose the tables that you want to replicate, specify how you want them stored in the target Azure Synapse Analytics dedicated SQL pool, and Azure Synapse Link for SQL takes care of the rest.<\/li>\n\n\n\n<li>Minimal impact on the source systems: We have strived to minimize the impact of data extraction from the source system.&nbsp;Where a traditional ETL process will run queries against the source tables, which can get expensive, Azure Synapse Link for SQL uses the new change feed functionality built into <a href=\"https:\/\/aka.ms\/getsqlserver2022\">SQL Server 2022<\/a> and Azure SQL Database to get the data without having to run custom queries.<\/li>\n\n\n\n<li>Near-real-time data movement: Data is continually moved from the source systems into the Azure Synapse Analytics environment.&nbsp;Optionally, you can switch to \u201cscheduled mode\u201d if you don\u2019t need near-real-time data movement.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"how-does-it-work\">How does it work?<\/h3>\n\n\n\n<p>Azure Synapse Link for SQL is powered by the new change feed functionality that has been added to SQL Server 2022 and Azure SQL Database.&nbsp;This functionality allows us to monitor tables for changes as they happen without the additional overhead that is brought along by a change data capture (CDC)\u2013based data movement solution.<\/p>\n\n\n\n<p>When a transaction is committed on a table that is being replicated by Azure Synapse Link for SQL, that transaction is written into a \u201clanding zone,\u201d which is a Gen2 Azure Data Lake storage (ADLS) account.&nbsp;From there, an ingestion service picks up the data and loads it into an Azure Synapse Analytics dedicated SQL pool.&nbsp;Once the data lands there, you can query the data like any other dedicated SQL pool.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"who-will-benefit\">Who will benefit?<\/h3>\n\n\n\n<p>Here are some examples of scenarios that would benefit from Azure Synapse Link for SQL:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Database consolidation: Azure Synapse Link for SQL allows you to bring data from multiple source databases together into a single dedicated SQL pool for analytics.&nbsp;Whether you have multiple tenant databases that you want to use for market-based analytics, or you have grown by acquisition and have multiple source systems to bring together for analytics, Azure Synapse Link for SQL can bring all of that data together into a unified analytical platform.<\/li>\n\n\n\n<li>Hybrid on-premises\/cloud: Since Azure Synapse Link for SQL supports both Azure SQL Database and SQL Server 2022, you can bring data into a common analytical system from wherever it lives.<\/li>\n\n\n\n<li>Near-real-time extension: If you have an ETL system that meets most of your needs but have a few tables where you want data to arrive closer to real-time, you could use Azure Synapse Link for SQL to transfer those tables from the source systems into the Azure Synapse Analytics dedicated SQL pool alongside the data that is processed in your nightly ETL system, and perform reporting an analytics tasks over all of the data.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"how-to-learn-more\">How to learn more<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Read our <a href=\"https:\/\/aka.ms\/slinkforsql\" target=\"_blank\" rel=\"noreferrer noopener\">technical blog post<\/a> from the public preview launch.<\/li>\n\n\n\n<li>Check out our &#8220;<a href=\"https:\/\/aka.ms\/sl4sgettingstarted\" target=\"_blank\" rel=\"noreferrer noopener\">getting started<\/a>&#8221; documentation.<\/li>\n\n\n\n<li>Dig in with our How-To guides:\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/synapse-analytics\/synapse-link\/connect-synapse-link-sql-server-2022\" target=\"_blank\" rel=\"noreferrer noopener\">SQL Server 2022<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/synapse-analytics\/synapse-link\/connect-synapse-link-sql-database\" target=\"_blank\" rel=\"noreferrer noopener\">Azure SQL Database<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Azure Synapse Link for SQL provides an automated way to extract data from source operational systems without having to build custom ETL processes.<\/p>\n","protected":false},"author":6194,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","footnotes":""},"post_tag":[5278],"product":[5226,2388,5227,3645],"content-type":[2424],"topic":[],"coauthors":[5134],"class_list":["post-46240","post","type-post","status-publish","format-standard","hentry","tag-sql-server-2022-blogging-series","product-azure","product-azure-synapse-analytics","product-sql","product-sql-server-2022","content-type-best-practices","review-flag-1593580427-503","review-flag-new-1593580247-437","review-flag-publi-1593580761-761"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.7 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Azure Synapse Link for SQL - Microsoft SQL Server Blog<\/title>\n<meta name=\"description\" content=\"Azure Synapse Link for SQL provides an automated way to extract data from source operational systems without having to build custom ETL processes.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/09\/22\/azure-synapse-link-for-sql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Azure Synapse Link for SQL - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"Azure Synapse Link for SQL provides an automated way to extract data from source operational systems without having to build custom ETL processes.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/09\/22\/azure-synapse-link-for-sql\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft SQL Server Blog\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/sqlserver\" \/>\n<meta property=\"article:published_time\" content=\"2022-09-22T15:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-19T17:27:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/08\/cropped-microsoft_logo_element.png\" \/>\n\t<meta property=\"og:image:width\" content=\"512\" \/>\n\t<meta property=\"og:image:height\" content=\"512\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Chuck Heinzelman\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:site\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Chuck Heinzelman\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 min read\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/09\/22\/azure-synapse-link-for-sql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/09\/22\/azure-synapse-link-for-sql\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/chuck-heinzelman\/\",\"@type\":\"Person\",\"@name\":\"Chuck Heinzelman\"}],\"headline\":\"Azure Synapse Link for SQL\",\"datePublished\":\"2022-09-22T15:00:00+00:00\",\"dateModified\":\"2024-04-19T17:27:56+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/09\/22\/azure-synapse-link-for-sql\/\"},\"wordCount\":666,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"keywords\":[\"SQL Server 2022 Blogging Series\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/09\/22\/azure-synapse-link-for-sql\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/09\/22\/azure-synapse-link-for-sql\/\",\"name\":\"Azure Synapse Link for SQL - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\"},\"datePublished\":\"2022-09-22T15:00:00+00:00\",\"dateModified\":\"2024-04-19T17:27:56+00:00\",\"description\":\"Azure Synapse Link for SQL provides an automated way to extract data from source operational systems without having to build custom ETL processes.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/09\/22\/azure-synapse-link-for-sql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/09\/22\/azure-synapse-link-for-sql\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/09\/22\/azure-synapse-link-for-sql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Azure Synapse Link for SQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"name\":\"Microsoft SQL Server Blog\",\"description\":\"Official News from Microsoft\u2019s Information Platform\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\",\"name\":\"Microsoft SQL Server Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"width\":259,\"height\":194,\"caption\":\"Microsoft SQL Server Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"http:\/\/www.facebook.com\/sqlserver\",\"https:\/\/x.com\/SQLServer\",\"https:\/\/www.youtube.com\/user\/MSCloudOS\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Azure Synapse Link for SQL - Microsoft SQL Server Blog","description":"Azure Synapse Link for SQL provides an automated way to extract data from source operational systems without having to build custom ETL processes.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/09\/22\/azure-synapse-link-for-sql\/","og_locale":"en_US","og_type":"article","og_title":"Azure Synapse Link for SQL - Microsoft SQL Server Blog","og_description":"Azure Synapse Link for SQL provides an automated way to extract data from source operational systems without having to build custom ETL processes.","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/09\/22\/azure-synapse-link-for-sql\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2022-09-22T15:00:00+00:00","article_modified_time":"2024-04-19T17:27:56+00:00","og_image":[{"width":512,"height":512,"url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/08\/cropped-microsoft_logo_element.png","type":"image\/png"}],"author":"Chuck Heinzelman","twitter_card":"summary_large_image","twitter_creator":"@SQLServer","twitter_site":"@SQLServer","twitter_misc":{"Written by":"Chuck Heinzelman","Est. reading time":"3 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/09\/22\/azure-synapse-link-for-sql\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/09\/22\/azure-synapse-link-for-sql\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/chuck-heinzelman\/","@type":"Person","@name":"Chuck Heinzelman"}],"headline":"Azure Synapse Link for SQL","datePublished":"2022-09-22T15:00:00+00:00","dateModified":"2024-04-19T17:27:56+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/09\/22\/azure-synapse-link-for-sql\/"},"wordCount":666,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"keywords":["SQL Server 2022 Blogging Series"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/09\/22\/azure-synapse-link-for-sql\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/09\/22\/azure-synapse-link-for-sql\/","name":"Azure Synapse Link for SQL - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website"},"datePublished":"2022-09-22T15:00:00+00:00","dateModified":"2024-04-19T17:27:56+00:00","description":"Azure Synapse Link for SQL provides an automated way to extract data from source operational systems without having to build custom ETL processes.","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/09\/22\/azure-synapse-link-for-sql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/09\/22\/azure-synapse-link-for-sql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/09\/22\/azure-synapse-link-for-sql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"Azure Synapse Link for SQL"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","name":"Microsoft SQL Server Blog","description":"Official News from Microsoft\u2019s Information Platform","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization","name":"Microsoft SQL Server Blog","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","width":259,"height":194,"caption":"Microsoft SQL Server Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/"},"sameAs":["http:\/\/www.facebook.com\/sqlserver","https:\/\/x.com\/SQLServer","https:\/\/www.youtube.com\/user\/MSCloudOS"]}]}},"msxcm_display_generated_audio":false,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/46240","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/users\/6194"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/comments?post=46240"}],"version-history":[{"count":1,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/46240\/revisions"}],"predecessor-version":[{"id":50427,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/46240\/revisions\/50427"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=46240"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=46240"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=46240"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=46240"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=46240"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=46240"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}