Hi
For this kind of data integration request, I am sure the existing components or a combination of components can achieve it, I do not think all the functions are integrated into one component up to complete is a good thing, in Talend, no a component has both input schema and output schema.
Shong