Dimodelo Data Warehouse Modeler

A Dedicated Data Warehouse Modeling Tool

Dimodelo Data Warehouse Modeler is more than 7x faster at modelling and deploying data warehouse tables than an ordinary Visual Studio database project. 

  • Import Schema from Source Systems
  • Set management columns defaults.
  • Set storage defaults (Columnstore, Indexes, Schema etc)
  • One-click deployment

The only database modeling project that supports Azure Synapse Analytics.

Model

Quickly model your Data Warehouse and Staging databases.
Dimensions and Facts in your Data Warehouse
Staging, Persistent Staging and Transform tables in your Staging database. 
Video: Dimensions. Staging. Facts.

Deploy

Easily generate and deploy changes to SQL Server, Azure SQL Database or Azure Synapse Analytics.
Dimodelo’s sync routine faithfully deploys table, column, index and storage changes.

Import

Increase the speed and accuracy of schema development.
Import the schema of tables and columns from other source systems to define tables in the Data warehouse.
 

Standards

Standardize table design and have the standards applied automatically to each table.
Set standards for management columns, indexes, storage settings, surrogate keys and foreign keys. 
 
Video: Standards.

Portability

Accelerate the migration from one data platform to another.
Simply select the new data platform in an existing project and regenerate and redeploy.
Supports SQL Server, Azure SQL Database and Azure Synapse Analytics.


Azure Synapse Support

The only data warehouse project that supports Azure Synapse Analytics. 
Includes Azure Synapse properties like Distribution with recommended defaults. 
Generates Synapse syntax (Like CTAS) to implement schema changes.

Source Control

Multiple developers can edit the project and use source control like Git/Azure DevOps to manage versions and changes.
Automate deployment through Azure DevOps pipelines (or equivalent).


Visual Studio

Integrated with Visual Studio.
Use the familiar Visual Studio environment to manage your Data Warehouse. Easy to learn and understand.
A Dimodelo Data Warehouse Modeler project is a custom Visual Studio project.


Model, Import, Generate and Deploy

Watch this 3-minute video to see how easy it is to model a Fact table using Dimodelo Data Warehouse Studio.

Watch as we import the schema from a source system, model the fact table with relationships to its dimensions, deploy to the server, make some changes and deploy again.

Change Standards across all tables

Apply mass changes across all tables. Update standard management columns and move all tables (of a particular type) to a different schema.

Watch this 3-minute video as we change the standard management columns for all Dimensions and move all Dimensions to a different schema.

Learn More …

Visit our free online training to learn more about Dimodelo Data Warehouse Modeler…