Teiid for updating data?

[joshdanhall]

From what I've read in the FAQ's etc is that Teiid is good for Federated queries, joining data from several data sources. But I want to know if it can also be used to update (sync) data across those data sources?

Thanks.

[shawkins]

Yes, Teiid can perform updates as well.  For an update against a view may be handled automatically if the view is defined by a simple query expression.  Otherwise you'll need to add instead of triggers to process the update in whatever way makes sense.  As long as your sources support XA transactions, then the entire update will be transactionally safe.

When using multi-source models it is possible to have the same update automatically affect multiple sources.  Beyond that if you are referring to sync/replication functionality in general, we don't have anything else built-in for that at this time.

[joshdanhall]

OK. That sounds pretty awesome. How would it work if the data source is a Web Service?

[van.halbert]

Josh,

Have a look at the Teiid Designer quick starts :  Examples - Teiid Examples - Project Documentation Editor

There are a couple of examples under Web Services that should help.

Van