Teiid can help you configure the systems the way you have shown, however you would have write the view layer with Teiid provided tools to define the behavior. There is nothing automatically happening, you would have to manually define them. The source system can be relational database or web-service it depends upon your usecase, and you can use any type of source systems.
By the way were you not doing usecase already with web-services for which we have been answering questions? I am confused as what is new you are bringing to this thread? If I am misinterpreting something please let me know.
Thanks for your patience.
We have tried the Web-Service. This problem is related to multi-systems instead of Web-Service connector.
Our current solution for multi-systems is to write the following procedures in every "base table":
if(data from system1)
--(every system has its own schemas)
else if(data from sytem2)
This solution means if we want to add a new third-party system, we have to change every "base table" to add the "else if" clause. It is bothering. So we ask this question here.
Please see https://jira.jboss.org/browse/TEIID-1349 and https://jira.jboss.org/browse/TEIID-1351 for upcoming enhancments to update processing. If your scenario is described by TEIID-1349, then we'll be able to handle the update automatically. If it's not (cascading deletes, multiple table updates, check option, etc.), there's still time to get in an enhancement request.