rahul gholap created TEIID-6020:
-----------------------------------
Summary: How to specify different config properties while connecting to FTP
using Teiid Resource Adapter
Key: TEIID-6020
URL:
https://issues.redhat.com/browse/TEIID-6020
Project: Teiid
Issue Type: Feature Request
Reporter: rahul gholap
Assignee: Steven Hawkins
We are trying to connect FTP and SFTP files
using org.teiid.resource.adapter.ftp.FtpManagedConnectionFactory adapter.While
configuring Resource Adapter,below options are available in config properties.
Host,Port,ParentDirectory,UserName,Password,Protocol.
Lets say JDBC url for connecting to SFTP file is like below.
jdbc:text:sftp://\{{host}}:
\{{port}}(a)\{{ip}}//\{{file_path}}/\{{file_name}}.txt?odbcSchemaFile=\{{schema_file}}.sch;fileExtension=txt;delayedClose=0;refreshInterval=0
My Questions are below .
1)how to specify schema file and actual filepath?.
2)If file is delimited then how to specify delimiter?
3)If parent directory contain multiple files then how to specify file that we want to
connect?
4)In case of header false and header true , which config properties need to be added and
how?
--
This message was sent by Atlassian Jira
(v7.13.8#713008)