Simple mapping for multiple heterogeneous data-sources

The mapping of flat file-data seems to be a piece of cake: read data, read maps, validate data, map data, write data.

But what if you have to map data from various and very (very!) heterogeneous international sources such as exports from different SAP systems and various Web- and Excel-Tools into a single structure?