{"id":20477,"date":"2024-12-20T09:54:19","date_gmt":"2024-12-20T13:54:19","guid":{"rendered":"https:\/\/kevinjustin.com\/blog\/?p=20477"},"modified":"2024-12-20T09:54:19","modified_gmt":"2024-12-20T13:54:19","slug":"data-integration-with-sql2022","status":"publish","type":"post","link":"https:\/\/kevinjustin.com\/blog\/2024\/12\/20\/data-integration-with-sql2022\/","title":{"rendered":"Data Integration with SQL2022"},"content":{"rendered":"
<\/div>\n
\"Integration<\/a>
Integration – time to integrate data sources to data lake<\/figcaption><\/figure>\n

Ready for a single pane of glass?\u00a0 Ready to have your insights in a common location?\u00a0 Let’s discuss Data Integration with SQL2022.<\/p>\n

 <\/p>\n

Let’s start with some background on SQL2022 and similarly SQL2025, start with the learn site link<\/a>.\u00a0 SQL2022 by design is Azure enabled with multiple capabilities like ‘Bi-directional HA\/DR to Azure SQL’ and ‘Azure Synapse Link’.\u00a0 Basically, Synapse link is the key.<\/p>\n

\"SQL2022<\/a>
SQL2022 by design is Azure Enabled<\/figcaption><\/figure>\n

Utilize the PowerBI Cloud Service with today’s hybrid environments.\u00a0 SQL2022 allows integration with other Azure capabilities like Azure Data factory\/data lake, and Azure Synapse.\u00a0 Another reason to upgrade SQL 2022, is design simplification.\u00a0 However, PowerBI data gateway<\/a> adds a potential break point (single point of failure).\u00a0 While PowerBI data gateway centralizes all premise data to a central location.\u00a0 In the same way, consolidating data sent to the cloud.\u00a0 When PowerBI data gateway fails, insights and visualizations have stale data (i.e. data NOT transferred for a near real-time display).<\/p>\n

 <\/p>\n

Why SQL2022 then?<\/p>\n

Connect insights and visualization to justify ‘Data Integration with SQL2022’ scenarios.<\/p>\n

\"SQL2022<\/a>
SQL2022 built in capability to Azure Synapse Analytics<\/figcaption><\/figure>\n

Use SQL2022 to configure SQL agent jobs which pull SQL scripts from your cloud environment.\u00a0 DevOps and common Azure Storage repository are great advantages for speed of execution.<\/p>\n","protected":false},"excerpt":{"rendered":"

Ready for a single pane of glass?\u00a0 Ready to have your insights in a common location?\u00a0 Let’s discuss Data Integration with SQL2022.   Let’s start with some background on SQL2022 and similarly SQL2025, start with the learn site link.\u00a0 SQL2022 by design is Azure enabled with multiple capabilities like ‘Bi-directional HA\/DR to Azure SQL’ and … Continue reading “Data Integration with SQL2022”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2,3,530,556],"tags":[56,924,923,787,624,342,410,922,921],"class_list":["post-20477","post","type-post","status-publish","format-standard","hentry","category-administration","category-azure","category-scom","category-sql","tag-azure","tag-azure-synapse-analytics","tag-managed-instance","tag-mcm","tag-powerbi","tag-scom","tag-sql","tag-sql-mi","tag-sql2022"],"yoast_head":"\nData Integration with SQL2022 - Kevin Justin's Blog<\/title>\n<meta name=\"description\" content=\"Let's discuss data integration with SQL2022, to accelerate moving key insights to your datalake, hybrid, or cloud environments.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/kevinjustin.com\/blog\/2024\/12\/20\/data-integration-with-sql2022\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Data Integration with SQL2022 - Kevin Justin's Blog\" \/>\n<meta property=\"og:description\" content=\"Let's discuss data integration with SQL2022, to accelerate moving key insights to your datalake, hybrid, or cloud environments.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kevinjustin.com\/blog\/2024\/12\/20\/data-integration-with-sql2022\/\" \/>\n<meta property=\"og:site_name\" content=\"Kevin Justin's Blog\" \/>\n<meta property=\"article:published_time\" content=\"2024-12-20T13:54:19+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2024\/12\/Integration.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"469\" \/>\n\t<meta property=\"og:image:height\" content=\"280\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"WordPress Administrator\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"WordPress Administrator\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2024\\\/12\\\/20\\\/data-integration-with-sql2022\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2024\\\/12\\\/20\\\/data-integration-with-sql2022\\\/\"},\"author\":{\"name\":\"WordPress Administrator\",\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/#\\\/schema\\\/person\\\/3d7a90f4430bef43134eaa0a7e2cd508\"},\"headline\":\"Data Integration with SQL2022\",\"datePublished\":\"2024-12-20T13:54:19+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2024\\\/12\\\/20\\\/data-integration-with-sql2022\\\/\"},\"wordCount\":249,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2024\\\/12\\\/20\\\/data-integration-with-sql2022\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/12\\\/Integration-300x179.jpg\",\"keywords\":[\"azure\",\"Azure Synapse Analytics\",\"managed instance\",\"MCM\",\"PowerBI\",\"SCOM\",\"sql\",\"SQL MI\",\"SQL2022\"],\"articleSection\":[\"Administration\",\"Azure\",\"SCOM\",\"SQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2024\\\/12\\\/20\\\/data-integration-with-sql2022\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2024\\\/12\\\/20\\\/data-integration-with-sql2022\\\/\",\"url\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2024\\\/12\\\/20\\\/data-integration-with-sql2022\\\/\",\"name\":\"Data Integration with SQL2022 - Kevin Justin's Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2024\\\/12\\\/20\\\/data-integration-with-sql2022\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2024\\\/12\\\/20\\\/data-integration-with-sql2022\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/12\\\/Integration-300x179.jpg\",\"datePublished\":\"2024-12-20T13:54:19+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/#\\\/schema\\\/person\\\/3d7a90f4430bef43134eaa0a7e2cd508\"},\"description\":\"Let's discuss data integration with SQL2022, to accelerate moving key insights to your datalake, hybrid, or cloud environments.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2024\\\/12\\\/20\\\/data-integration-with-sql2022\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2024\\\/12\\\/20\\\/data-integration-with-sql2022\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2024\\\/12\\\/20\\\/data-integration-with-sql2022\\\/#primaryimage\",\"url\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/12\\\/Integration.jpg\",\"contentUrl\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/12\\\/Integration.jpg\",\"width\":469,\"height\":280,\"caption\":\"Integration - time to integrate data sources to data lake\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/2024\\\/12\\\/20\\\/data-integration-with-sql2022\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Data Integration with SQL2022\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/\",\"name\":\"Kevin Justin's Blog\",\"description\":\"Operational monitoring tools including System Center, Azure Monitor\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/#\\\/schema\\\/person\\\/3d7a90f4430bef43134eaa0a7e2cd508\",\"name\":\"WordPress Administrator\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/fca865cc5df90a25ae9533b1d9dea567a78c7469dc3202a376c8d117a0eaea11?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/fca865cc5df90a25ae9533b1d9dea567a78c7469dc3202a376c8d117a0eaea11?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/fca865cc5df90a25ae9533b1d9dea567a78c7469dc3202a376c8d117a0eaea11?s=96&d=mm&r=g\",\"caption\":\"WordPress Administrator\"},\"sameAs\":[\"https:\\\/\\\/kevinjustin.com\"],\"url\":\"https:\\\/\\\/kevinjustin.com\\\/blog\\\/author\\\/wordpress_admin\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Data Integration with SQL2022 - Kevin Justin's Blog","description":"Let's discuss data integration with SQL2022, to accelerate moving key insights to your datalake, hybrid, or cloud environments.","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:\/\/kevinjustin.com\/blog\/2024\/12\/20\/data-integration-with-sql2022\/","og_locale":"en_US","og_type":"article","og_title":"Data Integration with SQL2022 - Kevin Justin's Blog","og_description":"Let's discuss data integration with SQL2022, to accelerate moving key insights to your datalake, hybrid, or cloud environments.","og_url":"https:\/\/kevinjustin.com\/blog\/2024\/12\/20\/data-integration-with-sql2022\/","og_site_name":"Kevin Justin's Blog","article_published_time":"2024-12-20T13:54:19+00:00","og_image":[{"width":469,"height":280,"url":"https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2024\/12\/Integration.jpg","type":"image\/jpeg"}],"author":"WordPress Administrator","twitter_card":"summary_large_image","twitter_misc":{"Written by":"WordPress Administrator","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/kevinjustin.com\/blog\/2024\/12\/20\/data-integration-with-sql2022\/#article","isPartOf":{"@id":"https:\/\/kevinjustin.com\/blog\/2024\/12\/20\/data-integration-with-sql2022\/"},"author":{"name":"WordPress Administrator","@id":"https:\/\/kevinjustin.com\/blog\/#\/schema\/person\/3d7a90f4430bef43134eaa0a7e2cd508"},"headline":"Data Integration with SQL2022","datePublished":"2024-12-20T13:54:19+00:00","mainEntityOfPage":{"@id":"https:\/\/kevinjustin.com\/blog\/2024\/12\/20\/data-integration-with-sql2022\/"},"wordCount":249,"commentCount":0,"image":{"@id":"https:\/\/kevinjustin.com\/blog\/2024\/12\/20\/data-integration-with-sql2022\/#primaryimage"},"thumbnailUrl":"https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2024\/12\/Integration-300x179.jpg","keywords":["azure","Azure Synapse Analytics","managed instance","MCM","PowerBI","SCOM","sql","SQL MI","SQL2022"],"articleSection":["Administration","Azure","SCOM","SQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/kevinjustin.com\/blog\/2024\/12\/20\/data-integration-with-sql2022\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/kevinjustin.com\/blog\/2024\/12\/20\/data-integration-with-sql2022\/","url":"https:\/\/kevinjustin.com\/blog\/2024\/12\/20\/data-integration-with-sql2022\/","name":"Data Integration with SQL2022 - Kevin Justin's Blog","isPartOf":{"@id":"https:\/\/kevinjustin.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/kevinjustin.com\/blog\/2024\/12\/20\/data-integration-with-sql2022\/#primaryimage"},"image":{"@id":"https:\/\/kevinjustin.com\/blog\/2024\/12\/20\/data-integration-with-sql2022\/#primaryimage"},"thumbnailUrl":"https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2024\/12\/Integration-300x179.jpg","datePublished":"2024-12-20T13:54:19+00:00","author":{"@id":"https:\/\/kevinjustin.com\/blog\/#\/schema\/person\/3d7a90f4430bef43134eaa0a7e2cd508"},"description":"Let's discuss data integration with SQL2022, to accelerate moving key insights to your datalake, hybrid, or cloud environments.","breadcrumb":{"@id":"https:\/\/kevinjustin.com\/blog\/2024\/12\/20\/data-integration-with-sql2022\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kevinjustin.com\/blog\/2024\/12\/20\/data-integration-with-sql2022\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kevinjustin.com\/blog\/2024\/12\/20\/data-integration-with-sql2022\/#primaryimage","url":"https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2024\/12\/Integration.jpg","contentUrl":"https:\/\/kevinjustin.com\/blog\/wp-content\/uploads\/2024\/12\/Integration.jpg","width":469,"height":280,"caption":"Integration - time to integrate data sources to data lake"},{"@type":"BreadcrumbList","@id":"https:\/\/kevinjustin.com\/blog\/2024\/12\/20\/data-integration-with-sql2022\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/kevinjustin.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Data Integration with SQL2022"}]},{"@type":"WebSite","@id":"https:\/\/kevinjustin.com\/blog\/#website","url":"https:\/\/kevinjustin.com\/blog\/","name":"Kevin Justin's Blog","description":"Operational monitoring tools including System Center, Azure Monitor","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/kevinjustin.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/kevinjustin.com\/blog\/#\/schema\/person\/3d7a90f4430bef43134eaa0a7e2cd508","name":"WordPress Administrator","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/fca865cc5df90a25ae9533b1d9dea567a78c7469dc3202a376c8d117a0eaea11?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/fca865cc5df90a25ae9533b1d9dea567a78c7469dc3202a376c8d117a0eaea11?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/fca865cc5df90a25ae9533b1d9dea567a78c7469dc3202a376c8d117a0eaea11?s=96&d=mm&r=g","caption":"WordPress Administrator"},"sameAs":["https:\/\/kevinjustin.com"],"url":"https:\/\/kevinjustin.com\/blog\/author\/wordpress_admin\/"}]}},"_links":{"self":[{"href":"https:\/\/kevinjustin.com\/blog\/wp-json\/wp\/v2\/posts\/20477","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kevinjustin.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kevinjustin.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kevinjustin.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kevinjustin.com\/blog\/wp-json\/wp\/v2\/comments?post=20477"}],"version-history":[{"count":11,"href":"https:\/\/kevinjustin.com\/blog\/wp-json\/wp\/v2\/posts\/20477\/revisions"}],"predecessor-version":[{"id":20491,"href":"https:\/\/kevinjustin.com\/blog\/wp-json\/wp\/v2\/posts\/20477\/revisions\/20491"}],"wp:attachment":[{"href":"https:\/\/kevinjustin.com\/blog\/wp-json\/wp\/v2\/media?parent=20477"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kevinjustin.com\/blog\/wp-json\/wp\/v2\/categories?post=20477"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kevinjustin.com\/blog\/wp-json\/wp\/v2\/tags?post=20477"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}