[teiid-issues] [JBoss JIRA] Commented: (TEIID-685) Define Metadata aware Connector API

[John Doyle (JIRA)]

    [ https://jira.jboss.org/jira/browse/TEIID-685?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12476037#action_12476037 ] 

John Doyle commented on TEIID-685:
----------------------------------

I agree with Ramesh that it's better to move towards the domain objects of tables and columns, I think this leads to a better API.

I also don't see the need to hide these objects behind interfaces now.  I would prefer us to try and define a common interface layer from this API and the implementations that are built on top of the forthcoming serialized metadata representation.

> Define Metadata aware Connector API
> -----------------------------------
>
>                 Key: TEIID-685
>                 URL: https://jira.jboss.org/jira/browse/TEIID-685
>             Project: Teiid
>          Issue Type: Sub-task
>          Components: Connector API
>            Reporter: Ramesh Reddy
>            Assignee: Steven Hawkins
>            Priority: Critical
>             Fix For: 6.2.0
>
>
> Connector API needs to be extended, such that a connector can selectively implement an interface with which it can expose the metadata of the connector. This is similar to the concept of JDBC drivers exposing the metadata of the sources they are connected to.
> At a minimum, this API must expose all the available 
> - Tables, with corresponding elements
> - Procedures with corresponding parameters
> in the data source. There should also be a way to define user defined properties on all the objects, that can used by tools as they fit.
> Please comment, if there are any specific features you would like this to extend, as PK, FK, Unique keys, indexes etc. Overtime, it is expectation that this will be grown to full blown metadata store API as the teiid-metadata project.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira