Microsoft Office SharePoint Server (MOSS) had some great ways to consume services, aggregate information and compose applications from a variety of sources. The article Resources for interoperability with SharePoint Server 2007 sets it out nicely.