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