-
1. Re: Does Teiid support auto-update/auto-delete if there are many third-party systems?
rareddy Nov 27, 2010 7:03 PM (in response to jalen)Jalen,
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
Ramesh..
-
2. Re: Does Teiid support auto-update/auto-delete if there are many third-party systems?
jalen Nov 28, 2010 9:24 PM (in response to rareddy)Remesh,
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)
begin
--(every system has its own schemas)
end
else if(data from sytem2)
begin
...
end
else if(...)
...
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.
Thank you.
-
3. Re: Does Teiid support auto-update/auto-delete if there are many third-party systems?
shawkins Nov 29, 2010 11:27 AM (in response to jalen)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.
Steve