[teiid-issues] [JBoss JIRA] (TEIID-2177) Expand native-query support

[Ramesh Reddy (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-2177?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ramesh Reddy resolved TEIID-2177.
---------------------------------

        Labels: 8.2 Beta1  (was: )
      Assignee: Ramesh Reddy  (was: Steven Hawkins)
    Resolution: Done


SalesForce:

Expanded the native query support using the extension metadata property "{http://www.teiid.org/ext/relational/2012}native-query" on the SalesForce Tables. When user uses this property, during the construction of the query, except for the projection columns all other parts of the query will be replaced with the native query before the query is submitted to the SF.com

for Ex: if Account table had native query set to "From Account where ID = 'foo'", and the query submitted to translator is "Select Name, ID from Account" then the query submitted to SF will like "Select Name, ID From Account where ID = 'foo'"

LDAP:
Expanded the native query support using the extension metadata property "{http://www.teiid.org/ext/relational/2012}native-query" on the LDAP Tables. When user uses this property, during the construction of the query, except for the projection columns all other parts of the query will be replaced with the native query before the query is submitted to the LDAPContext

For Ex: If Employee table has the above property with this value "context-name=corporate;filter=(objectClass=*);count-limit=5;timout=6;search-scope=ONELEVEL_SCOPE;attributes=uid,cn", the name in source property is ignored for building the context name, search scope and filter and above query used just as in native procedures TEIID-2166 and result query sent to the LDAP context.
                
> Expand native-query support
> ---------------------------
>
>                 Key: TEIID-2177
>                 URL: https://issues.jboss.org/browse/TEIID-2177
>             Project: Teiid
>          Issue Type: Sub-task
>          Components: Misc. Connectors
>            Reporter: Steven Hawkins
>            Assignee: Ramesh Reddy
>              Labels: 8.2, Beta1
>             Fix For: 8.2
>
>
> The native-query extension metadata is currently understood only by jdbc.  We should add support in olap, ldap, salesforce, etc.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira