-
Task
-
Resolution: Won't Do
-
Major
-
None
-
None
-
None
-
None
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=
;Dbq=D:\samplexls.xls</connection-url>
</no-tx-datasource>
</datasources>