For the past year now, I've been involved in a large Enterprise project to overhaul the integration infrastructure at my company. We're moving from a legacy based architecture where almost all integration is done point-to-point via custom programming (AS400/RPG) with no real middleware.
The new architecture is about as cutting edge as you can get these days. We've switched from custom programmed batch/ftp/etl to XML messaging that's mainly handled via configuration. We've implemented an Enterprise Service Bus (ESB), and XML database for persistence, JMS to guarantee message delivery, and RosettaNet's RNIF for supplier/customer B2B. All very interesting stuff to work with.
Two books I've found absolutely key to helping understand and architect the solution are Theory In Practice: Enterprise Service Bus (O'Reilly) by David A. Chappell and Enterprise Integration Patterns: Designing, Building, and Deploying Messaging Solutions (Addison Wesley) by Gregor Hohpe, Bobby Wolf, et. al. I simply can't say enough about these books. Regardless of the language(s) you work in, these two books offer clear and concise advice in a very practical format.
Although we haven't done any ColdFusion integration with our ESB yet, it is on the table for next year. I'll be sure to post more info as things progress.