[
https://issues.redhat.com/browse/TEIIDDES-3229?page=com.atlassian.jira.pl...
]
rahul gholap edited comment on TEIIDDES-3229 at 8/25/20 11:38 PM:
------------------------------------------------------------------
Hi Ramesh,
Thanks for the information.
Actually our usecase is below.
1) We are trying to connect to FTP/SFTP flatfiles (delimited as well as
FixedLength).Below are the connection properties we need to specify.
1) Delimited Flatfile :
Properties required : host.port,user,password,file
type(csv/txt),header(true/false),file location,schema file name.
If header value is true then we need to specify delimiter
. If header value is false then we need to specify schema file name
2)FixedLength Flatfile :
Properties required : host.port,user,password,file type(csv/txt),file location,schema
file name.
so in this case how to specify all above properties in connection config.
was (Author: rahulg1):
Hi Ramesh,
Thanks for the information.
Actually our usecase is below.
1) We are trying to connect to FTP/SFTP flatfiles (delimited as well as Fixedwidth).Below
are the connection properties we need to specify.
1) Delimited Flatfile :
Properties required : host.port,user,password,file
type(csv/txt),header(true/false),file location,schema file name.
If header value is true then we need to specify delimiter
. If header value is false then we need to specify schema file name
2)FixedLength Flatfile :
Properties required : host.port,user,password,file type(csv/txt),file location,schema
file name.
so in this case how to specify all above properties in connection config.
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)