[teiid-issues] [JBoss JIRA] (TEIID-5282) Add source fully qualified name extension properties
[
https://issues.jboss.org/browse/TEIID-5282?page=com.atlassian.jira.plugin...
]
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)