Dimodelo Solutions is proud to announce the release of version 2.15 of Dimodelo Data Warehouse Studio, its data warehouse automation tool for the Microsoft data platform. In this release we have added support for the Microsoft APS platform and SQL Server 2017. We have also redesigned our data management architecture from the ground up, introducing…
In this episode I speak with James Rowland-Jones (JRJ), Principal Program Manager for Microsoft. He is passionate about delivering highly scalable solutions that are creative, simple and elegant in their design. James specializes in scale out data solutions such as Azure SQL Data Warehouse, Microsoft Analytics Platform System and Hadoop. JRJ is a keen advocate…
Talking Analytics Platform Services with Ashley Furniture’s Data Architect Phil Haddad, and Microsoft’s Principal Program Manager in the Azure SQL Data Warehouse team, Matt Usher. In this podcast we discuss: Refractoring an exising data warehouse Automating data warehouse development in an enterprise environment with 700 applications Migrating to Azure Data Warehouse from PDW/APS The role Microsoft Partners…
In this episode, it is my pleasure to speak with James Serra, Data Platform Solution Architect and Data Warehouse Evangelist at Microsoft. He is a thought leader in data warehousing and data management with over 25 years of experience in data modeling, data governance, and development methodologies. James is also a popular and prolific blogger…
In this episode, it is my pleasure to speak with John Johansen, Senior Vice President, Consulting Services Strategy & Innovation at Majesco, a leading provider of insurance solutions and services. He is a highly skilled consultant and data architect known for his ability to help insurers build effective data organizations. He is an entrepreneur who exited…
Join me for an informative discussion with Hans Michiels, founder and moderator of the Data Warehouse Automation Guide – DataWarehouseAutomation.Guide. Hans is an independent Business Intelligence and Data Warehouse consultant using Microsoft technology, working in the Netherlands. He has a special interest in Data Warehouse Automation and Metadata solutions. You can connect with Hans…
Join me for an enlightening conversation with Dr. Barry Devlin, regarded as one of the world’s leading authorities on business insight and data warehousing. He was responsible for the definition of IBM’s data warehouse architecture in the mid-1980s which in our view makes him the “Godfather” of the data warehouse . He is now founder…
In this episode, it is my pleasure to speak with Dr. Claudia Imhoff, a real rock star in our corner of the technology universe. She not only has the technical chops and but also an in-depth understanding of the business landscape. In 1992 she founded her consulting company, Intelligent Solutions, Inc., and in 2006 she…
[et_pb_section admin_label=”section”][et_pb_row admin_label=”row”][et_pb_column type=”4_4″][et_pb_text admin_label=”Text” background_layout=”light” text_orientation=”left” text_font_size=”14″ use_border_color=”off” border_color=”#ffffff” border_style=”solid”] Dimodelo Data Warehouse Studio now allows you to extract only changed data from your source system, reducing load on your source systems and overall ETL duration. I.e. To do change data capture (CDC) at the source. Dimodelo Data Warehouse Studio now includes a managed…
In this tutorial you will learn how to use Dimodelo Data Warehouse Studio to:
Create a new Data Warehouse project.
Create a connection to a Source System.
Use the Wizard to generate the Meta Data for a Data Warehouse and its Extract, Transform and Load processes (ETL).
Generate the code to create the Data Warehouse and Staging databases, and the ETL to move data from the source through to the Data Warehouse.
Deploy the code to the Server.
Execute the ETL batch.
