{"id":5816,"date":"2023-05-12T13:18:47","date_gmt":"2023-05-12T11:18:47","guid":{"rendered":"https:\/\/devstage.bix-consulting.com\/?p=5816"},"modified":"2024-01-03T10:12:34","modified_gmt":"2024-01-03T09:12:34","slug":"azure-cdw-basisworkshop-infrastruktur","status":"publish","type":"post","link":"https:\/\/teststage.bix-consulting.com\/en\/azure-cdw-basisworkshop-infrastruktur\/","title":{"rendered":"Azure CDW -<br> Basic workshop infrastructure"},"content":{"rendered":"<p>[et_pb_section fb_built=&#8220;1&#8243; admin_label=&#8220;Einleitung&#8220; _builder_version=&#8220;4.20.2&#8243; _module_preset=&#8220;default&#8220; custom_padding=&#8220;0px||||false|false&#8220; collapsed=&#8220;off&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;post_content&#8220;][et_pb_row column_structure=&#8220;1_2,1_2&#8243; make_equal=&#8220;on&#8220; _builder_version=&#8220;4.20.2&#8243; _module_preset=&#8220;default&#8220; background_color=&#8220;#f4f4f4&#8243; width=&#8220;100%&#8220; width_phone=&#8220;100%&#8220; width_last_edited=&#8220;off|tablet&#8220; custom_margin=&#8220;||||false|false&#8220; custom_padding=&#8220;20px|20px|20px|20px|false|false&#8220; border_radii=&#8220;on|30px|30px|30px|30px&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;post_content&#8220;][et_pb_column type=&#8220;1_2&#8243; _builder_version=&#8220;4.18.0&#8243; _module_preset=&#8220;default&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;post_content&#8220;][et_pb_text admin_label=&#8220;Einf\u00fchrungstext&#8220; _builder_version=&#8220;4.20.4&#8243; _module_preset=&#8220;default&#8220; custom_padding=&#8220;10px|20px||20px|false|false&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;post_content&#8220;]<\/p>\n<h2>WORKSHOP-PROPOSAL (1 PD)<\/h2>\n<p>Basic workshop for the infrastructure setup of your own cloud data warehouse in the Microsoft Azure Platform with DataFactory and Databricks. Which components do I need, how do I configure an operational test environment and which features does Azure offer me to secure my data.<\/p>\n<p>One of the first things you need for your upcoming CDW project is a running test system and employees who are able to administer and successively expand it. Benefit now from a workshop in your system landscape and get a jumpstart.<\/p>\n<p>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8220;1_2&#8243; module_class=&#8220;vertikal-zentrieren&#8220; _builder_version=&#8220;4.20.2&#8243; _module_preset=&#8220;default&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;post_content&#8220;][et_pb_post_title title=&#8220;off&#8220; meta=&#8220;off&#8220; force_fullwidth=&#8220;off&#8220; _builder_version=&#8220;4.20.2&#8243; _module_preset=&#8220;default&#8220; custom_padding=&#8220;|20px||20px|false|false&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;post_content&#8220;][\/et_pb_post_title][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8220;1&#8243; _builder_version=&#8220;4.20.2&#8243; _module_preset=&#8220;default&#8220; custom_margin=&#8220;||||false|false&#8220; custom_padding=&#8220;0px||||false|false&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;post_content&#8220;][et_pb_row column_structure=&#8220;3_5,2_5&#8243; make_equal=&#8220;on&#8220; _builder_version=&#8220;4.20.4&#8243; _module_preset=&#8220;default&#8220; width=&#8220;100%&#8220; custom_margin=&#8220;||||false|false&#8220; custom_padding=&#8220;20px|20px|20px|20px|false|false&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;post_content&#8220;][et_pb_column type=&#8220;3_5&#8243; _builder_version=&#8220;4.20.2&#8243; _module_preset=&#8220;default&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;post_content&#8220;][et_pb_text _builder_version=&#8220;4.20.4&#8243; _module_preset=&#8220;default&#8220; header_2_text_align=&#8220;left&#8220; header_2_text_color=&#8220;#F18900&#8243; header_2_font_size=&#8220;24px&#8220; header_4_font=&#8220;|||on|||||&#8220; custom_margin=&#8220;||||false|false&#8220; custom_padding=&#8220;10px|20px|0px|20px|false|false&#8220; hover_enabled=&#8220;0&#8243; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;post_content&#8220; sticky_enabled=&#8220;0&#8243;]<\/p>\n<h2>Our workshop includes<\/h2>\n<h6>Introduction<\/h6>\n<h6>Which infrastructure services do I need to setup my CDW?<\/h6>\n<ul style=\"margin-left: 1.5em;\">\n<li>Resource Groups<\/li>\n<li>Virtual Network<\/li>\n<li>Storage Account<\/li>\n<li>Key-Vault<\/li>\n<\/ul>\n<h6>Main components<\/h6>\n<ul style=\"margin-left: 1.5em;\">\n<li>Azure Data Factory<\/li>\n<ul style=\"list-style-type: circle;\">\n<li>Create Service<\/li>\n<li>Setup linkedServices (Storage, KeyVault, Source Data)<\/li>\n<li>Integration Runtime (On-Premises Connector)<\/li>\n<\/ul>\n<li style=\"margin-top: -1em;\">Databricks<\/li>\n<ul style=\"list-style-type: circle;\">\n<li>Create Service<\/li>\n<li>Basic introduction to user, group and permission handling<\/li>\n<li>Connect Azure Storage<\/li>\n<li>Create linkedService in Azure Data Factory<\/li>\n<\/ul>\n<\/ul>\n<ul style=\"margin-left: 1.5em;\"><\/ul>\n<p>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8220;2_5&#8243; module_class=&#8220;vertikal-zentrieren&#8220; _builder_version=&#8220;4.20.4&#8243; _module_preset=&#8220;default&#8220; custom_padding=&#8220;||20px||false|false&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;post_content&#8220;][et_pb_image src=&#8220;https:\/\/teststage.bix-consulting.com\/wp-content\/uploads\/2023\/05\/CDW-Struktur_klein.png&#8220; title_text=&#8220;CDW Struktur_klein&#8220; force_fullwidth=&#8220;on&#8220; _builder_version=&#8220;4.20.4&#8243; _module_preset=&#8220;default&#8220; transform_scale=&#8220;130%|130%&#8220; transform_scale_tablet=&#8220;100%|100%&#8220; transform_scale_phone=&#8220;100%|100%&#8220; transform_scale_last_edited=&#8220;on|desktop&#8220; transform_translate=&#8220;-40px|0px&#8220; transform_translate_tablet=&#8220;0px|0px&#8220; transform_translate_phone=&#8220;0px|0px&#8220; transform_translate_last_edited=&#8220;on|desktop&#8220; transform_translate_linked=&#8220;off&#8220; transform_rotate_tablet=&#8220;&#8220; transform_rotate_phone=&#8220;&#8220; transform_rotate_last_edited=&#8220;on|tablet&#8220; transform_skew_tablet=&#8220;&#8220; transform_skew_phone=&#8220;&#8220; transform_skew_last_edited=&#8220;on|tablet&#8220; transform_origin_tablet=&#8220;&#8220; transform_origin_phone=&#8220;&#8220; transform_origin_last_edited=&#8220;on|tablet&#8220; transform_styles_last_edited=&#8220;on|desktop&#8220; custom_margin=&#8220;||||false|false&#8220; transform_styles_tablet=&#8220;&#8220; transform_styles_phone=&#8220;&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;post_content&#8220;][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8220;4.20.4&#8243; _module_preset=&#8220;default&#8220; width=&#8220;90%&#8220; custom_margin=&#8220;-15px||||false|false&#8220; custom_padding=&#8220;0px||||false|false&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;post_content&#8220;][et_pb_column type=&#8220;4_4&#8243; _builder_version=&#8220;4.20.4&#8243; _module_preset=&#8220;default&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;post_content&#8220;][et_pb_text _builder_version=&#8220;4.20.4&#8243; _module_preset=&#8220;default&#8220; custom_margin=&#8220;-38px||||false|false&#8220; custom_padding=&#8220;0px||||false|false&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;post_content&#8220;]<\/p>\n<h6 style=\"margin-top: -1em;\">Demo Workflow (Setup a simple Pipeline to test your CDW)<\/h6>\n<h6>Summary<\/h6>\n<ul style=\"margin-left: 1.5em;\">\n<li>Infrastructure review<\/li>\n<li>Further thoughts<\/li>\n<ul style=\"list-style-type: circle;\">\n<li>Code and resource management with version control (DevOps)<\/li>\n<li>Continuous Integration \/ Continuous Deployment<\/li>\n<li>Databricks Unity Catalog<\/li>\n<\/ul>\n<li style=\"margin-top: -1em;\">Questions &amp; Answers<\/li>\n<\/ul>\n<h2>Results<\/h2>\n<ul style=\"margin-left: 1.5em;\">\n<li>A running test system in your own Azure infrastructure<\/li>\n<li>The documentation and guidance of the completed tasks<\/li>\n<li>The enablement of your own employees to manage and extend the individual system services<\/li>\n<\/ul>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8220;1&#8243; admin_label=&#8220;Haupttext&#8220; _builder_version=&#8220;4.20.2&#8243; _module_preset=&#8220;default&#8220; custom_margin=&#8220;||||false|false&#8220; custom_padding=&#8220;0px||||false|false&#8220; collapsed=&#8220;off&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;post_content&#8220;][et_pb_row column_structure=&#8220;1_3,2_3&#8243; _builder_version=&#8220;4.20.2&#8243; _module_preset=&#8220;default&#8220; background_color=&#8220;#f4f4f4&#8243; width=&#8220;100%&#8220; custom_padding=&#8220;|||20px|false|false&#8220; border_radii=&#8220;on|30px|30px|30px|30px&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;post_content&#8220;][et_pb_column type=&#8220;1_3&#8243; _builder_version=&#8220;4.20.2&#8243; _module_preset=&#8220;default&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;post_content&#8220;][et_pb_blurb title=&#8220; \u20ac 1.495,00&#8243; _builder_version=&#8220;4.20.2&#8243; _module_preset=&#8220;default&#8220; header_font=&#8220;|700|||||||&#8220; header_text_align=&#8220;left&#8220; header_text_color=&#8220;#F18900&#8243; header_font_size=&#8220;27px&#8220; header_line_height=&#8220;1.3em&#8220; image_icon_custom_padding_tablet=&#8220;|||60px|false|false&#8220; image_icon_custom_padding_phone=&#8220;|||20px|false|false&#8220; image_icon_custom_padding_last_edited=&#8220;off|desktop&#8220; custom_padding=&#8220;5px|20px||20px|false|false&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;post_content&#8220;][\/et_pb_blurb][\/et_pb_column][et_pb_column type=&#8220;2_3&#8243; _builder_version=&#8220;4.20.2&#8243; _module_preset=&#8220;default&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;post_content&#8220;][et_pb_text _builder_version=&#8220;4.20.2&#8243; _module_preset=&#8220;default&#8220; custom_margin=&#8220;|||-173px|false|false&#8220; custom_margin_tablet=&#8220;|||40px|false|false&#8220; custom_margin_phone=&#8220;|20px||20px|false|false&#8220; custom_margin_last_edited=&#8220;on|tablet&#8220; custom_padding=&#8220;16px||||false|false&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;post_content&#8220;]<\/p>\n<p><span>net. plus poss. travel expenses according to expense<\/span><\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8220;1&#8243; admin_label=&#8220;Haupttext&#8220; _builder_version=&#8220;4.20.2&#8243; _module_preset=&#8220;default&#8220; custom_padding=&#8220;0px||||false|false&#8220; collapsed=&#8220;off&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;post_content&#8220;][et_pb_row column_structure=&#8220;3_4,1_4&#8243; make_equal=&#8220;on&#8220; admin_label=&#8220;Angebot Abschlusstext&#8220; _builder_version=&#8220;4.20.2&#8243; _module_preset=&#8220;default&#8220; background_color=&#8220;#f4f4f4&#8243; width=&#8220;100%&#8220; width_phone=&#8220;100%&#8220; width_last_edited=&#8220;off|desktop&#8220; custom_margin=&#8220;||||false|false&#8220; custom_padding=&#8220;20px|20px|20px|20px|false|false&#8220; border_radii=&#8220;on|30px|30px|30px|30px&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;post_content&#8220;][et_pb_column type=&#8220;3_4&#8243; _builder_version=&#8220;4.19.5&#8243; _module_preset=&#8220;default&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;post_content&#8220;][et_pb_text _builder_version=&#8220;4.20.2&#8243; _module_preset=&#8220;default&#8220; custom_padding=&#8220;|20px||20px|false|false&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;post_content&#8220;]<\/p>\n<p>We would be pleased if this offer meets your requirements.<br \/>However, if this is the case and you would like to make any adjustments, please feel free to contact us at any time.<br \/>We would be happy to organize your individual workshop together with you.<\/p>\n<p>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8220;1_4&#8243; module_class=&#8220;vertikal-zentrieren&#8220; _builder_version=&#8220;4.20.2&#8243; _module_preset=&#8220;default&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;post_content&#8220;][et_pb_icon font_icon=&#8220;&#xe092;||divi||400&#8243; icon_width=&#8220;50px&#8220; url=&#8220;https:\/\/teststage.bix-consulting.com\/wp-content\/uploads\/2023\/05\/SO_Cloud_Infrastructure_DE.pdf&#8220; url_new_window=&#8220;on&#8220; _builder_version=&#8220;4.20.4&#8243; _module_preset=&#8220;default&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;post_content&#8220;][\/et_pb_icon][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>","protected":false},"excerpt":{"rendered":"<p>WORKSHOP-PROPOSAL (1 PD)<\/p>\n<p>You are also facing the transition to the cloud?<\/p>","protected":false},"author":1,"featured_media":5818,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","_lmt_disableupdate":"","_lmt_disable":"","footnotes":""},"categories":[236,242],"tags":[],"modified_by":"admin","_links":{"self":[{"href":"https:\/\/teststage.bix-consulting.com\/en\/wp-json\/wp\/v2\/posts\/5816"}],"collection":[{"href":"https:\/\/teststage.bix-consulting.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/teststage.bix-consulting.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/teststage.bix-consulting.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/teststage.bix-consulting.com\/en\/wp-json\/wp\/v2\/comments?post=5816"}],"version-history":[{"count":0,"href":"https:\/\/teststage.bix-consulting.com\/en\/wp-json\/wp\/v2\/posts\/5816\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/teststage.bix-consulting.com\/en\/wp-json\/wp\/v2\/media\/5818"}],"wp:attachment":[{"href":"https:\/\/teststage.bix-consulting.com\/en\/wp-json\/wp\/v2\/media?parent=5816"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/teststage.bix-consulting.com\/en\/wp-json\/wp\/v2\/categories?post=5816"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/teststage.bix-consulting.com\/en\/wp-json\/wp\/v2\/tags?post=5816"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}