{"id":2665,"date":"2023-08-13T20:51:37","date_gmt":"2023-08-13T23:51:37","guid":{"rendered":"https:\/\/kondado.com.br\/blog\/?p=2665"},"modified":"2023-08-13T20:59:46","modified_gmt":"2023-08-13T23:59:46","slug":"como-criar-um-data-warehouse-sql-server-na-azure-azure-sql-database","status":"publish","type":"post","link":"https:\/\/kondado.com.br\/blog\/blog\/2023\/08\/13\/como-criar-um-data-warehouse-sql-server-na-azure-azure-sql-database\/","title":{"rendered":"Como criar um data warehouse SQL Server na Azure (Azure SQL Database)"},"content":{"rendered":"\n<p>No cen\u00e1rio atual orientado por dados, a capacidade de armazenar, gerenciar e acessar dados de forma eficiente \u00e9 fundamental. Seja voc\u00ea um profissional de dados experiente ou apenas um iniciante, a necessidade de uma solu\u00e7\u00e3o robusta e escal\u00e1vel de armazenamento de dados \u00e9 ineg\u00e1vel. Apresentamos nosso tutorial para ajud\u00e1-lo a come\u00e7ar com o Azure SQL Database como destino na Kondado.<\/p>\n\n\n\n<p>Ao final deste tutorial, voc\u00ea ter\u00e1 uma clara compreens\u00e3o de:<\/p>\n\n\n\n<ul><li>Instru\u00e7\u00f5es passo a passo para configurar seu banco de dados.<\/li><li>Instru\u00e7\u00f5es sobre como realizar a libera\u00e7\u00e3o de acesso em seu firewall para acesso aos servidores da Kondado.<\/li><\/ul>\n\n\n\n<p>O Azure SQL Database \u00e9 equivalente ao destino (e conector) Microsoft SQL Server da Kondado. Nos baseamos nestes artigos da Azure para <a href=\"https:\/\/learn.microsoft.com\/en-us\/azure\/azure-sql\/database\/single-database-create-quickstart?view=azuresql&amp;tabs=azure-portal\" target=\"_blank\" rel=\"noreferrer noopener\">criar um banco de dados<\/a> e <a href=\"https:\/\/learn.microsoft.com\/en-us\/azure\/azure-sql\/database\/firewall-create-server-level-portal-quickstart?view=azuresql\" target=\"_blank\" rel=\"noreferrer noopener\">liberar acesso em seu firewall<\/a>.<\/p>\n\n\n\n<h3><strong>1. Selecionando o tipo de banco de dados<\/strong><\/h3>\n\n\n\n<ul><li>Acesse a p\u00e1gina de cria\u00e7\u00e3o de bancos de dados: <a href=\"https:\/\/portal.azure.com\/#create\/Microsoft.AzureSQL\" data-type=\"URL\" data-id=\"https:\/\/portal.azure.com\/#create\/Microsoft.AzureSQL\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/portal.azure.com\/#create\/Microsoft.AzureSQL<\/a><\/li><li>No primeiro quadro, <strong>SQL databases<\/strong> selecione <strong>Create<\/strong><a href=\"https:\/\/learn.microsoft.com\/en-us\/azure\/azure-sql\/database\/media\/single-database-create-quickstart\/select-deployment.png?view=azuresql#lightbox\"><\/a><\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" width=\"1024\" height=\"341\" src=\"https:\/\/kondado.com.br\/blog\/wp-content\/uploads\/2023\/08\/select-deployment-1024x341.png\" alt=\"\" class=\"wp-image-2666\" srcset=\"https:\/\/kondado.com.br\/blog\/wp-content\/uploads\/2023\/08\/select-deployment-1024x341.png 1024w, https:\/\/kondado.com.br\/blog\/wp-content\/uploads\/2023\/08\/select-deployment-300x100.png 300w, https:\/\/kondado.com.br\/blog\/wp-content\/uploads\/2023\/08\/select-deployment-768x256.png 768w, https:\/\/kondado.com.br\/blog\/wp-content\/uploads\/2023\/08\/select-deployment-1536x512.png 1536w, https:\/\/kondado.com.br\/blog\/wp-content\/uploads\/2023\/08\/select-deployment-2048x682.png 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3><strong>2. Configura\u00e7\u00f5es b\u00e1sicas<\/strong><\/h3>\n\n\n\n<ul><li>Em <strong>Subscription<\/strong>, selecione a op\u00e7\u00e3o dispon\u00edvel<\/li><li>Em <strong>Resource group<\/strong>, clique em <strong>Create new<\/strong> e digite um nome para seu grupo de recursos, como por exemplo &#8220;new_rg&#8221;<\/li><\/ul>\n\n\n\n<h3><strong>3. Nome do banco de dados<\/strong><\/h3>\n\n\n\n<ul><li>Em <strong>Database name<\/strong>, escolha um nome para seu banco de dados, como por exemplo, &#8220;kondado&#8221;<\/li><\/ul>\n\n\n\n<h3><strong>4. Configura\u00e7\u00e3o do servidor<\/strong><\/h3>\n\n\n\n<ul><li>E, em <strong>Server<\/strong>, clique em <strong>Create new<\/strong><\/li><li>Na p\u00e1gina de configura\u00e7\u00e3o de seu servidor, voc\u00ea deve digitar em <strong>Server name<\/strong> um nome para ele. Este nome ir\u00e1 transformar-se em um endere\u00e7o, ent\u00e3o precisa ser \u00fanico. O endere\u00e7o criado ser\u00e1 <em><span style=\"text-decoration: underline;\">server_name<\/span>.database.windows.net<\/em>, onde <em><span style=\"text-decoration: underline;\">server_name<\/span><\/em> \u00e9 o valor que voc\u00ea preencheu neste passo<\/li><li>Ent\u00e3o, em <strong>Authentication<\/strong> &gt; <strong>Authentication method<\/strong> selecione <strong>Use SQL authentication<\/strong> e defina um nome de usu\u00e1rio em <strong>Server admin login<\/strong> e defina e repita uma senha para este usu\u00e1rio em <strong>Password<\/strong> e <strong>Confirm password<\/strong><\/li><li>Clique em <strong>OK<\/strong> ao final e voc\u00ea ser\u00e1 redirecionado para a p\u00e1gina de configura\u00e7\u00e3o de seu banco<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" src=\"https:\/\/kondado.com.br\/blog\/wp-content\/uploads\/2023\/08\/Screenshot-from-2023-08-13-18-50-58.png\" alt=\"\" class=\"wp-image-2668\" width=\"833\" height=\"972\" srcset=\"https:\/\/kondado.com.br\/blog\/wp-content\/uploads\/2023\/08\/Screenshot-from-2023-08-13-18-50-58.png 833w, https:\/\/kondado.com.br\/blog\/wp-content\/uploads\/2023\/08\/Screenshot-from-2023-08-13-18-50-58-257x300.png 257w, https:\/\/kondado.com.br\/blog\/wp-content\/uploads\/2023\/08\/Screenshot-from-2023-08-13-18-50-58-768x896.png 768w\" sizes=\"(max-width: 833px) 100vw, 833px\" \/><figcaption> <\/figcaption><\/figure>\n\n\n\n<h3><strong>5. Finalizando a configura\u00e7\u00e3o b\u00e1sica<\/strong><\/h3>\n\n\n\n<ul><li>De volta \u00e0 p\u00e1gina <strong>Basics<\/strong>, em <strong>Workload environment<\/strong> voc\u00ea pode selecionar <strong>Development <\/strong>para reduzir seus custos neste primeiro momento<\/li><li>Sua p\u00e1gina deve ser similar \u00e0 imagem abaixo. Clique no bot\u00e3o <strong>Next: Networking<\/strong> &gt; ao final para seguir para a configura\u00e7\u00e3o de rede<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" width=\"833\" height=\"972\" src=\"https:\/\/kondado.com.br\/blog\/wp-content\/uploads\/2023\/08\/Screenshot-from-2023-08-13-19-28-20.png\" alt=\"\" class=\"wp-image-2667\" srcset=\"https:\/\/kondado.com.br\/blog\/wp-content\/uploads\/2023\/08\/Screenshot-from-2023-08-13-19-28-20.png 833w, https:\/\/kondado.com.br\/blog\/wp-content\/uploads\/2023\/08\/Screenshot-from-2023-08-13-19-28-20-257x300.png 257w, https:\/\/kondado.com.br\/blog\/wp-content\/uploads\/2023\/08\/Screenshot-from-2023-08-13-19-28-20-768x896.png 768w\" sizes=\"(max-width: 833px) 100vw, 833px\" \/><\/figure>\n\n\n\n<h3><strong>6. Configura\u00e7\u00e3o de rede<\/strong><\/h3>\n\n\n\n<ul><li>Na p\u00e1gina <strong>Networking<\/strong>, em <strong>Connectivity method<\/strong> selecione <strong>Public endpoint<\/strong><\/li><li>Em <strong>Firewall rules<\/strong>, marque <strong>Yes<\/strong> para <strong>Allow Azure services and resources to access this server<\/strong> e <strong>Add current client IP address<\/strong><\/li><li>Ent\u00e3o, clique no bot\u00e3o ao final <strong>Review + create<\/strong><\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"833\" height=\"972\" src=\"https:\/\/kondado.com.br\/blog\/wp-content\/uploads\/2023\/08\/Screenshot-from-2023-08-13-19-29-18.png\" alt=\"\" class=\"wp-image-2669\" srcset=\"https:\/\/kondado.com.br\/blog\/wp-content\/uploads\/2023\/08\/Screenshot-from-2023-08-13-19-29-18.png 833w, https:\/\/kondado.com.br\/blog\/wp-content\/uploads\/2023\/08\/Screenshot-from-2023-08-13-19-29-18-257x300.png 257w, https:\/\/kondado.com.br\/blog\/wp-content\/uploads\/2023\/08\/Screenshot-from-2023-08-13-19-29-18-768x896.png 768w\" sizes=\"(max-width: 833px) 100vw, 833px\" \/><\/figure>\n\n\n\n<h3><strong>7. Finalizando cria\u00e7\u00e3o<\/strong><\/h3>\n\n\n\n<ul><li>Revise os dados de cria\u00e7\u00e3o e, ao final, clique em <strong>Create<\/strong><\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"833\" height=\"972\" src=\"https:\/\/kondado.com.br\/blog\/wp-content\/uploads\/2023\/08\/Screenshot-from-2023-08-13-19-33-19.png\" alt=\"\" class=\"wp-image-2671\" srcset=\"https:\/\/kondado.com.br\/blog\/wp-content\/uploads\/2023\/08\/Screenshot-from-2023-08-13-19-33-19.png 833w, https:\/\/kondado.com.br\/blog\/wp-content\/uploads\/2023\/08\/Screenshot-from-2023-08-13-19-33-19-257x300.png 257w, https:\/\/kondado.com.br\/blog\/wp-content\/uploads\/2023\/08\/Screenshot-from-2023-08-13-19-33-19-768x896.png 768w\" sizes=\"(max-width: 833px) 100vw, 833px\" \/><\/figure>\n\n\n\n<ul><li>Na pr\u00f3xima p\u00e1gina, aguarde a cria\u00e7\u00e3o do recurso<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" width=\"1024\" height=\"378\" src=\"https:\/\/kondado.com.br\/blog\/wp-content\/uploads\/2023\/08\/Screenshot-from-2023-08-13-19-34-09-1024x378.png\" alt=\"\" class=\"wp-image-2673\" srcset=\"https:\/\/kondado.com.br\/blog\/wp-content\/uploads\/2023\/08\/Screenshot-from-2023-08-13-19-34-09-1024x378.png 1024w, https:\/\/kondado.com.br\/blog\/wp-content\/uploads\/2023\/08\/Screenshot-from-2023-08-13-19-34-09-300x111.png 300w, https:\/\/kondado.com.br\/blog\/wp-content\/uploads\/2023\/08\/Screenshot-from-2023-08-13-19-34-09-768x283.png 768w, https:\/\/kondado.com.br\/blog\/wp-content\/uploads\/2023\/08\/Screenshot-from-2023-08-13-19-34-09.png 1500w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul><li>Ap\u00f3s finalizado, clique no bot\u00e3o <strong>Go to resource<\/strong><\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" width=\"1024\" height=\"378\" src=\"https:\/\/kondado.com.br\/blog\/wp-content\/uploads\/2023\/08\/Screenshot-from-2023-08-13-19-36-37-1024x378.png\" alt=\"\" class=\"wp-image-2674\" srcset=\"https:\/\/kondado.com.br\/blog\/wp-content\/uploads\/2023\/08\/Screenshot-from-2023-08-13-19-36-37-1024x378.png 1024w, https:\/\/kondado.com.br\/blog\/wp-content\/uploads\/2023\/08\/Screenshot-from-2023-08-13-19-36-37-300x111.png 300w, https:\/\/kondado.com.br\/blog\/wp-content\/uploads\/2023\/08\/Screenshot-from-2023-08-13-19-36-37-768x283.png 768w, https:\/\/kondado.com.br\/blog\/wp-content\/uploads\/2023\/08\/Screenshot-from-2023-08-13-19-36-37.png 1500w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3><strong>8. Libera\u00e7\u00e3o do firewall<\/strong><\/h3>\n\n\n\n<ul><li>Na p\u00e1gina do recurso, clique na aba <strong>Set server firewall<\/strong><\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" width=\"1024\" height=\"378\" src=\"https:\/\/kondado.com.br\/blog\/wp-content\/uploads\/2023\/08\/Screenshot-from-2023-08-13-19-37-02-1024x378.png\" alt=\"\" class=\"wp-image-2676\" srcset=\"https:\/\/kondado.com.br\/blog\/wp-content\/uploads\/2023\/08\/Screenshot-from-2023-08-13-19-37-02-1024x378.png 1024w, https:\/\/kondado.com.br\/blog\/wp-content\/uploads\/2023\/08\/Screenshot-from-2023-08-13-19-37-02-300x111.png 300w, https:\/\/kondado.com.br\/blog\/wp-content\/uploads\/2023\/08\/Screenshot-from-2023-08-13-19-37-02-768x283.png 768w, https:\/\/kondado.com.br\/blog\/wp-content\/uploads\/2023\/08\/Screenshot-from-2023-08-13-19-37-02.png 1500w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul><li>Em <strong>Public network access<\/strong>, selecione <strong>Selected networks<\/strong><\/li><li>Em <strong>Firewall rules<\/strong>, clique em <strong>+ Add a firewall rule<\/strong> e adicione todos os <a href=\"https:\/\/kondado.com.br\/wiki\/ips-kondado\" target=\"_blank\" rel=\"noreferrer noopener\">IPs da Kondado<\/a>, removendo o &#8220;\/32&#8221; e copiando para cada linha o valor de <strong>Start IP<\/strong> e <strong>End IP<\/strong><\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" width=\"1024\" height=\"826\" src=\"https:\/\/kondado.com.br\/blog\/wp-content\/uploads\/2023\/08\/Screenshot-from-2023-08-13-19-38-39-1-1024x826.png\" alt=\"\" class=\"wp-image-2678\" srcset=\"https:\/\/kondado.com.br\/blog\/wp-content\/uploads\/2023\/08\/Screenshot-from-2023-08-13-19-38-39-1-1024x826.png 1024w, https:\/\/kondado.com.br\/blog\/wp-content\/uploads\/2023\/08\/Screenshot-from-2023-08-13-19-38-39-1-300x242.png 300w, https:\/\/kondado.com.br\/blog\/wp-content\/uploads\/2023\/08\/Screenshot-from-2023-08-13-19-38-39-1-768x619.png 768w, https:\/\/kondado.com.br\/blog\/wp-content\/uploads\/2023\/08\/Screenshot-from-2023-08-13-19-38-39-1.png 1209w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul><li>Sua p\u00e1gina de libera\u00e7\u00e3o de firewall dever\u00e1 ficar similar \u00e0 abaixo. Ent\u00e3o, clique no bot\u00e3o <strong>Save<\/strong><\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" width=\"1024\" height=\"826\" src=\"https:\/\/kondado.com.br\/blog\/wp-content\/uploads\/2023\/08\/Screenshot-from-2023-08-13-19-40-01-1024x826.png\" alt=\"\" class=\"wp-image-2680\" srcset=\"https:\/\/kondado.com.br\/blog\/wp-content\/uploads\/2023\/08\/Screenshot-from-2023-08-13-19-40-01-1024x826.png 1024w, https:\/\/kondado.com.br\/blog\/wp-content\/uploads\/2023\/08\/Screenshot-from-2023-08-13-19-40-01-300x242.png 300w, https:\/\/kondado.com.br\/blog\/wp-content\/uploads\/2023\/08\/Screenshot-from-2023-08-13-19-40-01-768x619.png 768w, https:\/\/kondado.com.br\/blog\/wp-content\/uploads\/2023\/08\/Screenshot-from-2023-08-13-19-40-01.png 1209w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3><strong>9. Adicionando seu destino na Kondado<\/strong><\/h3>\n\n\n\n<ol><li>Acesse a plataforma da <a rel=\"noreferrer noopener\" href=\"https:\/\/app.kondado.com.br\/destinations\/new\/50\" data-type=\"URL\" data-id=\"https:\/\/app.kondado.com.br\/destinations\/new\/50\" target=\"_blank\">Kondado &gt; Destinos &gt; Novo destino &gt; Microsoft SQL Server<\/a><\/li><li>Em <strong>Endere\u00e7o<\/strong>, informe o valor do <strong>Server name<\/strong> gerado no passo 4 (no nosso exemplo, <em>kondado.database.windows.net<\/em>)<\/li><li>Em <strong>Porta<\/strong>, deixe <em>1433<\/em><\/li><li>Em <strong>Banco de dados<\/strong>, informe o valor de <strong>Database name<\/strong> criado no passo 3<\/li><li>Em <strong>Usu\u00e1rio<\/strong> e <strong>Senha<\/strong> informe os valores criados em <strong>Server admin login<\/strong> no passo 4<\/li><li>Agora basta salvar seu destino e testar sua conex\u00e3o<\/li><\/ol>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" width=\"576\" height=\"715\" src=\"https:\/\/kondado.com.br\/blog\/wp-content\/uploads\/2023\/08\/Screenshot-from-2023-08-13-19-48-11.png\" alt=\"\" class=\"wp-image-2682\" srcset=\"https:\/\/kondado.com.br\/blog\/wp-content\/uploads\/2023\/08\/Screenshot-from-2023-08-13-19-48-11.png 576w, https:\/\/kondado.com.br\/blog\/wp-content\/uploads\/2023\/08\/Screenshot-from-2023-08-13-19-48-11-242x300.png 242w\" sizes=\"(max-width: 576px) 100vw, 576px\" \/><\/figure><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Este artigo ensina a criar e configurar um banco de dados SQL Server na Azure, abordando desde a sele\u00e7\u00e3o at\u00e9 a libera\u00e7\u00e3o no firewall.<\/p>\n","protected":false},"author":1,"featured_media":2685,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[550,554,553,551,555,41,552,434],"_links":{"self":[{"href":"https:\/\/kondado.com.br\/blog\/wp-json\/wp\/v2\/posts\/2665"}],"collection":[{"href":"https:\/\/kondado.com.br\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kondado.com.br\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kondado.com.br\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kondado.com.br\/blog\/wp-json\/wp\/v2\/comments?post=2665"}],"version-history":[{"count":8,"href":"https:\/\/kondado.com.br\/blog\/wp-json\/wp\/v2\/posts\/2665\/revisions"}],"predecessor-version":[{"id":2687,"href":"https:\/\/kondado.com.br\/blog\/wp-json\/wp\/v2\/posts\/2665\/revisions\/2687"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kondado.com.br\/blog\/wp-json\/wp\/v2\/media\/2685"}],"wp:attachment":[{"href":"https:\/\/kondado.com.br\/blog\/wp-json\/wp\/v2\/media?parent=2665"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kondado.com.br\/blog\/wp-json\/wp\/v2\/categories?post=2665"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kondado.com.br\/blog\/wp-json\/wp\/v2\/tags?post=2665"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}