In this screencast, Jeff Potts demonstrates a quick, simple integration between Open Atrium (an open source framework for intranets and other collaborative team environments based on Drupal) and Alfresco, based on the CMIS standard.
Do you see this integration being useful in your corporate intranet? What other features would you like to see added? Let us know in the comments.