-
1. Re: Error while importing REST web service as source in Teiid Designer
rareddy Oct 29, 2014 10:47 PM (in response to jjaideep2000)Your transformation needs to be something like
select * from xmltable('/x/Root' PASSING jsontoxml('x', '{"Root":{"ElementKey": "Value"}}') COLUMNS ElementKey string) y
of course the json will be replaced with invokeHTTP to get it from a service
-
3. Re: Error while importing REST web service as source in Teiid Designer
rareddy Oct 30, 2014 10:30 PM (in response to jjaideep2000)How did you use Rest importer wizard for creating the Rest source and View model?
Here are some basics of Teiid. A VDB contains 1 more models
* Model defines schema. This can be physical or virtual
* physical model is representation of the source like database, webservice etc.
* every source, needs a "translator" and "data source"
* A translator converts the SQL into source specific queries. Teiid provides various translators
* A data source is "connection" to the physical source like database, web service etc.
* A view model, does not need a translator or data source, it just a logical schema built using source model's schema
So, in the above "data source" that represents connection to your webservice that returns the JSON is missing. Typically in server you create it with "resource-adapter", Designer can automatically create one for you if followed the steps properly. You can manually create it too. In designer right click on the source model, select "create data source" to create.
-
4. Re: Error while importing REST web service as source in Teiid Designer
jjaideep2000 Oct 31, 2014 12:35 PM (in response to rareddy)Thanks so much Ramesh. I just did what you said in the last statement "create data source". I could deploy my VDB and see the metadata. Now one last question (promise !). What is my entity in this metadata, http://localhost:8080/odata/RestVDB/$metadata. Thanks again!
-
metadata.xml 45.2 KB
-