This Visio diagram shows the various connectors, ETL jobs, and databases involved in the Service Manager data warehouse.  It also shows how each of the data sources is consumed by users using either SQL Reporting Services, the console, or Excel.  This diagram shows the architecture of the data warehouse for the System Center 2012/2012 SP1 version of Service Manager.