[teiid-issues] [JBoss JIRA] Updated: (TEIID-999) Create valid capabilities support for MS Excel and MS Access JDBC-ODBC Connectors

Create valid capabilities support for MS Excel and MS Access JDBC-ODBC Connectors --------------------------------------------------------------------------------- Key: TEIID-999 URL: https://jira.jboss.org/browse/TEIID-999 Project: Teiid Issue Type: Feature Request Components: Misc. Connectors Environment: MS Excel 2003 Reporter: Larry O'Leary Fix For: 7.2 Original Estimate: 4 hours Remaining Estimate: 4 hours Create a capabilities set that can be used by the MS Access and MS Excel connectors. We currently offer the MS Excel connector which is using the generic JDBC capabilities and translators and the MS Access connector which is using its own capabilities and translators but they do not reflect MS Access. The replacement connector types should work very much like the current ones but reflect the base capabilities offered by MS JET 4 and specific capabilities as defined by the MS Excel and MS Access limitations to the MS JET 4 implementation. At bare minimum we should support push-down of all currently defined capabilities and remove any current ones that are not valid for MS JET/MS Access/MS Excel.