August 2020 - teiid-designer-issues

[JBoss JIRA] (TEIIDDES-3229) How to connect to SFTP and FTP using teiid

by Ramesh Reddy (Jira)

[ 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)

3 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3229) How to connect to SFTP and FTP using teiid

by rahul gholap (Jira)

[ https://issues.redhat.com/browse/TEIIDDES-3229?page=com.atlassian.jira.pl... ] rahul gholap commented on TEIIDDES-3229: ---------------------------------------- Hi Ramesh, Thanks for the information. From above example we can see that, we can specify only Host,Port,Parent Directory,Password in config property. but my questions are below 1)How to specify delimiter in case of header true delimited files. 2)How to specify schema file in case of fixed with file. 3)If parent directory contain multiple files then how to specify exact filename to which we need to connect. > 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)

3 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3229) How to connect to SFTP and FTP using teiid

by Ramesh Reddy (Jira)

[ https://issues.redhat.com/browse/TEIIDDES-3229?page=com.atlassian.jira.pl... ] Ramesh Reddy commented on TEIIDDES-3229: ---------------------------------------- If you take a look at the example I pointed above it will show this {code:java} <resource-adapter id="ftp"> <module slot="main" id="org.jboss.teiid.resource-adapter.ftp"/> <connection-definitions> <connection-definition class-name="org.teiid.resource.adapter.ftp.FtpManagedConnectionFactory" jndi-name="java:/ftpDS" enabled="true" use-java-context="true" pool-name="ftpDS"> <config-property name="Host"> localhost </config-property> <config-property name="ParentDirectory"> /home/kylin/vsftpd </config-property> <config-property name="Username"> user </config-property> <config-property name="Port"> 21 </config-property> <config-property name="Password"> redhat </config-property> </connection-definition> </connection-definitions> </resource-adapter> {code} using which you will supply the configuration. Edit the "standalone-teiid.xml" add above to resource adapters subsection. > 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)

3 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3230) How to create dynamic datasources using Spring boot starter Teiid

by rahul gholap (Jira)

rahul gholap created TEIIDDES-3230: -------------------------------------- Summary: How to create dynamic datasources using Spring boot starter Teiid Key: TEIIDDES-3230 URL: https://issues.redhat.com/browse/TEIIDDES-3230 Project: Teiid Designer Issue Type: Feature Request Reporter: rahul gholap We are trying to use Spring boot starter teiid in our application.We want to connect to any databases as per user input.User have to select database type and enter connection properties in user Interface of our application.so in that case how we can use Spring boot starter Teiid to specify connection properties runtime. because we are usually specifying all the datasource properties before runing application. -- This message was sent by Atlassian Jira (v7.13.8#713008)

3 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3229) How to connect to SFTP and FTP using teiid

by rahul gholap (Jira)

[ 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 in Resource Adapter. 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 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. > 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)

3 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3229) How to connect to SFTP and FTP using teiid

by rahul gholap (Jira)

[ 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)

3 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3229) How to connect to SFTP and FTP using teiid

by rahul gholap (Jira)

[ https://issues.redhat.com/browse/TEIIDDES-3229?page=com.atlassian.jira.pl... ] rahul gholap commented on TEIIDDES-3229: ---------------------------------------- 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)

3 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3229) How to connect to SFTP and FTP using teiid

by Ramesh Reddy (Jira)

[ 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)

3 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3229) How to connect to SFTP and FTP using teiid

by rahul gholap (Jira)

[ https://issues.redhat.com/browse/TEIIDDES-3229?page=com.atlassian.jira.pl... ] rahul gholap edited comment on TEIIDDES-3229 at 8/20/20 12:29 AM: ------------------------------------------------------------------ Hi Ramesh, We followed above link mentioned in the comment to connect to FTP file using Teiid resource adapter and FIle translator.However we got below observations. 1)FtpManagedConnectionFactory used while configuring resorce adapter doest have mechanism to specify delimiter , schema file name and actual file path. 2) If parent dircectory contain multiple files then how to specify files that we want to connect. Could you please tell us how to specify file name , delimiter, schema file name in config properties of FtpManagedConnectionFactory. was (Author: rahulg1): We followed above link mentioned in the comment to connect to FTP file using Teiid resource adapter and FIle translator.However we got below observations. 1)FtpManagedConnectionFactory used while configuring resorce adapter doest have mechanism to specify delimiter , schema file name and actual file path. 2) If parent dircectory contain multiple files then how to specify files that we want to connect. Could you please tell us how to specify file name , delimiter, schema file name in config properties of FtpManagedConnectionFactory. > 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)

3 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3229) How to connect to SFTP and FTP using teiid

by rahul gholap (Jira)

[ https://issues.redhat.com/browse/TEIIDDES-3229?page=com.atlassian.jira.pl... ] rahul gholap commented on TEIIDDES-3229: ---------------------------------------- We followed above link mentioned in the comment to connect to FTP file using Teiid resource adapter and FIle translator.However we got below observations. 1)FtpManagedConnectionFactory used while configuring resorce adapter doest have mechanism to specify delimiter , schema file name and actual file path. 2) If parent dircectory contain multiple files then how to specify files that we want to connect. Could you please tell us how to specify file name , delimiter, schema file name in config properties of FtpManagedConnectionFactory. > 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)

3 years, 8 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-designer-issues August 2020