-
1. Re: SQL Query Interface to Combined View of Relational and Non-Relational Sources
rareddy Oct 29, 2012 12:09 PM (in response to darnowsi)Steve,
Yes, that is exactly what Teiid does. I suggest you start with Quick Starts in Teiid and Teiid Designer and see how this can be done. https://www.jboss.org/teiiddesigner/downloads/examples
Ramesh..
-
2. Re: SQL Query Interface to Combined View of Relational and Non-Relational Sources
darnowsi Oct 29, 2012 1:48 PM (in response to rareddy)Ramesh,
The customer requirement is to support SQL calls such as "Select" to access a view that includes non relational soruces. . For example they want to be able to use semantices such as suggested in the JBDC example (SQL X) but for soruces such as a web service. .
-
3. Re: SQL Query Interface to Combined View of Relational and Non-Relational Sources
rareddy Oct 29, 2012 1:55 PM (in response to darnowsi)Yes, Steve I understand. Teiid can do that. Did you see the StateServiceExampleFull.zip ?
-
4. Re: SQL Query Interface to Combined View of Relational and Non-Relational Sources
darnowsi Oct 29, 2012 2:08 PM (in response to rareddy)Ramesh,
Yes I looked at that example - the test program use a prcoedural call "exec.getStateInf() - Are you suggest that the java class should return a SQL result object and the app do something like "select * from exec.getInfo()
-
5. Re: SQL Query Interface to Combined View of Relational and Non-Relational Sources
rareddy Oct 29, 2012 4:22 PM (in response to darnowsi)May be it is useful for you to go through this example.
https://community.jboss.org/wiki/ConvertXMLDataIntoRelationalTableDataUsingTeiid
Note that we have done numerous UI improvement in the Designer to avoid lot of manual parts in the example. But it should give you a good idea as to how Teiid works.
Ramesh..
-
6. Re: SQL Query Interface to Combined View of Relational and Non-Relational Sources
darnowsi Oct 29, 2012 4:59 PM (in response to rareddy)Thanks Ramesh, I think Example 4 provides what I need.
-
7. Re: SQL Query Interface to Combined View of Relational and Non-Relational Sources
rareddy Oct 29, 2012 5:19 PM (in response to darnowsi)Good, now that where I talked before about improvements we have made in the Teiid Designer for defining this view through a wizard as XML mapping could be little challenging. Look for wizard,
To help you define the view.
Ramesh..
pls, consider following on Twitter @Teiid and blog at http://teiid.blogspot.com for various details about Teiid.