Dimodelo Data Warehouse Studio 2.15 – Whats New

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 a persistent layer to capture the history of change in your source systems.

In this release we have added the following features:

• Introduced a Persistent Layer to keep the history of all changes in your source systems. Read about the top 5 reasons you need a persistent layer in your data warehouse.
• Introduction of a Transform layer with virtual and materialized views to implement complex ETL/ELT Logic. Materialized views improve Dimension and Fact loading performance in some circumstances.
• Incremental ELT at all layers of the Data Warehouse. Redesigned ETL to takes advantage of the Persistent layer, improving performance through incremental ELT.
• Adaptive ELT. Dimodelo recognizes changes in your Dimensional design and reloads attributes and measures with full history where required.
• The ability to truncate and reload Dimensions and Facts with full history.
• Support for Microsoft Analytics Platform System (PDW).
• Support for SQL Server 2017.
• A new Extract pattern that uses change tracking in SQL Server database sources to identify change.
• Support for SQL Server Clustered Column stores.
• Improved batch logging and performance metrics. Many of our ELT tasks now capture detailed information of duration and row counts at each step of the process.
• Improved dependency tracking. Dimodelo can now derive Table and Column dependency, even through queries, back to source columns. This functionality will underpin our future lineage explorer.

If you would like a demo of the latest features of Dimodelo Data Warehouse Studio please contact us through our contact form.