[
https://issues.redhat.com/browse/TEIIDDES-3229?page=com.atlassian.jira.pl...
]
Ramesh Reddy commented on TEIIDDES-3229:
----------------------------------------
1) see TEXTTABLE construct which needs to be defined to convert the file contents into a
table contents. See [1]and [2] for examples
2) Teiid does not support separate schema file, these are defined in TEXTTABLE itself. if
schema is in same file, you can skip those lines which can be done in TEXTTABLE
3) you can define file name also in TEXTTABLE as concreate file or a pattern for the
file.
[1] [http://teiid.github.io/teiid-documents/master/content/reference/r_texttable.html]
[
2] [https://developer.jboss.org/docs/DOC-15673]
How to connect to SFTP and FTP using teiid
------------------------------------------
Key: TEIIDDES-3229
URL:
https://issues.redhat.com/browse/TEIIDDES-3229
Project: Teiid Designer
Issue Type: Feature Request
Reporter: Punam Dhaitonde
Priority: Major
We need to read flat file or CSV file tabular data using Teiid. We want to use teiid
driver to establish connection with FTP and SFTP location. Could you please suggest us any
solution how to connect to SFTP and FTP using Teiid. We are using Teiid Version : 11.1.2
--
This message was sent by Atlassian Jira
(v7.13.8#713008)