1 Reply Latest reply on Nov 19, 2014 8:29 AM by shawkins

Teiid : Insert Data to MySQL DB from flatfile source model.

sarathksnair Nov 19, 2014 2:49 AM

Hi,

Any one please tell me if it is possible to put data into MySQL database from a flatfile source model.

After continuous analysis about Jboss Data Virtualization and Teiid Designer 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.

Kindly give an idea on if it is possible to put data to other databases.

Thanks in advance.

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.
Actions