[teiid-issues] [JBoss JIRA] (TEIID-965) Need Excel file importer / connector
[
https://issues.jboss.org/browse/TEIID-965?page=com.atlassian.jira.plugin....
]
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