5:19 a.m.
[
https://issues.jboss.org/browse/TEIIDDES-1849?page=com.atlassian.jira.plu...
]
Ramc Natarajan updated TEIIDDES-1849:
-------------------------------------
Description:
I have a need to connect the excel file using the odbc driver in teiid designer .
server : JBoss AS 5.3.1
designer : 5.0.2
teiid : 7.7.3
I have created the data source using the odbc driver for the excel file and the -ds file
was generated in the server deploy folder as given below. Now how to connect this -ds file
with the Teiid designer.
<?xml version="1.0" encoding="UTF-8"
standalone="yes"?>
<datasources>
<no-tx-datasource>
<jndi-name>odbcDS1</jndi-name>
<use-java-context>true</use-java-context>
<min-pool-size>0</min-pool-size>
<max-pool-size>10</max-pool-size>
<blocking-timeout-millis>30000</blocking-timeout-millis>
<idle-timeout-minutes>30</idle-timeout-minutes>
<background-validation>false</background-validation>
<background-validation-millis>0</background-validation-millis>
<validate-on-match>true</validate-on-match>
<use-fast-fail>false</use-fast-fail>
<allocation-retry>0</allocation-retry>
<allocation-retry-wait-millis>5000</allocation-retry-wait-millis>
<application-managed-security/>
<metadata/>
<prepared-statement-cache-size>0</prepared-statement-cache-size>
<share-prepared-statements>false</share-prepared-statements>
<set-tx-query-timeout>false</set-tx-query-timeout>
<query-timeout>0</query-timeout>
<url-delimiter>|</url-delimiter>
<driver-class>sun.jdbc.odbc.JdbcOdbcDriver</driver-class>
<connection-url>jdbc:odbc:Driver={Microsoft Excel Driver
(*.xls)};Dbq=D:\samplexls.xls</connection-url>
</no-tx-datasource>
</datasources>
how to connect the excel file using the odbc driver
---------------------------------------------------
Key: TEIIDDES-1849
URL: https://issues.jboss.org/browse/TEIIDDES-1849
Project: Teiid Designer
Issue Type: Task
Reporter: Ramc Natarajan
I have a need to connect the excel file using the odbc driver in teiid designer .
server : JBoss AS 5.3.1
designer : 5.0.2
teiid : 7.7.3
I have created the data source using the odbc driver for the excel file and the -ds file
was generated in the server deploy folder as given below. Now how to connect this -ds file
with the Teiid designer.
<?xml version="1.0" encoding="UTF-8"
standalone="yes"?>
<datasources>
<no-tx-datasource>
<jndi-name>odbcDS1</jndi-name>
<use-java-context>true</use-java-context>
<min-pool-size>0</min-pool-size>
<max-pool-size>10</max-pool-size>
<blocking-timeout-millis>30000</blocking-timeout-millis>
<idle-timeout-minutes>30</idle-timeout-minutes>
<background-validation>false</background-validation>
<background-validation-millis>0</background-validation-millis>
<validate-on-match>true</validate-on-match>
<use-fast-fail>false</use-fast-fail>
<allocation-retry>0</allocation-retry>
<allocation-retry-wait-millis>5000</allocation-retry-wait-millis>
<application-managed-security/>
<metadata/>
<prepared-statement-cache-size>0</prepared-statement-cache-size>
<share-prepared-statements>false</share-prepared-statements>
<set-tx-query-timeout>false</set-tx-query-timeout>
<query-timeout>0</query-timeout>
<url-delimiter>|</url-delimiter>
<driver-class>sun.jdbc.odbc.JdbcOdbcDriver</driver-class>
<connection-url>jdbc:odbc:Driver={Microsoft Excel Driver
(*.xls)};Dbq=D:\samplexls.xls</connection-url>
</no-tx-datasource>
</datasources>
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira