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}}@ip//{{file_path}}/{{file_name.txt}}?odbcSchemaFile={{schema_file_name.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?