[teiid-issues] [JBoss JIRA] (TEIID-965) Need Excel file importer / connector

[Steven Hawkins (Commented) (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-965?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12654284#comment-12654284 ] 

Steven Hawkins commented on TEIID-965:
--------------------------------------

Ripan non-quoted SQL identifiers are not allowed to have ":", so you need to issue your query with the table name quoted:

select * from ExcelData."c:/abcd.Sheet1$"

Which if you issue it from the sample command line client will need likely need to be escaped:

"select * from ExcelData.\"c:/abcd.Sheet1$\""

Since this is the reported table name (presumably from the TABLES system table), this should work as expected with your JDBC-ODBC source.  As Ramesh indicates, getTextFiles is a procedure for file sources (using the file translator with a file datasource) and is not applicable for a JDBC source unless there is a corresponding stored procedure.
                
> Need Excel file importer / connector
> ------------------------------------
>
>                 Key: TEIID-965
>                 URL: https://issues.jboss.org/browse/TEIID-965
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: Misc. Connectors
>    Affects Versions: 7.0
>            Reporter: Steven Hawkins
>             Fix For: Open To Community
>
>
> Really need to add an Excel connector in SP1.  The easiest way to do this is probably with one of the open source JDBC drivers that work over Excel files.  
> Something like:
> https://xlsql.dev.java.net/ - Excel JDBC driver (GPL unfortunately, so we probably can't distribute the driver)
> http://www.andykhan.com/jexcelapi/ - Java Excel API (GPL too)
> http://xlsjdbc.sourceforge.net/ - LGPL (uses Apache POI), really cheesy and maybe not being updated
> http://jakarta.apache.org/poi/ - Excel API, event-based and not particularly friendly
> http://www.vistaportal.com/products/vistajdbc-QA.htm - commercial

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira