Have you worked on a significant data or application integration project? I'm interested in hearing what worked for you and what didn't and how that affected the project both during and after implementation (i.e. during ongoing operation, maintenance and expansion).

In addition to these lessons learned, please describe the project by including a quick overview of:

• The data sources and targets. Specifics are not necessary, but I'd like to know general technology categories e.g. RDBMS table, application accessed via a proprietary socket protocol, web service, reporting tool.
• The overall architecture of the project as related to data flows.
• Different human roles in the project (was this all done by one engineer? Did it include analysts with a particular expertise?)
• Any third-party products utilized, commercial or open source.