one datawarehouse to rule them all?

Not now, but maybe some day.  ConfigMgr 2007 doesn't have a datawarehouse, OpsMgr has one but it's different than the one in Service Manager.  Very different.  ConfigMgr does not currently have a DW but there has been talk of having all 3 products utilize a common datawarehouse in the future. We will see.