Via Chris Ross (SCSM.US) I found this great Service Manager diagram which was posted recently by – who else than Mr. Service Manager himself Travis Wright – which provides you an ease overview of the Service Manager data warehouse architecture.
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.
The diagram can be download here