{"id":40170,"date":"2021-03-30T00:05:29","date_gmt":"2021-03-30T07:05:29","guid":{"rendered":"https:\/\/devblogs.microsoft.com\/premier-developer\/?p=40170"},"modified":"2021-03-24T06:13:34","modified_gmt":"2021-03-24T13:13:34","slug":"integration-with-on-premises-data-sources-in-azure-synapse-analytics","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/premier-developer\/integration-with-on-premises-data-sources-in-azure-synapse-analytics\/","title":{"rendered":"Integration with On-Premises Data Sources in Azure Synapse Analytics"},"content":{"rendered":"<p><a href=\"https:\/\/www.linkedin.com\/in\/orrin\/\" target=\"_blank\" rel=\"noopener\">Orrin Edenfield<\/a> explores the integration of on-premises data sources in Azure Synapse Analytics.<\/p>\n<hr \/>\n<p>Today many organizations are cloud hybrid in nature so they need to read from and write to on-premises data stores including file systems and relational databases. In this video I show you how to connect to on-premises file systems and relational databases (like\u00a0<a href=\"https:\/\/azure.microsoft.com\/en-us\/services\/sql-edge\/\" target=\"_blank\" rel=\"noreferrer noopener\">Azure SQL Database Edge<\/a>) using the Integration Pipelines capabilities of Azure Synapse Analytics and the self-hosted integration runtime.<\/p>\n<p><video controls=\"controls\" width=\"900\" height=\"450\"><source src=\"https:\/\/videos.files.wordpress.com\/YK7IHL2V\/on-premises-data-synapse-analytics_dvd.mp4\" type=\"video\/mp4\" \/><\/video><\/p>\n<p><a class=\"x-hidden-focus\" href=\"https:\/\/howtoanalytics.info\/2021\/02\/17\/integration-with-on-premises-data-sources-in-azure-synapse-analytics\/\" target=\"_blank\" rel=\"noopener\">Check out the full post and additional details on Orrin\u2019s blog.<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Today many organizations are cloud hybrid in nature so they need to read from and write to on-premises data stores including file systems and relational databases. <\/p>\n","protected":false},"author":582,"featured_media":40165,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[25],"tags":[10613,10614],"class_list":["post-40170","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-azure","tag-azure-synapse","tag-orrin-edenfield"],"acf":[],"blog_post_summary":"<p>Today many organizations are cloud hybrid in nature so they need to read from and write to on-premises data stores including file systems and relational databases. <\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/premier-developer\/wp-json\/wp\/v2\/posts\/40170","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/premier-developer\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/premier-developer\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/premier-developer\/wp-json\/wp\/v2\/users\/582"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/premier-developer\/wp-json\/wp\/v2\/comments?post=40170"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/premier-developer\/wp-json\/wp\/v2\/posts\/40170\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/premier-developer\/wp-json\/wp\/v2\/media\/40165"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/premier-developer\/wp-json\/wp\/v2\/media?parent=40170"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/premier-developer\/wp-json\/wp\/v2\/categories?post=40170"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/premier-developer\/wp-json\/wp\/v2\/tags?post=40170"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}