[teiid-issues] [JBoss JIRA] (TEIID-5282) Add source fully qualified name extension properties

[Steven Hawkins (JIRA)]

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

Steven Hawkins resolved TEIID-5282.
-----------------------------------
    Resolution: Done


Seems like there are no qualms with this approach, so marking as resolved.

teiid_rel:source_fqn is as described above - the name and value pairs in an fqn will be url encoded and use the format name=value/name=value... with the refinement that all name keys are in lower case.

Instead of a single teiid_rel:source_attributes individual properties are added with the teiid_rel:source_ prefix - for JDBC teiid_rel:source_type was added to track the table type.

The property was added only to tables - so that will need to be expanded later.  It was also added only to the initial subset of sources that we are likely to support in the near-term.  Still need to add to:  Accumulo, Cassandra, Couchbase, Excel, Odata 2, Infinispan, Solr, Swagger, and WSDL.

> Add source fully qualified name extension properties
> ----------------------------------------------------
>
>                 Key: TEIID-5282
>                 URL: https://issues.jboss.org/browse/TEIID-5282
>             Project: Teiid
>          Issue Type: Enhancement
>          Components: Misc. Connectors
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>             Fix For: 10.2
>
>
> To support TEIIDTOOLS-362 and in general the lookup of source objects by a name other than the Teiid name, we need to add a fully qualified name property.
> The proposal would look like an ldap name containing both the name/parts:
> create foreign table "schemaName.tableName" (...) options ('teiid_rel:fqn' 'catalog:catalogName/schema:schemaName/table:tableName');
> The names will reflect the constructs for each source:
> google: 'worksheet:name/sheet:name'
> salesforce: 'sObject:name'
> etc.



--
This message was sent by Atlassian JIRA
(v7.5.0#75005)