Dimodelo Data Warehouse Studio adds batch monitoring and analysis

ByAdam Gilmore Updated on

The following enhancements have been made in Dimodelo Data Warehouse Studio 2015 2.9:

  • Monitor and Analyse your ETL batches. Dimodelo now writes its ETL batch execution log to an SQL Server database. New PowerBI dashboards have been created to help you monitor and analyse your ETL batches.

  • Support for ODBC Sources. Connect to just about any data (e.g. SharePoint, Dynamics, Salesforce, Quickbooks, Hadoop etc etc ) using ODBC drivers.
  • The ability to right click and generate for a single Staging/Dimension or Fact table has been added, further improving the productivity benefits of Dimodelo Data Warehouse Studio.
  • Various small improvement, fixes and stability changes.

You can download a free 30 day trial here.

Adam Gilmore

Adam Gilmore is a Data Architect with 20 years' experience in the Data field. He writes for dimodelo.com and develops courses covering Data Analysis to Data Architecture.

Similar Posts

| | | | | | | |

A Dimodelo Data Warehouse Automation Case Study Podcast

ByMike Rabinovici

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…

Build a Data Warehouse from Freshbooks (SaaS) data

ByAdam Gilmore

[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” custom_margin=”0px|||”] This video demonstrates using Dimodelo Data Warehouse Studio (a data warehouse automation tool) to generate a data warehouse using Freshbooks as a source. Freshbooks is a SaaS provider for timesheets and invoicing. Using ODBC drivers (like those provided by CData) Dimodelo Data Warehouse…

Data Warehouse and Business Intelligence Concepts – Simplified

ByAdam Gilmore

10 Page Guide – Free PDF Download. Download our free PDF Guide to Data Warehousing and Business Intelligence Concepts. The Guide covers Basic concepts of Data Warehousing including: Facts, Dimensions, Star Schemas and Data Warehouse Design. Definitions – Business Intelligence vs Data Warehouse vs Data Mining etc. Extract Transform and Load (ETL). OLAP and Cubes….

Range Lookups in the SSIS Lookup Transformation

ByAdam Gilmore

Let’s say, in an SSIS Data Flow which is processing invoices, you wanted to match an invoice to an event based on the date of the invoice falling between the start and end date of the event. To achieve this in a SSIS Lookup Transformation, you need to use advanced configuration. The configuration steps required follow: On…

Understanding Visual Studio 2015 licencing for BI developers

ByAdam Gilmore

The latest version of SQL Server Data Tools (SSDT), unlike previous versions can be installed either standalone or as a plug-in to existing an Community, Professional or Enterprise version of Visual Studio 2015. This guide helps you understand if you need/want to licence Visual Studio 2015 with SSDT for Visual Studio 2015. To set up a…

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.