<!-- Add the below contents under "datasources" subsystem in the standalone-teiid.xml or deploy as -ds.xml file -->
<datasources>
    <datasource jndi-name="java:/odbcDS" pool-name="odbcDS">
        <!-- Create a DSN using ODBC driver manager, and replace {DSN} below with your DSN name -->
        <connection-url>jdbc:odbc:{DSN}</connection-url>
        
       <!-- For DSN less connection URL use the below form to connect to a Excel Sheet
          <connection-url>jdbc:odbc:Driver={Microsoft Excel Driver (*.xls)};Dbq=c:\ODBC\ExcelData.xls</connection-url>
        -->      
         <driver-class>sun.jdbc.odbc.JdbcOdbcDriver</driver-class>
        <transaction-isolation>TRANSACTION_NONE</transaction-isolation>
        
        <pool>
            <prefill>false</prefill>
            <use-strict-min>false</use-strict-min>
            <flush-strategy>FailingConnectionOnly</flush-strategy>
        </pool>
        <security>
            <user-name>{user}</user-name>
            <password>{password}</password>
        </security>
    </datasource>                               
</datasources>
