New Data Warehouse Architecture Diagram

New Data Warehouse Architecture Diagram

  • Comments 8
  • Likes

I just posted the data warehouse architecture diagram that I showed during my presentation at System Center Universe 2013 to the TechNet Gallery.  You can download it from here:


If you want to watch the presentation where I walk through the diagram and explain it you can watch the recording of my session on the System Center Universe site.


Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment
  • Thanks for sharing

  • Hi, Travis

    Thanks a lot for sharing.

    Would it be possible to place file in any previous Visio version as well?

    Thanks in advance,


  • Backwards compatible version would be much appreciated...

    Thank you!

  • very good...

    but difficult to understand. Give some explanation.

  • Please provide an old version of Visio format .vsd file for download.

  • What I would like to know is what is the best way to integrate all the System Center databases like shown in the diagram when there is a MAJOR issue with the Exchange 2010 MP. I have had to rebuild my SCSM DW from scratch TWICE now because little did I realize that when you add Operations Manager to Service Manager as a datasource, it will attempt to pull in all the MPs that SCOM has and it ALWAYS fails on the Exchange 2010 MP, which causes all processing on the DW to stop. All Sync jobs, all ETL jobs, all Cube jobs.

    As it stands right now, it is IMPOSSIBLE to have this level of integration in our environment, just because we happen to be using and monitoring Exchange 2010. This seems like a major problem that needs to be addressed before this data model can be used correctly.

  • @Marcel - I would suggest creating a support case with Microsoft to see about investigating fixing that issue.

  • Hello Travis,

    I´m creating some reports to take a look of the total real resolution time, when I say real I mean the time between the working hours of the SLO calendar or company calendar. There is a view called "incidentestatusdurationfactvw" that has a row named "TotalTimeMeasure" that field store the time in minutes for every incident state but the time calculated is base on 7x24 and not on the SLO calendar.

    do you know if there is any table that has the total real time base on the company calendar and not on the 7x24?

    as example:

    Working hours = 10 per day between 8AM and 6PM Monday to Friday

    New Incident Registered at 5:PM on Friday

    Incident Resolved  next Monday at 9AM

    Real resolution time should  be: 120 minutes ( Total Real Active time 1hour on Friday and 1 hour on Monday )

    Time store on DWDataMart incidentestatusdurationfactvw = 3840 minutes  ( Total time between Friday to Monday including non-working days Sat-Sun.)