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

Need Excel file importer / connector

    XMLWordPrintable

Details

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

    Description

      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

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

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