Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-965

Need Excel file importer / connector

XMLWordPrintable

    • Icon: Feature Request Feature Request
    • Resolution: Done
    • Icon: Major Major
    • 8.7
    • 7.0
    • Misc. Connectors
    • None

      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

        1.
        		 Create valid capabilities support for MS Excel and MS Access JDBC-ODBC Connectors Sub-task Closed Major Unassigned

        0%
        Original Estimate - 4 hours
        Remaining Estimate - 4 hours

            rhn-engineering-rareddy Ramesh Reddy
            rhn-engineering-shawkins Steven Hawkins
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved:

                Estimated:
                Original Estimate - 4 hours
                4h
                Remaining:
                Remaining Estimate - 4 hours
                4h
                Logged:
                Time Spent - Not Specified
                Not Specified