[beepbeep]

There are multiple products that can do this. Currently, I have been forced to use lots of IBM Datastage (mucho $$$) but have also had very good experience with Ipswitch MoveIt (less costly).
This is all basic ETL meat and potatoes that can be cobbled together almost for free (if you know your stuff) or be mega-expensive (if you opt for "brand names" and let consultants do it for you). I consider MoveIt a sweet spot between expensive/cumbersome for average guy. Quick and cheap example: Let AT trigger curl, download XML to a folder and then schedule SQL to ingest XML, transform, BCP back to a file and use AT again to upload it wherever you want.