Insert data to MySQL tabla using Teiid

[ivon.stocco]

Hello, I'm new to Teiid; I've already created a VDB from a flat file data source. I want to persist this data into a physical table in Mysql: Is there a way to do this automatically with Teiid? I mean, I have to create a process that takes this data from the Flat file and insert it into a physical table in one transaction. Thanks for your time!

[van.halbert]

Hi Ivon,

Yes, Teiid can automatically load the data into Mysql using the external materialization feature.    Here is an external materialization example [1], which depends on the data-federation example [2] for its data.   The materialization, in this example, is configured to reload the h2 table every 60 seconds, but that's configurable.   Take a look at the portofolio-mat-vdb.xml as to how its configured.   Full details on using external materialization can be found here [3].

Another option for automating the load, you could use cron job to submit the sql to perform the "select into".

[1]  teiid-quickstarts/vdb-materialization at master · teiid/teiid-quickstarts · GitHub

[2] teiid-quickstarts/vdb-datafederation at master · teiid/teiid-quickstarts · GitHub

[3] External Materialization · Teiid Documentation

Please reach out if you have any questions.

Van

[ivon.stocco]

Thanks for your reply, Van Halbert.