[teiid-designer-issues] [JBoss JIRA] Commented: (TEIIDDES-775) No way to create text file data source in designer
[
https://issues.jboss.org/browse/TEIIDDES-775?page=com.atlassian.jira.plug...
]
Barry LaFond commented on TEIIDDES-775:
---------------------------------------
The Flat File connection in DTP is using an ODA Eclipse extension point that brings with
it it's own API. That API isn't exposed the same way JDBC is, so any notion of
"Data Preview" isn't available even though you can open a SQL Scrapbook on
the CP.
The Flat file content structure expected for DTP is different than that for Teiid, so we
would need to investigate the differences and try to merge/connect them in some way.
In the meantime, users can test their Flat/Text File data sources by creating their
Relational models, adding to VDB, setting Translator names to "file" and JNDI
names to the names of the -ds.xml text file data sources you create/deploy to your Teiid
instance
No way to create text file data source in designer
--------------------------------------------------
Key: TEIIDDES-775
URL: https://issues.jboss.org/browse/TEIIDDES-775
Project: Teiid Designer
Issue Type: Bug
Components: Teiid Integration
Affects Versions: 7.1.1
Environment: JBDev Studio v4 beta 2
Reporter: Ken Johnson
Priority: Blocker
Problem trying to model text file data sources: After creating physical procedure to map
to getTextFiles() method in file translator and virtual procedure to select values from
TEXTABLE() function, there is no way to create a connection profile to the file source.
The DTP Flat File Connection works until Finish where it complains: No valid Teiid
connection properties associated with this connection profile.
There is a mismatch between the file translator operations and the DTP file connection
profile.
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira