[ 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.4 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> was: 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