This content has been marked as final.
Show 1 reply
-
1. Re: Teiid : Insert Data to MySQL DB from flatfile source model.
shawkins Nov 19, 2014 8:29 AM (in response to sarathksnair)> what i found was we can take data from any datasource and put the data into a virtual table which can only be a Teiid Instance, but I have no idea if it is possible to put the data into some other database like Mysql, oracle db etc.
Teiid is a virtualization layer. It is not used as a data store. If you create a source in Teiid that represents a flat file source and have a source in Teiid that represents mysql, then you can issue any Teiid supported sql against one or both sources. That includes copying data from the text source into MySQL.