How to guide for using Dimodelo architect to Design, Generate and Deploy your Data Warehouse. Includes project configuration and advanced design techniques.
[/et_pb_blurb][/et_pb_column][et_pb_column type=”1_3″][et_pb_blurb admin_label=”Blurb” title=”Managing and Monitoring ETL Execution” url=”https://www.dimodelo.com/downloads/Managing_and_Monitoring_ETL_Execution.pdf” url_new_window=”on” use_icon=”off” icon_color=”#2EA3F2″ use_circle=”off” circle_color=”#2EA3F2″ use_circle_border=”off” circle_border_color=”#2EA3F2″ image=”https://www.dimodelo.com/wp-content/uploads/Managing-and-Monitoring-ETL-Batches.png” icon_placement=”top” animation=”off” background_layout=”light” text_orientation=”center” use_icon_font_size=”off” header_font_size=”18″ body_font_size=”14″ use_border_color=”off” border_color=”#ffffff” border_style=”solid”]How to configure and run your ETL batches through the Dimodelo Management Console on your servers, and through Dimodelo Data Warehouse Studio. The document also explains the contents of the Batch log database.
[/et_pb_blurb][/et_pb_column][et_pb_column type=”1_3″][et_pb_blurb admin_label=”Blurb” title=”Installation Guide” url=”https://www.dimodelo.com/downloads/Installation_Guide_Dimodelo_Architect_and_Management_Console.pdf” url_new_window=”on” use_icon=”off” icon_color=”#2EA3F2″ use_circle=”off” circle_color=”#2EA3F2″ use_circle_border=”off” circle_border_color=”#2EA3F2″ image=”https://www.dimodelo.com/wp-content/uploads/Installation-Guide.png” icon_placement=”top” animation=”off” background_layout=”light” text_orientation=”center” use_icon_font_size=”off” header_font_size=”18″ body_font_size=”14″ use_border_color=”off” border_color=”#ffffff” border_style=”solid”]Installation Guide for Dimodelo Data Warehouse Studio and Management Console.
[/et_pb_blurb][/et_pb_column][/et_pb_row][et_pb_row admin_label=”row”][et_pb_column type=”1_4″][et_pb_sidebar admin_label=”Sidebar” orientation=”left” area=”et_pb_widget_area_1″ background_layout=”light”] [/et_pb_sidebar][/et_pb_column][et_pb_column type=”3_4″][et_pb_text admin_label=”Text” background_layout=”light” text_orientation=”left”]Overview
[/et_pb_text][et_pb_text admin_label=”Text” background_layout=”light” text_orientation=”left”]Dimodelo Data Warehouse Studio is a Data Warehouse Automation tool. Using Dimodelo Data Warehouse Studio a developer designs a Data Warehouse, and then generates the necessary SSIS Packages for ETL, and DDL to create/maintain the Data Warehouse and Staging databases.
Dimodelo Data Warehouse Studio should be familiar to Microsoft developers because it is built as an addition to Visual Studio, the Microsoft Development Environment.
The first step in developing a Data Warehouse through Dimodelo Data Warehouse Studio is to create a new Dimodelo Data Warehouse Studio Project. Once the project is created the next step is define one or more Connection Managers for the Source Systems of the Data Warehouse. For each Connection Manager it is necessary to add additional information in a Source System record.
Developers can now start to design the Data Warehouse. A quick start method is to use the Star Schema Wizard to quickly identify Fact tables in the Source Systems, and define Dimensions for those Fact tables. However a developer may choose to just jump straight in, and start designing Staging tables, Dimensions, and Fact tables.
Once a set of Staging tables, Dimension and Facts are defined, the developer can Generate the code. Generation creates both the DDL (T-SQL) to create/maintain the Staging and Data Warehouse databases, it also generates the SSIS packages that implement the ETL. Generated code can then be deployed to a local or remote server.
Dimodelo Data Warehouse Studio allows the user to Run an ETL batch, through either the Dimodelo Data Warehouse Studio interface, or via Dimodelo Management Console on a server. Using this method, a Developer can iterate through a series of releases very quickly, continually refining the design. A Data Warehouse built through Dimodelo Data Warehouse Studio is very flexible. It’s just a matter of changing the design and re-generating. Once you are more familiar with Dimodelo Data Warehouse Studio you will want to start working with more sophisticated functionality. This includes:
- Supporting multiple environments through Dimodelo Data Warehouse Studio Project Configuration.
- Defining ETL Batch Workflows.
- Deploying to Servers and Scheduling ETL Batches.
- Advance design techniques including support for:
- Conformed Dimensions and communication with other Data Warehouses.
- Dimensions with Smart Keys.
- Many to Many Bridge patterns.
- Derived Staging tables.
- Incorporating Custom DDL and SSIS packages into the project.