[
https://issues.redhat.com/browse/TEIIDDES-3229?page=com.atlassian.jira.pl...
]
Ramesh Reddy commented on TEIIDDES-3229:
----------------------------------------
From the above link seeĀ
{code:java}
/subsystem=resource-adapters/resource-adapter=ftp/connection-definitions=ftpDS/config-properties=ParentDirectory:add(value="${ftp.parent.dir}")
{code}
above property to set the directory. BTW, you can directly edit the standalone-teiid.xml
file add the content too instead of running the CLI and executing above like commands to
set the values for resource adapter of FTP. See the
"docs/teiid/datasources/ftp/ftp-ds.xml" file.
Defining the name of the file will be done in TEXTTABLE construct, there is no separate
schema file the schema expected in same file as header for csv or fixed width files. If
you need access to multiple files, you can use the wildcard based name for the fie name in
a given directory.
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)