{"id":7623,"date":"2019-12-19T12:43:51","date_gmt":"2019-12-19T20:43:51","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/general-availability-of-the-azure-ad-sql-server-connector\/"},"modified":"2025-06-11T08:00:47","modified_gmt":"2025-06-11T15:00:47","slug":"general-availability-of-the-azure-ad-sql-server-connector","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/general-availability-of-the-azure-ad-sql-server-connector\/","title":{"rendered":"General Availability of the Azure AD SQL Server connector"},"content":{"rendered":"<p>We are pleased to announce the general availability of the Azure AD support for the the SQL Server connector.\u00a0 \u00a0The\u00a0<a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/sql-database\/sql-database-aad-authentication\">Azure AD authentication for Azure SQL Database<\/a> provides significant security benefits for Power Apps and Power Automate authors and users.\u00a0 \u00a0This feature enables each user to connect to a SQL Azure database with their own credentials. The SQL Server connection using Azure AD authentication is <a href=\"https:\/\/docs.microsoft.com\/en-us\/powerapps\/maker\/canvas-apps\/connections-list\">not implicitly shared<\/a> when a Power App is shared.\u00a0 This is similar to how authentication works for Office 365 Outlook, SharePoint and other Azure AD based services.<\/p>\n<h2>Using the feature in Microsoft Flow<\/h2>\n<p>In Microsoft Flow, this feature is available when you create a new SQL Server connection. When you create a new connection, you will be asked to choose an Authentication Type. You can now select \u201cAzure AD Integrated\u201d authentication. Once selected, you can sign in with your Azure AD account to create a connection.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" class=\"aligncenter wp-image-7706 size-full\" height=\"430\" src=\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/12\/Flow-SQL-AAD-GA-1.png\" width=\"1216\" srcset=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/12\/Flow-SQL-AAD-GA-1.webp 1216w, https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/12\/Flow-SQL-AAD-GA-1-300x106.webp 300w, https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/12\/Flow-SQL-AAD-GA-1-1024x362.webp 1024w, https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/12\/Flow-SQL-AAD-GA-1-768x272.webp 768w\" sizes=\"auto, (max-width: 1216px) 100vw, 1216px\" \/><\/p>\n<p>After you select a connection, you need to specify the server and database as part of the action or trigger you are using. This allows you to use a single connection \u2013 associated with your Azure AD credentials \u2013 across multiple SQL Servers and databases. Note that we provide a dynamic drop-down for the Database parameter once you provide a valid SQL server. Once you provide the server and database, you can proceed to provide the rest of the parameters required for your operation.<\/p>\n<p>TIP: If your credentials do not have access to list the database, you can select \u201cEnter custom value\u201d and type in the database name.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"SQL connector in Flow - Database dropdown\" class=\"alignnone wp-image-6658 size-large\" height=\"294\" src=\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/10\/sql-add-flow-2-1024x574.png\" width=\"525\"\/><\/p>\n<h2>Using the feature in Microsoft Power Apps<\/h2>\n<p>In Power Apps, this feature is now enabled by default.\u00a0 All new applications have this capability.\u00a0 If you have an existing application that you need to convert to use this new authentication, you must enable it the the File &gt; App settings &gt; Advanced settings section.\u00a0 To enable this feature, open your app in studio and enable the \u201cEnable enhanced Microsoft SQL Server connector\u201d feature.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"PowerApps settings\" class=\"alignnone wp-image-6654 size-large\" height=\"278\" src=\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/10\/sql-aad-powerapps-settings-1024x543.png\" width=\"525\"\/><\/p>\n<p>To the use the Azure AD Integrated authentication select the \u201cAzure AD Integrated\u201d option from the drop-down. Click on \u201cCreate\u201d to create a connection. Note you may need to sign in to Azure AD.\u00a0 Once the connection is created, you can specify the SQL server and database name and connect to it.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" class=\"aligncenter wp-image-7704 size-full\" height=\"708\" src=\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/12\/Power-Apps-and-SQL-AAD-GA.png\" width=\"1280\" srcset=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/12\/Power-Apps-and-SQL-AAD-GA.webp 1280w, https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/12\/Power-Apps-and-SQL-AAD-GA-300x166.webp 300w, https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/12\/Power-Apps-and-SQL-AAD-GA-1024x566.webp 1024w, https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/12\/Power-Apps-and-SQL-AAD-GA-768x425.webp 768w\" sizes=\"auto, (max-width: 1280px) 100vw, 1280px\" \/><\/p>\n<p>Once you are connected to a database, you will be able to select the tables and views you want to add in your app from a list. This experience and the rest remain the same as before.<\/p>\n<p>Once you build the app, you can share the app. When you use Azure AD authentication with SQL Server, the connection will not be shared with the shared users.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"Sharing an app\" class=\"alignnone wp-image-6655 size-large\" height=\"94\" src=\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/10\/sql-aad-powerapps-sharing-1-1024x183.png\" width=\"525\"\/><br \/>\nThe user to who you have shared the app with, will need to login with their own credentials.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"Launching an app\" class=\"alignnone size-large wp-image-6656\" height=\"480\" src=\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/10\/sql-aad-powerapps-sharing-2-1024x936.png\" width=\"525\"\/><\/p>\n<h3>Other changes in the SQL Server connector<\/h3>\n<p>Along with enabling Azure AD Integrated authentication,\u00a0 we also updated the SQL server connector as well.\u00a0 These are GA with this announcement as well.\u00a0 In particular, we have have better support for SQL datetime, datetime2, and smalldatetime data types.<\/p>\n<p>Specifically, while ODATA 2.0 has support for these types with Edm.DateTime, it was deprecated in ODATA 4.0. A datetime requires a timezone specifier as well \u2013 that way, every system knows the exact moment.\u00a0 This is useful for building an API.\u00a0 For our connector however we do not control the data source.\u00a0 And there are too many SQL databases using the SQL datetime types. the way we have previously implemented them.\u00a0 We used to map these SQL types to ODATA Edm.DateTimeOffset and using a JSON string as defined in RFC 3339 and in ISO 8601. This led to user confusion and errors because of timezone differences between the client, the data source and the normalization done by the platform in between. To solve this, we introduced a custom data type identifier in our platform which allows us to normalize the data as strings in appropriate format. We consider this a \u2018breaking\u2019 change \u2013 something that necessitate us to introduce a major API version. In future, we will be adding delegation support for these types as well.<\/p>\n<p>We hope these updates address a long standing ask from our customers. Please feel free to reach out in our product forums for any feedback.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>GA of SQL Server Azure AD authentication<\/p>\n","protected":false},"author":105,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ms_queue_id":[],"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","_alt_title":"","ms-ems-related-posts":[],"footnotes":""},"audience":[3378],"content-type":[],"job-role":[],"product":[3473],"property":[],"topic":[3421],"coauthors":[2056],"class_list":["post-7623","post","type-post","status-publish","format-standard","hentry","audience-it-professional","product-power-apps","topic-application-modernization"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>General Availability of the Azure AD SQL Server connector - Microsoft Power Platform Blog<\/title>\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\/power-platform\/blog\/2019\/12\/19\/general-availability-of-the-azure-ad-sql-server-connector\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"General Availability of the Azure AD SQL Server connector - Microsoft Power Platform Blog\" \/>\n<meta property=\"og:description\" content=\"GA of SQL Server Azure AD authentication\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/general-availability-of-the-azure-ad-sql-server-connector\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft Power Platform Blog\" \/>\n<meta property=\"article:published_time\" content=\"2019-12-19T20:43:51+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-11T15:00:47+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/12\/Flow-SQL-AAD-GA-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1216\" \/>\n\t<meta property=\"og:image:height\" content=\"430\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Lance Delano\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Lance Delano\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2019\/12\/19\/general-availability-of-the-azure-ad-sql-server-connector\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2019\/12\/19\/general-availability-of-the-azure-ad-sql-server-connector\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/author\/lance-delano\/\",\"@type\":\"Person\",\"@name\":\"Lance Delano\"}],\"headline\":\"General Availability of the Azure AD SQL Server connector\",\"datePublished\":\"2019-12-19T20:43:51+00:00\",\"dateModified\":\"2025-06-11T15:00:47+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2019\/12\/19\/general-availability-of-the-azure-ad-sql-server-connector\/\"},\"wordCount\":716,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2019\/12\/19\/general-availability-of-the-azure-ad-sql-server-connector\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/12\/Flow-SQL-AAD-GA-1.png\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2019\/12\/19\/general-availability-of-the-azure-ad-sql-server-connector\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2019\/12\/19\/general-availability-of-the-azure-ad-sql-server-connector\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2019\/12\/19\/general-availability-of-the-azure-ad-sql-server-connector\/\",\"name\":\"General Availability of the Azure AD SQL Server connector - Microsoft Power Platform Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2019\/12\/19\/general-availability-of-the-azure-ad-sql-server-connector\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2019\/12\/19\/general-availability-of-the-azure-ad-sql-server-connector\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/12\/Flow-SQL-AAD-GA-1.png\",\"datePublished\":\"2019-12-19T20:43:51+00:00\",\"dateModified\":\"2025-06-11T15:00:47+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2019\/12\/19\/general-availability-of-the-azure-ad-sql-server-connector\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2019\/12\/19\/general-availability-of-the-azure-ad-sql-server-connector\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2019\/12\/19\/general-availability-of-the-azure-ad-sql-server-connector\/#primaryimage\",\"url\":\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/12\/Flow-SQL-AAD-GA-1.png\",\"contentUrl\":\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/12\/Flow-SQL-AAD-GA-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2019\/12\/19\/general-availability-of-the-azure-ad-sql-server-connector\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"General Availability of the Azure AD SQL Server connector\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/\",\"name\":\"Microsoft Power Platform Blog\",\"description\":\"Innovate with Business Apps\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/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\/power-platform\/blog\/#organization\",\"name\":\"Microsoft Power Platform Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png\",\"width\":194,\"height\":145,\"caption\":\"Microsoft Power Platform Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/person\/3190911147b72493d0668bd37a01e9e7\",\"name\":\"Lance Delano\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/0f6ea411fb7942a5194735a5c3de7bd16e6f4e03284653afdd08d85c85edbd7b?s=96&d=mm&r=gb821537d0bc9cf865938c8648693fa53\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/0f6ea411fb7942a5194735a5c3de7bd16e6f4e03284653afdd08d85c85edbd7b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/0f6ea411fb7942a5194735a5c3de7bd16e6f4e03284653afdd08d85c85edbd7b?s=96&d=mm&r=g\",\"caption\":\"Lance Delano\"},\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/author\/lanced\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"General Availability of the Azure AD SQL Server connector - Microsoft Power Platform Blog","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\/power-platform\/blog\/2019\/12\/19\/general-availability-of-the-azure-ad-sql-server-connector\/","og_locale":"en_US","og_type":"article","og_title":"General Availability of the Azure AD SQL Server connector - Microsoft Power Platform Blog","og_description":"GA of SQL Server Azure AD authentication","og_url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/general-availability-of-the-azure-ad-sql-server-connector\/","og_site_name":"Microsoft Power Platform Blog","article_published_time":"2019-12-19T20:43:51+00:00","article_modified_time":"2025-06-11T15:00:47+00:00","og_image":[{"width":1216,"height":430,"url":"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/12\/Flow-SQL-AAD-GA-1.png","type":"image\/png"}],"author":"Lance Delano","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Lance Delano","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2019\/12\/19\/general-availability-of-the-azure-ad-sql-server-connector\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2019\/12\/19\/general-availability-of-the-azure-ad-sql-server-connector\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/author\/lance-delano\/","@type":"Person","@name":"Lance Delano"}],"headline":"General Availability of the Azure AD SQL Server connector","datePublished":"2019-12-19T20:43:51+00:00","dateModified":"2025-06-11T15:00:47+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2019\/12\/19\/general-availability-of-the-azure-ad-sql-server-connector\/"},"wordCount":716,"commentCount":0,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2019\/12\/19\/general-availability-of-the-azure-ad-sql-server-connector\/#primaryimage"},"thumbnailUrl":"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/12\/Flow-SQL-AAD-GA-1.png","inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2019\/12\/19\/general-availability-of-the-azure-ad-sql-server-connector\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2019\/12\/19\/general-availability-of-the-azure-ad-sql-server-connector\/","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2019\/12\/19\/general-availability-of-the-azure-ad-sql-server-connector\/","name":"General Availability of the Azure AD SQL Server connector - Microsoft Power Platform Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2019\/12\/19\/general-availability-of-the-azure-ad-sql-server-connector\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2019\/12\/19\/general-availability-of-the-azure-ad-sql-server-connector\/#primaryimage"},"thumbnailUrl":"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/12\/Flow-SQL-AAD-GA-1.png","datePublished":"2019-12-19T20:43:51+00:00","dateModified":"2025-06-11T15:00:47+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2019\/12\/19\/general-availability-of-the-azure-ad-sql-server-connector\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2019\/12\/19\/general-availability-of-the-azure-ad-sql-server-connector\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2019\/12\/19\/general-availability-of-the-azure-ad-sql-server-connector\/#primaryimage","url":"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/12\/Flow-SQL-AAD-GA-1.png","contentUrl":"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/12\/Flow-SQL-AAD-GA-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2019\/12\/19\/general-availability-of-the-azure-ad-sql-server-connector\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/"},{"@type":"ListItem","position":2,"name":"General Availability of the Azure AD SQL Server connector"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/","name":"Microsoft Power Platform Blog","description":"Innovate with Business Apps","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/power-platform\/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\/power-platform\/blog\/#organization","name":"Microsoft Power Platform Blog","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png","width":194,"height":145,"caption":"Microsoft Power Platform Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/person\/3190911147b72493d0668bd37a01e9e7","name":"Lance Delano","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/0f6ea411fb7942a5194735a5c3de7bd16e6f4e03284653afdd08d85c85edbd7b?s=96&d=mm&r=gb821537d0bc9cf865938c8648693fa53","url":"https:\/\/secure.gravatar.com\/avatar\/0f6ea411fb7942a5194735a5c3de7bd16e6f4e03284653afdd08d85c85edbd7b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0f6ea411fb7942a5194735a5c3de7bd16e6f4e03284653afdd08d85c85edbd7b?s=96&d=mm&r=g","caption":"Lance Delano"},"url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/author\/lanced\/"}]}},"bloginabox_animated_featured_image":null,"bloginabox_display_generated_audio":false,"distributor_meta":false,"distributor_terms":false,"distributor_media":false,"distributor_original_site_name":"Microsoft Power Platform Blog","distributor_original_site_url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog","push-errors":false,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts\/7623","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/users\/105"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/comments?post=7623"}],"version-history":[{"count":1,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts\/7623\/revisions"}],"predecessor-version":[{"id":130711,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts\/7623\/revisions\/130711"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/media?parent=7623"}],"wp:term":[{"taxonomy":"audience","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/audience?post=7623"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/content-type?post=7623"},{"taxonomy":"job-role","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/job-role?post=7623"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/product?post=7623"},{"taxonomy":"property","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/property?post=7623"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/topic?post=7623"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/coauthors?post=7623"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}