[rpedela]

I think the big assumption I was making, and probably should have said is that you have complete control over your own internal schema. The sort of control that allows you to modify that internal schema to incorporate a new vendor's schema regardless if it is more or less complex. If you don't have that control then yes it is a very difficult problem.