<model name="OtherHoldings">
        <property name="importer.headerRowNumber" value="1"/>
        <property name="importer.ExcelFileName" value="otherholdings.xls"/>
        <source name="excelconnector" translator-name="excel"  connection-jndi-name="java:/excel-file"/>
        <metadata type="DDL"><![CDATA[
             SET NAMESPACE 'http://www.teiid.org/translator/excel/2014' AS teiid_excel;
            CREATE FOREIGN TABLE Sheet1 (
	            ROW_ID integer OPTIONS (SEARCHABLE 'All_Except_Like', "teiid_excel:CELL_NUMBER" 'ROW_ID'),
	            FirstName string OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '1'),
	            LastName string OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '2'),
	           Age string OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '3'),
	           CONSTRAINT PK0 PRIMARY KEY(ROW_ID)
            ) OPTIONS ("teiid_excel:FILE" 'otherholdings.xls', "teiid_excel:FIRST_DATA_ROW_NUMBER" '2');
         ]]> </metadata>
    </model>