[
https://issues.jboss.org/browse/TEIID-5282?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-5282:
---------------------------------------
To flesh out the proposal:
We will add teiid_rel:source_fqn. The name and value pairs in an fqn will be url encoded
and use the format name=value/name=value... We can worry about internationalization of the
names later if needed.
We will also add teiid_rel:source_attributes. The value will be a json object (map) of
additional source metadata. In particular table_type, but could also include owner, etc.
Obviously the keys/values here will be source specific, so there may need to be additional
metadata captured about them.
It doesn't seem imperative that we add a property to columns as their name will match
the source in most circumstances - however it will not when there is a name collusion (due
to case insensitivity) or if it contains a '.' character.
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)