I do not think I understand your question, please elaborate your usecase so that we can understand what you are trying to achieve.
If you attached a data store through your VDB, you can use insert/update/delele commands to add data to the data store and retrieve them back using select.
Here is the usecase:
Get data through API calls --> Access these data through Teiid.
Do we have to save these data into file or DB, then deploy file/DB to Teiid VDB, then we can access them through Teiid? Can we avoid middle stage of file/DB?
Yes, you can. No you do not need to store the data in a file or DB first. However, since Teiid out of the box only comes with fixed set of translators that know exactly how to read data from known data sources (files, dbs, webservice, salesforce etc), it would not know how to read the data from your custom source.
This is where a custom translator comes into picture. You can write a translator using the Teiid API, which lets you integrate the data from any source/API. Take look at the "Developer's Guide" on how to write a translator and also you can take a look at various translators in the Teiid code. For example take a look at "Loopback" or "yahoo" translators in the code as examples to start writing your own.
Thanks, Ramesh. Your answer is very helpful.
I want to see the example code of loopback and yahoo, so I downloaded teiid-8.2.0.Final-src.zip, but couldn't find them, did I download wrong thing?