February 2016 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3599) Excel translator and dynamic filenames

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3599?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-3599: --------------------------------------- The file translator and the excel query logic already support the <directory>/*.ext wildcard, so are we just saying that the importer needs to support to support that as well? > Excel translator and dynamic filenames > -------------------------------------- > > Key: TEIID-3599 > URL: https://issues.jboss.org/browse/TEIID-3599 > Project: Teiid > Issue Type: Enhancement > Components: Misc. Connectors > Reporter: Ralph Martin Black > Assignee: Ramesh Reddy > Priority: Minor > Fix For: Open To Community > > > Hi all, > All samples I've reached on how to setup a connection to xls files, set up file names as properties in the source model: > ... > <property name="importer.ExcelFileName" value="names.xls"/> > ... > Is there any way to specify filenames dynamically at run-time? > Best regards > MB! -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3599) Excel translator and dynamic filenames

by Ralph Martin Black (JIRA)

[ https://issues.jboss.org/browse/TEIID-3599?page=com.atlassian.jira.plugin... ] Ralph Martin Black commented on TEIID-3599: ------------------------------------------- Ramesh, that approach sounds good to me... other DV vendors follow that approach Good to know you are considering this feature, thx! > Excel translator and dynamic filenames > -------------------------------------- > > Key: TEIID-3599 > URL: https://issues.jboss.org/browse/TEIID-3599 > Project: Teiid > Issue Type: Enhancement > Components: Misc. Connectors > Reporter: Ralph Martin Black > Assignee: Ramesh Reddy > Priority: Minor > Fix For: Open To Community > > > Hi all, > All samples I've reached on how to setup a connection to xls files, set up file names as properties in the source model: > ... > <property name="importer.ExcelFileName" value="names.xls"/> > ... > Is there any way to specify filenames dynamically at run-time? > Best regards > MB! -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3599) Excel translator and dynamic filenames

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-3599?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-3599: ------------------------------------- We can change the File name from absolute name to a wildcard pattern. The only caveat is all the file must have metadata format. We can pick the first one to read the meatadata but read data from all. > Excel translator and dynamic filenames > -------------------------------------- > > Key: TEIID-3599 > URL: https://issues.jboss.org/browse/TEIID-3599 > Project: Teiid > Issue Type: Enhancement > Components: Misc. Connectors > Reporter: Ralph Martin Black > Assignee: Ramesh Reddy > Priority: Minor > Fix For: Open To Community > > > Hi all, > All samples I've reached on how to setup a connection to xls files, set up file names as properties in the source model: > ... > <property name="importer.ExcelFileName" value="names.xls"/> > ... > Is there any way to specify filenames dynamically at run-time? > Best regards > MB! -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3862) Documentation in kit for certain datasources missing

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-3862?page=com.atlassian.jira.plugin... ] Van Halbert commented on TEIID-3862: ------------------------------------ Modeshape: {code} <datasource jndi-name="java:/datasources/ModeShapeDS" pool-name="ModeShapeDS" use-java-context="true"> <connection-url>jdbc:jcr:jndi:jcr?repositoryName=dv</connection-url> <driver>modeshape</driver> <security> <user-name>${username</user-name> <password>${pasword}</password> </security> </datasource> {code} {code} <driver name="modeshape" module="org.modeshape.jdbc"> <driver-class>org.modeshape.jdbc.LocalJcrDriver</driver-class> </driver> {code} > Documentation in kit for certain datasources missing > ---------------------------------------------------- > > Key: TEIID-3862 > URL: https://issues.jboss.org/browse/TEIID-3862 > Project: Teiid > Issue Type: Quality Risk > Components: Documentation > Reporter: Ramesh Reddy > Assignee: Van Halbert > Fix For: 8.12.5 > > > The following data sources do not have documentation under > "docs/teiid/datasources" > where typically a standalone.xml changes and/or CLI scripts are provided. > access > hana > hsql > informix > modeshape > netezza > sybase > teradata > excel > hbase > odata > odata4 -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3862) Documentation in kit for certain datasources missing

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-3862?page=com.atlassian.jira.plugin... ] Van Halbert commented on TEIID-3862: ------------------------------------ Tereadata: {code} <datasource jndi-name="java:/TERADATA" pool-name="TERADATA" enabled="true"> <connection-url>jdbc:teradata://${hostname}/database=${databasename},tmode=ANSI,charset=UTF8</connection-url> <driver>teradata</driver> <pool> <prefill>false</prefill> <use-strict-min>false</use-strict-min> <flush-strategy>FailingConnectionOnly</flush-strategy> </pool> <security> <user-name>${username}</user-name> <password>${password}</password> </security> </datasource> {code} {code} <driver name="teradata" module="com.teradata"> <driver-class>com.teradata.jdbc.TeraDriver</driver-class> </driver> {code} > Documentation in kit for certain datasources missing > ---------------------------------------------------- > > Key: TEIID-3862 > URL: https://issues.jboss.org/browse/TEIID-3862 > Project: Teiid > Issue Type: Quality Risk > Components: Documentation > Reporter: Ramesh Reddy > Assignee: Van Halbert > Fix For: 8.12.5 > > > The following data sources do not have documentation under > "docs/teiid/datasources" > where typically a standalone.xml changes and/or CLI scripts are provided. > access > hana > hsql > informix > modeshape > netezza > sybase > teradata > excel > hbase > odata > odata4 -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3862) Documentation in kit for certain datasources missing

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3862?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-3862: --------------------------------------- Can these be done as a pull request? > Documentation in kit for certain datasources missing > ---------------------------------------------------- > > Key: TEIID-3862 > URL: https://issues.jboss.org/browse/TEIID-3862 > Project: Teiid > Issue Type: Quality Risk > Components: Documentation > Reporter: Ramesh Reddy > Assignee: Van Halbert > Fix For: 8.12.5 > > > The following data sources do not have documentation under > "docs/teiid/datasources" > where typically a standalone.xml changes and/or CLI scripts are provided. > access > hana > hsql > informix > modeshape > netezza > sybase > teradata > excel > hbase > odata > odata4 -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3862) Documentation in kit for certain datasources missing

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-3862?page=com.atlassian.jira.plugin... ] Van Halbert edited comment on TEIID-3862 at 2/18/16 3:40 PM: ------------------------------------------------------------- Excel: {code} /subsystem=resource-adapters/resource-adapter=fileExcel:add(module=org.jboss.teiid.resource-adapter.file) /subsystem=resource-adapters/resource-adapter=fileExcel/connection-definitions=fileDS:add(jndi-name=java:/excel-file, class-name=org.teiid.resource.adapter.file.FileManagedConnectionFactory, enabled=true, use-java-context=true) /subsystem=resource-adapters/resource-adapter=fileExcel/connection-definitions=fileDS/config-properties=ParentDirectory:add(value=${jboss.home.dir}/excelFiles/) /subsystem=resource-adapters/resource-adapter=fileExcel/connection-definitions=fileDS/config-properties=AllowParentPaths:add(value=true) /subsystem=resource-adapters/resource-adapter=fileExcel:activate {code} {code} <resource-adapter id="fileExcel"> <module slot="main" id="org.jboss.teiid.resource-adapter.file"/> <connection-definitions> <connection-definition class-name="org.teiid.resource.adapter.file.FileManagedConnectionFactory" jndi-name="java:/excel-file" enabled="true" use-java-context="true" pool-name="fileExcelDS"> <config-property name="ParentDirectory"> ${jboss.home.dir}/excelFiles/ </config-property> <config-property name="AllowParentPaths"> true </config-property> </connection-definition> </connection-definitions> </resource-adapter> {code} was (Author: van.halbert): Excel: {code} /subsystem=resource-adapters/resource-adapter=fileExcel:add(module=org.jboss.teiid.resource-adapter.file) /subsystem=resource-adapters/resource-adapter=fileExcel/connection-definitions=fileDS:add(jndi-name=java:/excel-file, class-name=org.teiid.resource.adapter.file.FileManagedConnectionFactory, enabled=true, use-java-context=true) /subsystem=resource-adapters/resource-adapter=fileExcel/connection-definitions=fileDS/config-properties=ParentDirectory:add(value=${jboss.home.dir}/excelFiles/) /subsystem=resource-adapters/resource-adapter=fileExcel/connection-definitions=fileDS/config-properties=AllowParentPaths:add(value=true) /subsystem=resource-adapters/resource-adapter=fileExcel:activate {code} > Documentation in kit for certain datasources missing > ---------------------------------------------------- > > Key: TEIID-3862 > URL: https://issues.jboss.org/browse/TEIID-3862 > Project: Teiid > Issue Type: Quality Risk > Components: Documentation > Reporter: Ramesh Reddy > Assignee: Van Halbert > Fix For: 8.12.5 > > > The following data sources do not have documentation under > "docs/teiid/datasources" > where typically a standalone.xml changes and/or CLI scripts are provided. > access > hana > hsql > informix > modeshape > netezza > sybase > teradata > excel > hbase > odata > odata4 -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3862) Documentation in kit for certain datasources missing

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-3862?page=com.atlassian.jira.plugin... ] Van Halbert commented on TEIID-3862: ------------------------------------ I'm just gathering all the pieces at the moment, but yes, end the end they will be > Documentation in kit for certain datasources missing > ---------------------------------------------------- > > Key: TEIID-3862 > URL: https://issues.jboss.org/browse/TEIID-3862 > Project: Teiid > Issue Type: Quality Risk > Components: Documentation > Reporter: Ramesh Reddy > Assignee: Van Halbert > Fix For: 8.12.5 > > > The following data sources do not have documentation under > "docs/teiid/datasources" > where typically a standalone.xml changes and/or CLI scripts are provided. > access > hana > hsql > informix > modeshape > netezza > sybase > teradata > excel > hbase > odata > odata4 -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3862) Documentation in kit for certain datasources missing

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-3862?page=com.atlassian.jira.plugin... ] Van Halbert commented on TEIID-3862: ------------------------------------ Excel: {code} /subsystem=resource-adapters/resource-adapter=fileExcel:add(module=org.jboss.teiid.resource-adapter.file) /subsystem=resource-adapters/resource-adapter=fileExcel/connection-definitions=fileDS:add(jndi-name=java:/excel-file, class-name=org.teiid.resource.adapter.file.FileManagedConnectionFactory, enabled=true, use-java-context=true) /subsystem=resource-adapters/resource-adapter=fileExcel/connection-definitions=fileDS/config-properties=ParentDirectory:add(value=${jboss.home.dir}/excelFiles/) /subsystem=resource-adapters/resource-adapter=fileExcel/connection-definitions=fileDS/config-properties=AllowParentPaths:add(value=true) /subsystem=resource-adapters/resource-adapter=fileExcel:activate {code} > Documentation in kit for certain datasources missing > ---------------------------------------------------- > > Key: TEIID-3862 > URL: https://issues.jboss.org/browse/TEIID-3862 > Project: Teiid > Issue Type: Quality Risk > Components: Documentation > Reporter: Ramesh Reddy > Assignee: Van Halbert > Fix For: 8.12.5 > > > The following data sources do not have documentation under > "docs/teiid/datasources" > where typically a standalone.xml changes and/or CLI scripts are provided. > access > hana > hsql > informix > modeshape > netezza > sybase > teradata > excel > hbase > odata > odata4 -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3862) Documentation in kit for certain datasources missing

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-3862?page=com.atlassian.jira.plugin... ] Van Halbert commented on TEIID-3862: ------------------------------------ Netezza: {code} <datasource jndi-name="java:/NETEZZA" pool-name="Netezza"> <connection-url>jdbc:netezza://${hostname}:5480/${databasename}</connection-url> <driver>netezza</driver> <pool> <prefill>false</prefill> <use-strict-min>false</use-strict-min> <flush-strategy>FailingConnectionOnly</flush-strategy> </pool> <security> <user-name>${username}</user-name> <password>${password}</password> </security> </datasource> {code} {code} <driver name="netezza" module="org.netezza"> <driver-class>org.netezza.Driver</driver-class> </driver> {code} > Documentation in kit for certain datasources missing > ---------------------------------------------------- > > Key: TEIID-3862 > URL: https://issues.jboss.org/browse/TEIID-3862 > Project: Teiid > Issue Type: Quality Risk > Components: Documentation > Reporter: Ramesh Reddy > Assignee: Van Halbert > Fix For: 8.12.5 > > > The following data sources do not have documentation under > "docs/teiid/datasources" > where typically a standalone.xml changes and/or CLI scripts are provided. > access > hana > hsql > informix > modeshape > netezza > sybase > teradata > excel > hbase > odata > odata4 -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 10 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues February 2016