{"id":1228,"date":"2019-06-11T00:00:00","date_gmt":"2019-06-11T07:00:00","guid":{"rendered":""},"modified":"2025-06-24T07:07:50","modified_gmt":"2025-06-24T14:07:50","slug":"microsoft-fhir-server-for-azure-extends-to-sql","status":"publish","type":"post","link":"https:\/\/azure.microsoft.com\/en-us\/blog\/microsoft-fhir-server-for-azure-extends-to-sql\/","title":{"rendered":"Microsoft FHIR Server for Azure extends to SQL"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\"><em>This blog post was co-authored by Doug Seven, Senior Director, Microsoft Health Engineering and Michael Hansen, Senior Program Manager, Microsoft Health Engineering.<\/em><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Since the launch of the open source <a href=\"https:\/\/github.com\/Microsoft\/fhir-server\" target=\"_blank\" rel=\"noopener\">FHIR Server for Azure<\/a> on GitHub last November, we have been humbled by the tremendously positive response and surge in the use of FHIR in the healthcare community. There has been great interest in Microsoft expanding capabilities in the FHIR service, and <strong>today we are pleased to announce that the open source FHIR Server for Azure now supports both Azure Cosmos DB and SQL backed persistence providers. <\/strong>With the SQL persistence provider, developers will be able to perform complex search queries that join information across multiple FHIR resource types and leverage transactions.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"why-we-are-adding-sql-to-the-fhir-server-for-azure\">Why we are adding SQL to the FHIR Server for Azure<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">The FHIR service relies on a data persistence provider for storing and searching FHIR resources. The initial release of the FHIR service included a data persistence provider based on <a href=\"https:\/\/azure.microsoft.com\/services\/cosmos-db\/\" target=\"_blank\" rel=\"noopener\">Azure Cosmos DB<\/a>, which is a globally distributed, multi-model database for any scale. Azure Cosmos DB is ideal for healthcare scenarios where users need arbitrary scale and low latency. As our developer community continues to expand healthcare applications with FHIR, new use cases and features of the FHIR specification have emerged that are a natural fit for a relational database such as SQL Server. For example, SQL can enable search queries that would correspond to a database join (<a href=\"https:\/\/www.hl7.org\/fhir\/search.html#chaining\" target=\"_blank\" rel=\"noopener\">chained searches<\/a>, <a href=\"https:\/\/www.hl7.org\/fhir\/search.html#include\" target=\"_blank\" rel=\"noopener\">_include<\/a>, <a href=\"https:\/\/www.hl7.org\/fhir\/search.html#include\" target=\"_blank\" rel=\"noopener\">_revinclude<\/a>) and enable atomic transactions where the entire set of changes succeed or fail as a single entity.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Many healthcare organizations are already aware of the benefits of SQL for managing relational data. Combining the power of SQL with data in the native FHIR format provides new options and applications to accelerate the use of FHIR. To get started, the latter half of this blog post gives you an easy to use demonstration on how to deploy the SQL based FHIR service and interact with the API.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"introducing-fhir-r4\">Introducing FHIR R4<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">In December 2018, HL7 announced <a href=\"https:\/\/hl7.org\/fhir\/R4\/\" target=\"_blank\" rel=\"noopener\">FHIR v4.0.0 (aka FHIR R4)<\/a>. This release is significant because a number of the most mature resource definitions became normative, meaning they will be backwards compatible in future releases. We are pleased to announce support for FHIR R4 in the open source FHIR Server for Azure. Available immediately in open source, this enables developers to configure their FHIR server to use the latest iteration of the FHIR specification with trust that the thirteen most commonly used resources, including Patient, Observation, and StructureDefinition, are \u201clocked\u201d and expected to remain consistent in future iterations of the specification.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"getting-started-in-fhir\">Getting started in FHIR<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Starting with FHIR is easy. Both the open source <a href=\"https:\/\/github.com\/Microsoft\/fhir-server\" target=\"_blank\" rel=\"noopener\">FHIR Server for Azure<\/a> and the <a href=\"https:\/\/aka.ms\/fhir\" target=\"_blank\" rel=\"noopener\">Azure API for FHIR<\/a> managed service allow you to provision a FHIR service in just a few minutes. The FHIR Server for Azure repository includes an <a href=\"https:\/\/github.com\/microsoft\/fhir-server\/blob\/master\/samples\/templates\/default-azuredeploy-sql.json\" target=\"_blank\" rel=\"noopener\">Azure Resource Manager template<\/a> for deploying the FHIR server with a SQL persistence provider.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"deployment\">Deployment<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">To deploy this template in Azure use this <a href=\"https:\/\/portal.azure.com\/#create\/Microsoft.Template\/uri\/https%3A%2F%2Fraw.githubusercontent.com%2FMicrosoft%2Ffhir-server%2Fmaster%2Fsamples%2Ftemplates%2Fdefault-azuredeploy-sql.json\" target=\"_blank\" rel=\"noopener\">deployment link<\/a>, which will open a custom template deployment form.<\/p>\n\n\n\n<figure class=\"wp-block-image has-custom-border\"><img decoding=\"async\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/06\/9724a9fa-b033-4b42-96c2-532f3c9bf395.webp\" alt=\"Azure Resource Manager template for deploying the FHIR server wirh a SQL persistence provider\" style=\"border-radius:0px\" title=\"Azure Resource Manager template for deploying the FHIR server wirh a SQL persistence provider\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">At a minimum, you must provide a resource group, service name, and SQL service administrator password. If no security details (authority and audience) are provided, the instance will be provisioned with no security. For details on provisioning with security enabled, see the <a href=\"https:\/\/github.com\/microsoft\/fhir-server\/blob\/master\/docs\/DefaultDeployment.md\" target=\"_blank\" rel=\"noopener\">FHIR Server deployment instructions<\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"testing\">Testing<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">After deployment, use a tool like <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/healthcare-apis\/access-fhir-postman-tutorial\" target=\"_blank\" rel=\"noopener\">Postman<\/a> to test the FHIR service. First check the capability statement from the \/metadata endpoint.<\/p>\n\n\n\n<figure class=\"wp-block-image has-custom-border\"><img decoding=\"async\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/06\/2cf832c3-1864-4694-8119-902a0738d964.webp\" alt=\"Check the capability statement from the \/metadata endpoint in Postman\" style=\"border-radius:0px\" title=\"Postman to test the FHIR service\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Next, insert a patient with a POST to \/Patient.<\/p>\n\n\n\n<figure class=\"wp-block-image has-custom-border\"><img decoding=\"async\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/06\/7fbc86a5-8cbe-4be4-89e8-abebe992024f.webp\" alt=\"Insert a patient with a POST to \/Patient\" style=\"border-radius:0px\" title=\"Inserting a patient in Postman\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Finally, test that you can search patients.<\/p>\n\n\n\n<figure class=\"wp-block-image has-custom-border\"><img decoding=\"async\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/06\/f2eed35e-3823-4d9e-bb81-ec2cda5982e0.webp\" alt=\"Search for patients in Postman\" style=\"border-radius:0px\" title=\"Patient search in Postman\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"fhir-in-your-organization\">FHIR in your organization<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Whether you chose to leverage Azure Cosmos DB or the SQL persistence provider, there are many choices in terms of database schema and indexing. The open source FHIR Server for Azure showcases a design choice that will cover a broad set of use cases and enables you to optimize as needed for your specific use case. We encourage you to explore the source code, deploy the SQL configuration of the server, and provide us with feedback!<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">We\u2019re thrilled to see the industry embracing FHIR! This week our team is at the <a href=\"https:\/\/www.devdays.com\/us\/\" target=\"_blank\" rel=\"noopener\">HL7 FHIR DevDays<\/a>, hosted on the Microsoft campus in Redmond, Washington. If you\u2019re attending DevDays and are interested in learning more about the design consideration, please attend the session entitled \u201c<a href=\"https:\/\/www.devdays.com\/us\/schedule\/#event-235\" target=\"_blank\" rel=\"noopener\">Building a SQL persistence provider for a FHIR server<\/a>\u201d or stop by the Microsoft coding table!<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>FHIR\u00ae is the registered trademark of HL7 and is used with the permission of HL7. <\/em><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Since the launch of the open source FHIR Server for Azure on GitHub last November, we have been humbled by the tremendously positive response and surge in the use of FHIR in the healthcare community.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ms_queue_id":[],"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","_alt_title":"","footnotes":"","msx_community_cta_settings":[]},"categories":[1473,1498,1485,1556,1461],"tags":[],"audience":[3057,3055,3056],"content-type":[],"product":[1499,1567,1538],"tech-community":[],"topic":[],"coauthors":[97],"class_list":["post-1228","post","type-post","status-publish","format-standard","hentry","category-databases","category-integration","category-internet-of-things","category-mobile","category-web","audience-data-professionals","audience-developers","audience-it-implementors","product-api-management","product-azure-api-management","product-azure-cosmos-db","review-flag-1680286581-295","review-flag-lever-1680286579-649","review-flag-new-1680286579-546"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Microsoft FHIR Server for Azure extends to SQL | Microsoft Azure Blog<\/title>\n<meta name=\"description\" content=\"Since the launch of the open source FHIR Server for Azure on GitHub last November, we have been humbled by the tremendously positive response and surge in the use of FHIR in the healthcare community.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/azure.microsoft.com\/en-us\/blog\/microsoft-fhir-server-for-azure-extends-to-sql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Microsoft FHIR Server for Azure extends to SQL | Microsoft Azure Blog\" \/>\n<meta property=\"og:description\" content=\"Since the launch of the open source FHIR Server for Azure on GitHub last November, we have been humbled by the tremendously positive response and surge in the use of FHIR in the healthcare community.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/azure.microsoft.com\/en-us\/blog\/microsoft-fhir-server-for-azure-extends-to-sql\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft Azure Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/microsoftazure\" \/>\n<meta property=\"article:published_time\" content=\"2019-06-11T07:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-24T14:07:50+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/06\/9724a9fa-b033-4b42-96c2-532f3c9bf395.webp\" \/>\n<meta name=\"author\" content=\"Microsoft Azure\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@azure\" \/>\n<meta name=\"twitter:site\" content=\"@azure\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Microsoft Azure\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/microsoft-fhir-server-for-azure-extends-to-sql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/microsoft-fhir-server-for-azure-extends-to-sql\/\"},\"author\":[{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/microsoft-azure\/\",\"@type\":\"Person\",\"@name\":\"Microsoft Azure\"}],\"headline\":\"Microsoft FHIR Server for Azure extends to SQL\",\"datePublished\":\"2019-06-11T07:00:00+00:00\",\"dateModified\":\"2025-06-24T14:07:50+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/microsoft-fhir-server-for-azure-extends-to-sql\/\"},\"wordCount\":759,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/microsoft-fhir-server-for-azure-extends-to-sql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/06\/9724a9fa-b033-4b42-96c2-532f3c9bf395.webp\",\"articleSection\":[\"Databases\",\"Integration\",\"Internet of things\",\"Mobile\",\"Web\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/azure.microsoft.com\/en-us\/blog\/microsoft-fhir-server-for-azure-extends-to-sql\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/microsoft-fhir-server-for-azure-extends-to-sql\/\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/microsoft-fhir-server-for-azure-extends-to-sql\/\",\"name\":\"Microsoft FHIR Server for Azure extends to SQL | Microsoft Azure Blog\",\"isPartOf\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/microsoft-fhir-server-for-azure-extends-to-sql\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/microsoft-fhir-server-for-azure-extends-to-sql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/06\/9724a9fa-b033-4b42-96c2-532f3c9bf395.webp\",\"datePublished\":\"2019-06-11T07:00:00+00:00\",\"dateModified\":\"2025-06-24T14:07:50+00:00\",\"description\":\"Since the launch of the open source FHIR Server for Azure on GitHub last November, we have been humbled by the tremendously positive response and surge in the use of FHIR in the healthcare community.\",\"breadcrumb\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/microsoft-fhir-server-for-azure-extends-to-sql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/azure.microsoft.com\/en-us\/blog\/microsoft-fhir-server-for-azure-extends-to-sql\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/microsoft-fhir-server-for-azure-extends-to-sql\/#primaryimage\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/06\/9724a9fa-b033-4b42-96c2-532f3c9bf395.webp\",\"contentUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/06\/9724a9fa-b033-4b42-96c2-532f3c9bf395.webp\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/microsoft-fhir-server-for-azure-extends-to-sql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Blog home\",\"item\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Databases\",\"item\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/category\/databases\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Microsoft FHIR Server for Azure extends to SQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#website\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/\",\"name\":\"Microsoft Azure Blog\",\"description\":\"Get the latest Azure news, updates, and announcements from the Azure blog. From product updates to hot topics, hear from the Azure experts.\",\"publisher\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization\",\"name\":\"Microsoft Azure Blog\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2024\/06\/microsoft_logo.webp\",\"contentUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2024\/06\/microsoft_logo.webp\",\"width\":512,\"height\":512,\"caption\":\"Microsoft Azure Blog\"},\"image\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/microsoftazure\",\"https:\/\/x.com\/azure\",\"https:\/\/www.instagram.com\/microsoftdeveloper\/\",\"https:\/\/www.linkedin.com\/company\/16188386\",\"https:\/\/www.youtube.com\/user\/windowsazure\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/person\/c702e5edd662b328b49b7e1180cab117\",\"name\":\"shakir\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g7664e653ea371ce16eaf75e9fa8952c4\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g\",\"caption\":\"shakir\"},\"sameAs\":[\"https:\/\/azure.microsoft.com\"],\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/shakir\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Microsoft FHIR Server for Azure extends to SQL | Microsoft Azure Blog","description":"Since the launch of the open source FHIR Server for Azure on GitHub last November, we have been humbled by the tremendously positive response and surge in the use of FHIR in the healthcare community.","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:\/\/azure.microsoft.com\/en-us\/blog\/microsoft-fhir-server-for-azure-extends-to-sql\/","og_locale":"en_US","og_type":"article","og_title":"Microsoft FHIR Server for Azure extends to SQL | Microsoft Azure Blog","og_description":"Since the launch of the open source FHIR Server for Azure on GitHub last November, we have been humbled by the tremendously positive response and surge in the use of FHIR in the healthcare community.","og_url":"https:\/\/azure.microsoft.com\/en-us\/blog\/microsoft-fhir-server-for-azure-extends-to-sql\/","og_site_name":"Microsoft Azure Blog","article_publisher":"https:\/\/www.facebook.com\/microsoftazure","article_published_time":"2019-06-11T07:00:00+00:00","article_modified_time":"2025-06-24T14:07:50+00:00","og_image":[{"url":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/06\/9724a9fa-b033-4b42-96c2-532f3c9bf395.webp","type":"","width":"","height":""}],"author":"Microsoft Azure","twitter_card":"summary_large_image","twitter_creator":"@azure","twitter_site":"@azure","twitter_misc":{"Written by":"Microsoft Azure","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/microsoft-fhir-server-for-azure-extends-to-sql\/#article","isPartOf":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/microsoft-fhir-server-for-azure-extends-to-sql\/"},"author":[{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/microsoft-azure\/","@type":"Person","@name":"Microsoft Azure"}],"headline":"Microsoft FHIR Server for Azure extends to SQL","datePublished":"2019-06-11T07:00:00+00:00","dateModified":"2025-06-24T14:07:50+00:00","mainEntityOfPage":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/microsoft-fhir-server-for-azure-extends-to-sql\/"},"wordCount":759,"commentCount":0,"publisher":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization"},"image":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/microsoft-fhir-server-for-azure-extends-to-sql\/#primaryimage"},"thumbnailUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/06\/9724a9fa-b033-4b42-96c2-532f3c9bf395.webp","articleSection":["Databases","Integration","Internet of things","Mobile","Web"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/azure.microsoft.com\/en-us\/blog\/microsoft-fhir-server-for-azure-extends-to-sql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/microsoft-fhir-server-for-azure-extends-to-sql\/","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/microsoft-fhir-server-for-azure-extends-to-sql\/","name":"Microsoft FHIR Server for Azure extends to SQL | Microsoft Azure Blog","isPartOf":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/microsoft-fhir-server-for-azure-extends-to-sql\/#primaryimage"},"image":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/microsoft-fhir-server-for-azure-extends-to-sql\/#primaryimage"},"thumbnailUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/06\/9724a9fa-b033-4b42-96c2-532f3c9bf395.webp","datePublished":"2019-06-11T07:00:00+00:00","dateModified":"2025-06-24T14:07:50+00:00","description":"Since the launch of the open source FHIR Server for Azure on GitHub last November, we have been humbled by the tremendously positive response and surge in the use of FHIR in the healthcare community.","breadcrumb":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/microsoft-fhir-server-for-azure-extends-to-sql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/azure.microsoft.com\/en-us\/blog\/microsoft-fhir-server-for-azure-extends-to-sql\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/microsoft-fhir-server-for-azure-extends-to-sql\/#primaryimage","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/06\/9724a9fa-b033-4b42-96c2-532f3c9bf395.webp","contentUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/06\/9724a9fa-b033-4b42-96c2-532f3c9bf395.webp"},{"@type":"BreadcrumbList","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/microsoft-fhir-server-for-azure-extends-to-sql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog home","item":"https:\/\/azure.microsoft.com\/en-us\/blog\/"},{"@type":"ListItem","position":2,"name":"Databases","item":"https:\/\/azure.microsoft.com\/en-us\/blog\/category\/databases\/"},{"@type":"ListItem","position":3,"name":"Microsoft FHIR Server for Azure extends to SQL"}]},{"@type":"WebSite","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#website","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/","name":"Microsoft Azure Blog","description":"Get the latest Azure news, updates, and announcements from the Azure blog. From product updates to hot topics, hear from the Azure experts.","publisher":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/azure.microsoft.com\/en-us\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization","name":"Microsoft Azure Blog","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2024\/06\/microsoft_logo.webp","contentUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2024\/06\/microsoft_logo.webp","width":512,"height":512,"caption":"Microsoft Azure Blog"},"image":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/microsoftazure","https:\/\/x.com\/azure","https:\/\/www.instagram.com\/microsoftdeveloper\/","https:\/\/www.linkedin.com\/company\/16188386","https:\/\/www.youtube.com\/user\/windowsazure"]},{"@type":"Person","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/person\/c702e5edd662b328b49b7e1180cab117","name":"shakir","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g7664e653ea371ce16eaf75e9fa8952c4","url":"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g","caption":"shakir"},"sameAs":["https:\/\/azure.microsoft.com"],"url":"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/shakir\/"}]}},"msxcm_display_generated_audio":false,"msxcm_animated_featured_image":null,"distributor_meta":false,"distributor_terms":false,"distributor_media":false,"distributor_original_site_name":"Microsoft Azure Blog","distributor_original_site_url":"https:\/\/azure.microsoft.com\/en-us\/blog","push-errors":false,"_links":{"self":[{"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/posts\/1228","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/comments?post=1228"}],"version-history":[{"count":1,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/posts\/1228\/revisions"}],"predecessor-version":[{"id":43047,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/posts\/1228\/revisions\/43047"}],"wp:attachment":[{"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/media?parent=1228"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/categories?post=1228"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/tags?post=1228"},{"taxonomy":"audience","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/audience?post=1228"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/content-type?post=1228"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/product?post=1228"},{"taxonomy":"tech-community","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/tech-community?post=1228"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/topic?post=1228"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/coauthors?post=1228"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}