{"id":223,"date":"2018-12-20T07:10:12","date_gmt":"2018-12-20T05:10:12","guid":{"rendered":"https:\/\/www.moderndata.ai\/?p=223"},"modified":"2019-07-04T21:32:11","modified_gmt":"2019-07-04T19:32:11","slug":"scale-azure-sql-using-adf-web-activity","status":"publish","type":"post","link":"https:\/\/www.moderndata.ai\/2018\/12\/scale-azure-sql-using-adf-web-activity\/","title":{"rendered":"How To Scale Azure SQL Database In Azure Data Factory Using A Web Activity"},"content":{"rendered":"<p><strong>Azure SQL Database is a very flexible service that can be easily scaled to fit the needs of the moment. In most solutions, I like to orchestrate the up and down scaling right from within Azure Data Factory, and I&#8217;m always interested in more efficient approaches to do this.<\/strong><\/p>\n<p><strong><span style=\"color: #ff0000;\">&lt;&#8212; <\/span><span style=\"color: #ff0000;\">Update 4-7-2019:<\/span><\/strong><br \/>\nI\u2019ve learned from a colleague (thanks Roland \u270c) that you can find the correct values with the SQL query below, after you have manually set the database to the desired tier and size:<\/p>\n<p><code>SELECT DATABASEPROPERTYEX(db_name(),'edition') AS ServiceTier , DATABASEPROPERTYEX(db_name(),'serviceobjective') AS ComputeSize<\/code><br \/>\n<strong><span style=\"color: #ff0000;\">&#8212;&gt;<\/span><\/strong><\/p>\n<p>Until today, to scale up an Azure SQL Database before a particular workload in Azure Data Factory, I had quite some options to choose from to achieve this:<\/p>\n<ul>\n<li>Create a <strong>LogicApp<\/strong>, and trigger it with a Web Activity in Azure Data Factory.<\/li>\n<li>Create an <strong>Azure Function<\/strong>, and invoke the function using the new Azure Function Activity in Azure Data Factory.<\/li>\n<li>Create an <strong>Azure Automation<\/strong> workbook, add a webhook to it and call that with a Web Activity in Azure Data Factory.<\/li>\n<li>Create a\u00a0<strong>T-SQL\u00a0script<\/strong>\u00a0with an ALTER DATABASE statement and call that with a Stored Procedure Activity in Azure Data Factory.<\/li>\n<\/ul>\n<h4>New kid in town (well, at least for me)<\/h4>\n<p>But today, my dear colleague Simon Zeinstra pointed out that the Azure Data Factory Web Activity supports managed identity (MSI) authentication, thanks \ud83d\udc4a\ud83c\udffb. And I successfully\u00a0put together another really\u00a0good option: using the Azure Management\u00a0<strong>REST API<\/strong> with a Web Activity in Azure Data Factory. And <strong>it is so simple and easy to set up, this probably is my favorite option from now on<\/strong> \ud83d\ude0e.<br \/>\nThe Web Activity seems to call the REST API synchronously, hence it does not finish before the scale operation is completed.<\/p>\n<figure id=\"attachment_226\" aria-describedby=\"caption-attachment-226\" style=\"width: 540px\" class=\"wp-caption alignnone\"><img fetchpriority=\"high\" decoding=\"async\" class=\"wp-image-226\" src=\"https:\/\/www.moderndata.ai\/wp-content\/uploads\/2018\/12\/2018-12-20-21_13_52-Azure-Data-Factory.png\" alt=\"ADF Web Activity\" width=\"540\" height=\"134\" srcset=\"https:\/\/www.moderndata.ai\/wp-content\/uploads\/2018\/12\/2018-12-20-21_13_52-Azure-Data-Factory.png 1322w, https:\/\/www.moderndata.ai\/wp-content\/uploads\/2018\/12\/2018-12-20-21_13_52-Azure-Data-Factory-600x148.png 600w, https:\/\/www.moderndata.ai\/wp-content\/uploads\/2018\/12\/2018-12-20-21_13_52-Azure-Data-Factory-300x74.png 300w, https:\/\/www.moderndata.ai\/wp-content\/uploads\/2018\/12\/2018-12-20-21_13_52-Azure-Data-Factory-768x190.png 768w, https:\/\/www.moderndata.ai\/wp-content\/uploads\/2018\/12\/2018-12-20-21_13_52-Azure-Data-Factory-1024x253.png 1024w, https:\/\/www.moderndata.ai\/wp-content\/uploads\/2018\/12\/2018-12-20-21_13_52-Azure-Data-Factory-370x92.png 370w, https:\/\/www.moderndata.ai\/wp-content\/uploads\/2018\/12\/2018-12-20-21_13_52-Azure-Data-Factory-570x141.png 570w, https:\/\/www.moderndata.ai\/wp-content\/uploads\/2018\/12\/2018-12-20-21_13_52-Azure-Data-Factory-770x190.png 770w, https:\/\/www.moderndata.ai\/wp-content\/uploads\/2018\/12\/2018-12-20-21_13_52-Azure-Data-Factory-1170x289.png 1170w\" sizes=\"(max-width: 540px) 100vw, 540px\" \/><figcaption id=\"caption-attachment-226\" class=\"wp-caption-text\">Less is more: we only need a Web Activity.<\/figcaption><\/figure>\n<h4>Configuration<\/h4>\n<p>The following configuration for the Web Activity is what worked in my set up.<\/p>\n<ul>\n<li><strong>URL<\/strong>: Use the following URL, where you replace the stuff between {brackets}. Be sure to specify the Azure SQL Server without the &#8220;.database.windows.net&#8221; part.<br \/>\n<code>https:\/\/management.azure.com\/subscriptions\/{your SubscriptionID}\/resourceGroups\/{your RG}\/providers\/Microsoft.Sql\/servers\/{your sqlservername}\/databases\/{your databasename}?api-version=2017-10-01-preview<\/code><\/li>\n<li><strong>Methode<\/strong>: <code>PUT<\/code><\/li>\n<li><strong>Headers<\/strong>: Add a header with name\u00a0<code>Content-Type<\/code>, and value\u00a0<code>application\/<\/code>json.<\/li>\n<li><strong>Body<\/strong>: Use the following json body, where you specify the sku name and tier that you want your database to be scaled to, and the region of the database:<br \/>\n<code>{\"<\/code>sku<code>\":{\"name\":\"P1\",\"tier\":\"Premium\"}, \"location\": \"West Europe\"}<\/code><\/li>\n<li><strong>Authentication<\/strong>: <code>MSI<\/code><\/li>\n<li><strong>Resource<\/strong>:\u00a0<code>https:\/\/management.azure.com\/<\/code><\/li>\n<\/ul>\n<h4>Authorisation<\/h4>\n<p>If you have completed your configuration and debug the Web Activity, you may get this error message:<\/p>\n<p><code>{<br \/>\n\"errorCode\": \"2108\",<br \/>\n\"message\": \"{\\\"error\\\":{\\\"code\\\":\\\"AuthorizationFailed\\\",\\\"message\\\":\\\"<strong>The client '{GUID}' with object id '{GUID}' does not have authorization to perform action 'Microsoft.Sql\/servers\/databases\/write'<\/strong> over scope '\/subscriptions\/{subid}\/resourceGroups\/{rgid}\/providers\/Microsoft.Sql\/servers\/{sqlservername}\/databases\/{dbname}'.\\\"}}\",<br \/>\n\"failureType\": \"UserError\",<br \/>\n\"target\": \"Scale up ASQL DB\"<br \/>\n}<\/code><\/p>\n<p>This means the <strong>managed identity (MSI)<\/strong> of our Azure Data Factory does not yet have the correct permissions on our Azure SQL Server. Follow these steps to do this:<\/p>\n<ol>\n<li>In the Azure Portal, go to the SQL Server.<\/li>\n<li>Open the &#8216;Access control (IAM)&#8217; option.<\/li>\n<li>Click &#8216;Add role assignment&#8217;.<\/li>\n<li>Choose role &#8216;Contributor&#8217;.<\/li>\n<li>In the search box for &#8216;Select&#8217;, type the exact name of your Azure Data Factory resource, and select it.<\/li>\n<li>Click Save.<\/li>\n<\/ol>\n<p>Now the managed identity (MSI) of your Azure Data Factory is able to change the options of your database!<\/p>\n<h4>Quickstart ADF pipeline example<\/h4>\n<p>For your convenience, I&#8217;ve shared an example Azure Data Factory pipeline on GitHub.<br \/>\n<script src=\"https:\/\/gist.github.com\/DaveRuijter\/10721f8aff40227a5159322fa8649e63.js\"><\/script><\/p>\n<h4>Conclusion<\/h4>\n<p>You now know how to effortlessly use a Web Activity in Azure Data Factory to scale your Azure SQL Database.<\/p>\n<p>The ease-of-use of this solution is awesome, and largely due to how the authentication between Azure Data Factory and Azure SQL is taken care of via managed identity (MSI). Keeping any credentials out of my code, and I don&#8217;t even have to use Azure Key Vault to accomplish this.<\/p>\n<p>The other options I mentioned like LogicApps, Functions and Runbooks sure provide more features and options. Time will tell if this simple option is going to be my new default, but it sure seems like it \ud83d\udc4d!<\/p>\n<h4>More info:<\/h4>\n<ul>\n<li>https:\/\/docs.microsoft.com\/en-us\/azure\/data-factory\/control-flow-web-activity<\/li>\n<li>https:\/\/docs.microsoft.com\/en-us\/azure\/sql-database\/sql-database-single-database-scale<\/li>\n<li>https:\/\/docs.microsoft.com\/en-us\/azure\/active-directory\/managed-identities-azure-resources\/overview<\/li>\n<li>https:\/\/docs.microsoft.com\/en-us\/azure\/active-directory\/managed-identities-azure-resources\/services-support-msi<\/li>\n<li>https:\/\/docs.microsoft.com\/en-us\/azure\/sql-database\/sql-database-service-tiers-dtu<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Azure SQL Database is a very flexible service that can be easily scaled to fit the needs of the moment. In most solutions, I like to orchestrate the up and down scaling right from within Azure Data Factory, and I&#8217;m always interested in more efficient approaches to do this. &lt;&#8212; Update 4-7-2019: I\u2019ve learned from [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":235,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"ocean_post_layout":"","ocean_both_sidebars_style":"","ocean_both_sidebars_content_width":0,"ocean_both_sidebars_sidebars_width":0,"ocean_sidebar":"","ocean_second_sidebar":"","ocean_disable_margins":"enable","ocean_add_body_class":"","ocean_shortcode_before_top_bar":"","ocean_shortcode_after_top_bar":"","ocean_shortcode_before_header":"","ocean_shortcode_after_header":"","ocean_has_shortcode":"","ocean_shortcode_after_title":"","ocean_shortcode_before_footer_widgets":"","ocean_shortcode_after_footer_widgets":"","ocean_shortcode_before_footer_bottom":"","ocean_shortcode_after_footer_bottom":"","ocean_display_top_bar":"default","ocean_display_header":"default","ocean_header_style":"","ocean_center_header_left_menu":"","ocean_custom_header_template":"","ocean_custom_logo":0,"ocean_custom_retina_logo":0,"ocean_custom_logo_max_width":0,"ocean_custom_logo_tablet_max_width":0,"ocean_custom_logo_mobile_max_width":0,"ocean_custom_logo_max_height":0,"ocean_custom_logo_tablet_max_height":0,"ocean_custom_logo_mobile_max_height":0,"ocean_header_custom_menu":"","ocean_menu_typo_font_family":"","ocean_menu_typo_font_subset":"","ocean_menu_typo_font_size":0,"ocean_menu_typo_font_size_tablet":0,"ocean_menu_typo_font_size_mobile":0,"ocean_menu_typo_font_size_unit":"px","ocean_menu_typo_font_weight":"","ocean_menu_typo_font_weight_tablet":"","ocean_menu_typo_font_weight_mobile":"","ocean_menu_typo_transform":"","ocean_menu_typo_transform_tablet":"","ocean_menu_typo_transform_mobile":"","ocean_menu_typo_line_height":0,"ocean_menu_typo_line_height_tablet":0,"ocean_menu_typo_line_height_mobile":0,"ocean_menu_typo_line_height_unit":"","ocean_menu_typo_spacing":0,"ocean_menu_typo_spacing_tablet":0,"ocean_menu_typo_spacing_mobile":0,"ocean_menu_typo_spacing_unit":"","ocean_menu_link_color":"","ocean_menu_link_color_hover":"","ocean_menu_link_color_active":"","ocean_menu_link_background":"","ocean_menu_link_hover_background":"","ocean_menu_link_active_background":"","ocean_menu_social_links_bg":"","ocean_menu_social_hover_links_bg":"","ocean_menu_social_links_color":"","ocean_menu_social_hover_links_color":"","ocean_disable_title":"default","ocean_disable_heading":"default","ocean_post_title":"","ocean_post_subheading":"","ocean_post_title_style":"","ocean_post_title_background_color":"","ocean_post_title_background":0,"ocean_post_title_bg_image_position":"","ocean_post_title_bg_image_attachment":"","ocean_post_title_bg_image_repeat":"","ocean_post_title_bg_image_size":"","ocean_post_title_height":0,"ocean_post_title_bg_overlay":0.5,"ocean_post_title_bg_overlay_color":"","ocean_disable_breadcrumbs":"default","ocean_breadcrumbs_color":"","ocean_breadcrumbs_separator_color":"","ocean_breadcrumbs_links_color":"","ocean_breadcrumbs_links_hover_color":"","ocean_display_footer_widgets":"default","ocean_display_footer_bottom":"default","ocean_custom_footer_template":"","ocean_post_oembed":"","ocean_post_self_hosted_media":"","ocean_post_video_embed":"","ocean_link_format":"","ocean_link_format_target":"self","ocean_quote_format":"","ocean_quote_format_link":"post","ocean_gallery_link_images":"on","ocean_gallery_id":[]},"categories":[10],"tags":[6,11,27,28],"yoast_head":"<title>Scale Azure SQL Database from Azure Data Factory - Modern Data &amp; AI<\/title>\n<meta name=\"description\" content=\"Learn how to use a Web Activity in Azure Data Factory to scale your Azure SQL Database. The ease-of-use of this solution is awesome, and largely due to how the authentication between Azure Data Factory and Azure SQL is taken care of via managed identity (MSI).\" \/>\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.moderndata.ai\/2018\/12\/scale-azure-sql-using-adf-web-activity\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Scale Azure SQL Database In Azure Data Factory Using Just A Web Activity\" \/>\n<meta property=\"og:description\" content=\"Learn how to use a Web Activity in Azure Data Factory to scale your Azure SQL Database.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.moderndata.ai\/2018\/12\/scale-azure-sql-using-adf-web-activity\/\" \/>\n<meta property=\"og:site_name\" content=\"Modern Data &amp; AI\" \/>\n<meta property=\"article:published_time\" content=\"2018-12-20T05:10:12+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-07-04T19:32:11+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.moderndata.ai\/wp-content\/uploads\/2018\/12\/2018-12-20-21_13_52-Azure-Data-Factory.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1322\" \/>\n\t<meta property=\"og:image:height\" content=\"327\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Dave Ruijter\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"New blog post by @DaveRuijter: &quot;How To Scale #AzureSQLDatabase In #AzureDataFactory Using Just A Web Activity&quot;\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/www.moderndata.ai\/wp-content\/uploads\/2018\/12\/2018-12-20-21_13_52-Azure-Data-Factory.png\" \/>\n<meta name=\"twitter:creator\" content=\"@DaveRuijter\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dave Ruijter\" \/>\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.moderndata.ai\/2018\/12\/scale-azure-sql-using-adf-web-activity\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.moderndata.ai\/2018\/12\/scale-azure-sql-using-adf-web-activity\/\"},\"author\":{\"name\":\"Dave Ruijter\",\"@id\":\"https:\/\/www.moderndata.ai\/#\/schema\/person\/662f0589643bb4205482d128fac88ddc\"},\"headline\":\"How To Scale Azure SQL Database In Azure Data Factory Using A Web Activity\",\"datePublished\":\"2018-12-20T05:10:12+00:00\",\"dateModified\":\"2019-07-04T19:32:11+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.moderndata.ai\/2018\/12\/scale-azure-sql-using-adf-web-activity\/\"},\"wordCount\":675,\"commentCount\":39,\"publisher\":{\"@id\":\"https:\/\/www.moderndata.ai\/#organization\"},\"keywords\":[\"Azure Data Factory\",\"Azure SQL Database\",\"Scaling\",\"Web Activity\"],\"articleSection\":[\"Data Platform\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.moderndata.ai\/2018\/12\/scale-azure-sql-using-adf-web-activity\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.moderndata.ai\/2018\/12\/scale-azure-sql-using-adf-web-activity\/\",\"url\":\"https:\/\/www.moderndata.ai\/2018\/12\/scale-azure-sql-using-adf-web-activity\/\",\"name\":\"Scale Azure SQL Database from Azure Data Factory - Modern Data &amp; AI\",\"isPartOf\":{\"@id\":\"https:\/\/www.moderndata.ai\/#website\"},\"datePublished\":\"2018-12-20T05:10:12+00:00\",\"dateModified\":\"2019-07-04T19:32:11+00:00\",\"description\":\"Learn how to use a Web Activity in Azure Data Factory to scale your Azure SQL Database. The ease-of-use of this solution is awesome, and largely due to how the authentication between Azure Data Factory and Azure SQL is taken care of via managed identity (MSI).\",\"breadcrumb\":{\"@id\":\"https:\/\/www.moderndata.ai\/2018\/12\/scale-azure-sql-using-adf-web-activity\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.moderndata.ai\/2018\/12\/scale-azure-sql-using-adf-web-activity\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.moderndata.ai\/2018\/12\/scale-azure-sql-using-adf-web-activity\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.moderndata.ai\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Scale Azure SQL Database In Azure Data Factory Using A Web Activity\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.moderndata.ai\/#website\",\"url\":\"https:\/\/www.moderndata.ai\/\",\"name\":\"Modern Data &amp; AI\",\"description\":\"A blog on Power BI &amp; Azure Data Platform\",\"publisher\":{\"@id\":\"https:\/\/www.moderndata.ai\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.moderndata.ai\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.moderndata.ai\/#organization\",\"name\":\"Modern Data &amp; AI\",\"url\":\"https:\/\/www.moderndata.ai\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.moderndata.ai\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.moderndata.ai\/wp-content\/uploads\/2021\/11\/mod-e1636956448571.png\",\"contentUrl\":\"https:\/\/www.moderndata.ai\/wp-content\/uploads\/2021\/11\/mod-e1636956448571.png\",\"width\":403,\"height\":80,\"caption\":\"Modern Data &amp; AI\"},\"image\":{\"@id\":\"https:\/\/www.moderndata.ai\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.moderndata.ai\/#\/schema\/person\/662f0589643bb4205482d128fac88ddc\",\"name\":\"Dave Ruijter\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.moderndata.ai\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/www.moderndata.ai\/wp-content\/uploads\/2023\/02\/Dave-Ruijter-grey-150x150.jpg\",\"contentUrl\":\"https:\/\/www.moderndata.ai\/wp-content\/uploads\/2023\/02\/Dave-Ruijter-grey-150x150.jpg\",\"caption\":\"Dave Ruijter\"},\"description\":\"Dave is a hands-on solution and platform architect that operationalizes data-driven strategies of organizations. Leveraging the full potential of the Azure Data Platform and he Power Platform (with a focus on Power BI). He brings a vast amount of consultancy experience to the table and is always eager to take things to the next level. Dave has received the Microsoft MVP Award twice for his deep knowledge of Microsoft products and services and community leadership.\",\"sameAs\":[\"https:\/\/moderndata.ai\/\",\"https:\/\/linkedin.com\/in\/daveruijter\",\"https:\/\/twitter.com\/DaveRuijter\"],\"url\":\"https:\/\/www.moderndata.ai\/author\/daveruijter\/\"}]}<\/script>","yoast_head_json":{"title":"Scale Azure SQL Database from Azure Data Factory - Modern Data &amp; AI","description":"Learn how to use a Web Activity in Azure Data Factory to scale your Azure SQL Database. The ease-of-use of this solution is awesome, and largely due to how the authentication between Azure Data Factory and Azure SQL is taken care of via managed identity (MSI).","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.moderndata.ai\/2018\/12\/scale-azure-sql-using-adf-web-activity\/","og_locale":"en_US","og_type":"article","og_title":"How To Scale Azure SQL Database In Azure Data Factory Using Just A Web Activity","og_description":"Learn how to use a Web Activity in Azure Data Factory to scale your Azure SQL Database.","og_url":"https:\/\/www.moderndata.ai\/2018\/12\/scale-azure-sql-using-adf-web-activity\/","og_site_name":"Modern Data &amp; AI","article_published_time":"2018-12-20T05:10:12+00:00","article_modified_time":"2019-07-04T19:32:11+00:00","og_image":[{"width":1322,"height":327,"url":"https:\/\/www.moderndata.ai\/wp-content\/uploads\/2018\/12\/2018-12-20-21_13_52-Azure-Data-Factory.png","type":"image\/png"}],"author":"Dave Ruijter","twitter_card":"summary_large_image","twitter_title":"New blog post by @DaveRuijter: \"How To Scale #AzureSQLDatabase In #AzureDataFactory Using Just A Web Activity\"","twitter_image":"https:\/\/www.moderndata.ai\/wp-content\/uploads\/2018\/12\/2018-12-20-21_13_52-Azure-Data-Factory.png","twitter_creator":"@DaveRuijter","twitter_misc":{"Written by":"Dave Ruijter","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.moderndata.ai\/2018\/12\/scale-azure-sql-using-adf-web-activity\/#article","isPartOf":{"@id":"https:\/\/www.moderndata.ai\/2018\/12\/scale-azure-sql-using-adf-web-activity\/"},"author":{"name":"Dave Ruijter","@id":"https:\/\/www.moderndata.ai\/#\/schema\/person\/662f0589643bb4205482d128fac88ddc"},"headline":"How To Scale Azure SQL Database In Azure Data Factory Using A Web Activity","datePublished":"2018-12-20T05:10:12+00:00","dateModified":"2019-07-04T19:32:11+00:00","mainEntityOfPage":{"@id":"https:\/\/www.moderndata.ai\/2018\/12\/scale-azure-sql-using-adf-web-activity\/"},"wordCount":675,"commentCount":39,"publisher":{"@id":"https:\/\/www.moderndata.ai\/#organization"},"keywords":["Azure Data Factory","Azure SQL Database","Scaling","Web Activity"],"articleSection":["Data Platform"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.moderndata.ai\/2018\/12\/scale-azure-sql-using-adf-web-activity\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.moderndata.ai\/2018\/12\/scale-azure-sql-using-adf-web-activity\/","url":"https:\/\/www.moderndata.ai\/2018\/12\/scale-azure-sql-using-adf-web-activity\/","name":"Scale Azure SQL Database from Azure Data Factory - Modern Data &amp; AI","isPartOf":{"@id":"https:\/\/www.moderndata.ai\/#website"},"datePublished":"2018-12-20T05:10:12+00:00","dateModified":"2019-07-04T19:32:11+00:00","description":"Learn how to use a Web Activity in Azure Data Factory to scale your Azure SQL Database. The ease-of-use of this solution is awesome, and largely due to how the authentication between Azure Data Factory and Azure SQL is taken care of via managed identity (MSI).","breadcrumb":{"@id":"https:\/\/www.moderndata.ai\/2018\/12\/scale-azure-sql-using-adf-web-activity\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.moderndata.ai\/2018\/12\/scale-azure-sql-using-adf-web-activity\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.moderndata.ai\/2018\/12\/scale-azure-sql-using-adf-web-activity\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.moderndata.ai\/"},{"@type":"ListItem","position":2,"name":"How To Scale Azure SQL Database In Azure Data Factory Using A Web Activity"}]},{"@type":"WebSite","@id":"https:\/\/www.moderndata.ai\/#website","url":"https:\/\/www.moderndata.ai\/","name":"Modern Data &amp; AI","description":"A blog on Power BI &amp; Azure Data Platform","publisher":{"@id":"https:\/\/www.moderndata.ai\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.moderndata.ai\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.moderndata.ai\/#organization","name":"Modern Data &amp; AI","url":"https:\/\/www.moderndata.ai\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.moderndata.ai\/#\/schema\/logo\/image\/","url":"https:\/\/www.moderndata.ai\/wp-content\/uploads\/2021\/11\/mod-e1636956448571.png","contentUrl":"https:\/\/www.moderndata.ai\/wp-content\/uploads\/2021\/11\/mod-e1636956448571.png","width":403,"height":80,"caption":"Modern Data &amp; AI"},"image":{"@id":"https:\/\/www.moderndata.ai\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.moderndata.ai\/#\/schema\/person\/662f0589643bb4205482d128fac88ddc","name":"Dave Ruijter","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.moderndata.ai\/#\/schema\/person\/image\/","url":"https:\/\/www.moderndata.ai\/wp-content\/uploads\/2023\/02\/Dave-Ruijter-grey-150x150.jpg","contentUrl":"https:\/\/www.moderndata.ai\/wp-content\/uploads\/2023\/02\/Dave-Ruijter-grey-150x150.jpg","caption":"Dave Ruijter"},"description":"Dave is a hands-on solution and platform architect that operationalizes data-driven strategies of organizations. Leveraging the full potential of the Azure Data Platform and he Power Platform (with a focus on Power BI). He brings a vast amount of consultancy experience to the table and is always eager to take things to the next level. Dave has received the Microsoft MVP Award twice for his deep knowledge of Microsoft products and services and community leadership.","sameAs":["https:\/\/moderndata.ai\/","https:\/\/linkedin.com\/in\/daveruijter","https:\/\/twitter.com\/DaveRuijter"],"url":"https:\/\/www.moderndata.ai\/author\/daveruijter\/"}]}},"jetpack_featured_media_url":"https:\/\/www.moderndata.ai\/wp-content\/uploads\/2018\/12\/2018-12-20-21_13_52-Azure-Data-Factory-1-e1545340925183.png","post_mailing_queue_ids":[],"_links":{"self":[{"href":"https:\/\/www.moderndata.ai\/wp-json\/wp\/v2\/posts\/223"}],"collection":[{"href":"https:\/\/www.moderndata.ai\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.moderndata.ai\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.moderndata.ai\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.moderndata.ai\/wp-json\/wp\/v2\/comments?post=223"}],"version-history":[{"count":24,"href":"https:\/\/www.moderndata.ai\/wp-json\/wp\/v2\/posts\/223\/revisions"}],"predecessor-version":[{"id":439,"href":"https:\/\/www.moderndata.ai\/wp-json\/wp\/v2\/posts\/223\/revisions\/439"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.moderndata.ai\/wp-json\/wp\/v2\/media\/235"}],"wp:attachment":[{"href":"https:\/\/www.moderndata.ai\/wp-json\/wp\/v2\/media?parent=223"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.moderndata.ai\/wp-json\/wp\/v2\/categories?post=223"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.moderndata.ai\/wp-json\/wp\/v2\/tags?post=223"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}