Previously, there was no easy mechanism to allow a source specific query to be submitted to the runtime engine. Users needed to resort to user defined functions which can be unnecessarily complex.
Source specific queries (or "native queries") can now be set in Teiid Designer. The runtime engine will then use this native query as an inline view instead of the respective table name within a FROM clause.
* This is the Product tracker for Community JIRA TEIID-669 *
Per the EDS call 09/28/12, we should produce this feature, demonstrate it to a customer that needs it, and include it in the next available EDS Roll up after.
Currently there is no mechanism in Teiid, when a query is submitted to a runtime engine that is passed through the query engine unadulterated and unmodified and submitted directly to a source connector. All queries are parsed, optimized, re-written. Some times this limits the functionality in Teiid, when a user would like to execute a query that is very "source" specific. For example Oracle supports lots of Oracle specific functions that are not supported by the SQL spec, to support execution of these in Teiid user need to resort to UDF, which is cumbersome and involves modelling.
Another benefit of this is also to pass DDL to sources, currently since Teiid does not support DDL, this is not possible at all.
Steven Hawkins <firstname.lastname@example.org> updated the status of jira TEIID-669 to Resolved
Steven Hawkins <email@example.com> made a comment on jira TEIID-669
with TEIID-2176, TEIID-2177, and the existing native-query support I'm marking this issue as resolved as to limit what it covers.
New issues can be created to cover incremental improvements or some form of a pass through query mode directly from the client.
Ramesh Reddy <firstname.lastname@example.org> made a comment on jira TEIID-669
JLee, I thought the only changes we are going to do for EDS 5.3 was in the JBDS which are going in their rollup. The extension properties for native query for relational sources is already in the 5.3. These TEIID-2176, TEIID-2177 JIRAs expand the native query support to other sources and also provide native procedure support which we are not approved for 5.3
re-adding as a blocker as engineering has found an issue. backport to follow (soon).
Committed r4525 to https://svn.jboss.org/repos/teiid/branches/7.7.x
Verified in 5.3.1 ER1 with JBDS SOA/BRMS tooling 5.0.1 (released on CSP 7th November).
It is possible to set the native query in Teiid Designer in source model. The native query will be then embedded as inline view in FROM clause.
Steven Hawkins <email@example.com> updated the status of jira TEIID-669 to Closed