-
1. Re: Model API data to teiid
rareddy Dec 13, 2012 9:35 PM (in response to jane_lj)Jane,
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.
Ramesh..
-
2. Re: Model API data to teiid
jane_lj Dec 14, 2012 10:26 AM (in response to rareddy)Ramesh,
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?
Thanks.
-
3. Re: Model API data to teiid
rareddy Dec 14, 2012 2:37 PM (in response to jane_lj)Jane,
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.
Ramesh..
-
4. Re: Model API data to teiid
jane_lj Dec 17, 2012 10:39 AM (in response to rareddy)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?