[teiid-issues] [JBoss JIRA] Resolved: (TEIID-688) Text Connector should be Medata Aware Connector

[Steven Hawkins (JIRA)]

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

Steven Hawkins resolved TEIID-688.
----------------------------------

    Resolution: Done


The textconnector can provide table metadata through its descriptor file.  For each set of table properties a columns and optional a types property can be used to specify the column metadata.

For example:

SummitData.SUMMITDATA.columns = TRADEID,NOTIONAL,EVTTYPE,CCY,PORS,RATE,STRIKE,SPREAD,DMOWNERTAB,FOLDER,DESK,START,MATURITY,COMMENT 
SummitData.SUMMITDATA.types = integer,biginteger,string,string,string,biginteger,integer,integer,string,string,string,timestamp,timestamp,string

If types are omitted, then string is assumed.

Issues or enhancements:
It would be better if we inferred the columns from the file contents if possible (this logic is already in the synchexecution).
There is no ability to specify additional metadata (unique columns, annotation, etc.)

> Text Connector should be Medata Aware Connector
> -----------------------------------------------
>
>                 Key: TEIID-688
>                 URL: https://jira.jboss.org/jira/browse/TEIID-688
>             Project: Teiid
>          Issue Type: Sub-task
>          Components: Misc. Connectors
>            Reporter: Ramesh Reddy
>            Assignee: Steven Hawkins
>             Fix For: 6.2.0
>
>
> Based on TEIID-685, Text Connector must implement this interface(s), so that any Text sources can be used in dynamic data integration.

-- 
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