Application Note for QuNect ODBC for QuickBase

Working with Tableau

Please right click on the following link and choose Save As.. to download and place this QuNect.tdc file in your Documents\My Documents\My Tableau Repository\Datasources folder. To understand more about this QuNect.tdc file file please read Customizing and Tuning ODBC Connections. The contents of this file are below if you prefer to copy and paste into your text editor:

     <?xml version='1.0' encoding='utf-8' ?>
        <connection-customization class='genericodbc' enabled='true' version='9.2'>
          <vendor name='QuNect for QuickBase' />
          <driver name='QuNect ODBC for QuickBase' />
          <customizations>
            <customization name='CAP_CREATE_TEMP_TABLES' value='no' />
            <customization name='CAP_ISOLATION_LEVEL_READ_COMMITTED' value='no' />
            <customization name='CAP_ISOLATION_LEVEL_READ_UNCOMMITTED' value='no' />
            <customization name='CAP_ISOLATION_LEVEL_REPEATABLE_READS' value='no' />
            <customization name='CAP_ISOLATION_LEVEL_SERIALIZABLE' value='no' />
            <customization name='CAP_ODBC_BIND_DETECT_ALIAS_CASE_FOLDING' value='no' />
            <customization name='CAP_ODBC_BIND_FORCE_DATETIME_AS_CHAR' value='no' />
            <customization name='CAP_ODBC_BIND_FORCE_DATE_AS_CHAR' value='no' />
            <customization name='CAP_ODBC_BIND_FORCE_MAX_STRING_BUFFERS' value='no' />
            <customization name='CAP_ODBC_BIND_FORCE_MEDIUM_STRING_BUFFERS' value='no' />
            <customization name='CAP_ODBC_BIND_FORCE_SIGNED' value='no' />
            <customization name='CAP_ODBC_BIND_FORCE_SMALL_STRING_BUFFERS' value='no' />
            <customization name='CAP_ODBC_BIND_SUPPRESS_INT64' value='no' />
            <customization name='CAP_ODBC_BIND_SUPPRESS_PREFERRED_TYPES' value='no' />
            <customization name='CAP_ODBC_BIND_SUPPRESS_WIDE_CHAR' value='no' />
            <customization name='CAP_ODBC_CURSOR_DYNAMIC' value='no' />
            <customization name='CAP_ODBC_CURSOR_FORWARD_ONLY' value='no' />
            <customization name='CAP_ODBC_CURSOR_KEYSET_DRIVEN' value='no' />
            <customization name='CAP_ODBC_CURSOR_STATIC' value='no' />
            <customization name='CAP_ODBC_ERROR_IGNORE_FALSE_ALARM' value='no' />
            <customization name='CAP_ODBC_FETCH_BUFFERS_RESIZABLE' value='no' />
            <customization name='CAP_ODBC_FETCH_BUFFERS_SIZE_MASSIVE' value='no' />
            <customization name='CAP_ODBC_FETCH_CONTINUE_ON_ERROR' value='no' />
            <customization name='CAP_ODBC_METADATA_STRING_LENGTH_UNKNOWN' value='no' />
            <customization name='CAP_ODBC_METADATA_SUPPRESS_EXECUTED_QUERY' value='no' />
            <customization name='CAP_ODBC_METADATA_SUPPRESS_PREPARED_QUERY' value='no' />
            <customization name='CAP_ODBC_METADATA_SUPPRESS_SELECT_STAR' value='no' />
            <customization name='CAP_ODBC_METADATA_SUPPRESS_SQLCOLUMNS_API' value='no' />
            <customization name='CAP_ODBC_METADATA_SUPPRESS_SQLFOREIGNKEYS_API' value='no' />
            <customization name='CAP_ODBC_METADATA_SUPPRESS_SQLPRIMARYKEYS_API' value='no' />
            <customization name='CAP_ODBC_METADATA_SUPPRESS_SQLSTATISTICS_API' value='no' />
            <customization name='CAP_ODBC_REBIND_SKIP_UNBIND' value='no' />
            <customization name='CAP_ODBC_TRIM_VARCHAR_PADDING' value='no' />
            <customization name='CAP_ODBC_UNBIND_AUTO' value='no' />
            <customization name='CAP_ODBC_UNBIND_BATCH' value='no' />
            <customization name='CAP_ODBC_UNBIND_EACH' value='no' />
            <customization name='CAP_QUERY_BOOLEXPR_TO_INTEXPR' value='yes' />
            <customization name='CAP_QUERY_FROM_REQUIRES_ALIAS' value='no' />
            <customization name='CAP_QUERY_GROUP_BY_ALIAS' value='yes' />
            <customization name='CAP_QUERY_GROUP_BY_DEGREE' value='no' />
            <customization name='CAP_QUERY_HAVING_REQUIRES_GROUP_BY' value='no' />
            <customization name='CAP_QUERY_HAVING_UNSUPPORTED' value='no' />
            <customization name='CAP_QUERY_JOIN_ACROSS_SCHEMAS' value='no' />
            <customization name='CAP_QUERY_JOIN_REQUIRES_SCOPE' value='yes' />
            <customization name='CAP_QUERY_NULL_REQUIRES_CAST' value='no' />
            <customization name='CAP_QUERY_SELECT_ALIASES_SORTED' value='yes' />
            <customization name='CAP_QUERY_SORT_BY_DEGREE' value='yes' />
            <customization name='CAP_QUERY_SUBQUERIES' value='yes' />
            <customization name='CAP_QUERY_SUBQUERIES_WITH_TOP' value='no' />
            <customization name='CAP_QUERY_SUBQUERY_QUERY_CONTEXT' value='no' />
            <customization name='CAP_QUERY_TOPSTYLE_LIMIT' value='no' />
            <customization name='CAP_QUERY_TOPSTYLE_ROWNUM' value='no' />
            <customization name='CAP_QUERY_TOPSTYLE_TOP' value='yes' />
            <customization name='CAP_QUERY_TOP_0_METADATA' value='no' />
            <customization name='CAP_QUERY_TOP_N' value='yes' />
            <customization name='CAP_QUERY_WHERE_FALSE_METADATA' value='no' />
            <customization name='CAP_SELECT_INTO' value='no' />
            <customization name='CAP_SELECT_TOP_INTO' value='yes' />
            <customization name='CAP_SET_ISOLATION_LEVEL_VIA_ODBC_API' value='no' />
            <customization name='CAP_SET_ISOLATION_LEVEL_VIA_SQL' value='no' />
            <customization name='CAP_SUPPRESS_CONNECTION_POOLING' value='no' />
            <customization name='CAP_SUPPRESS_DISCOVERY_QUERIES' value='no' />
            <customization name='SQL_AGGREGATE_FUNCTIONS' value='31' />
            <customization name='SQL_CATALOG_NAME_SEPARATOR' value='' />
            <customization name='SQL_CATALOG_TERM' value='' />
            <customization name='SQL_CATALOG_USAGE' value='0' />
            <customization name='SQL_COLUMN_ALIAS' value='Y' />
            <customization name='SQL_CONVERT_BIGINT' value='32255' />
            <customization name='SQL_CONVERT_BINARY' value='261631' />
            <customization name='SQL_CONVERT_BIT' value='32255' />
            <customization name='SQL_CONVERT_CHAR' value='261631' />
            <customization name='SQL_CONVERT_DATE' value='167169' />
            <customization name='SQL_CONVERT_DECIMAL' value='32255' />
            <customization name='SQL_CONVERT_DOUBLE' value='32255' />
            <customization name='SQL_CONVERT_FLOAT' value='32255' />
            <customization name='SQL_CONVERT_FUNCTIONS' value='1' />
            <customization name='SQL_CONVERT_INTEGER' value='32255' />
            <customization name='SQL_CONVERT_INTERVAL_DAY_TIME' value='0' />
            <customization name='SQL_CONVERT_LONGVARBINARY' value='0' />
            <customization name='SQL_CONVERT_NUMERIC' value='32255' />
            <customization name='SQL_CONVERT_REAL' value='32255' />
            <customization name='SQL_CONVERT_SMALLINT' value='32255' />
            <customization name='SQL_CONVERT_TIME' value='199937' />
            <customization name='SQL_CONVERT_TIMESTAMP' value='232705' />
            <customization name='SQL_CONVERT_TINYINT' value='32255' />
            <customization name='SQL_CONVERT_VARBINARY' value='261631' />
            <customization name='SQL_CONVERT_VARCHAR' value='261631' />
            <customization name='SQL_CURSOR_COMMIT_BEHAVIOR' value='1' />
            <customization name='SQL_DATETIME_LITERALS' value='0' />
            <customization name='SQL_DBMS_NAME' value='QuNect for QuickBase' />
            <customization name='SQL_DBMS_VER' value='6.16.6.13' />
            <customization name='SQL_DRIVER_ODBC_VER' value='03.52' />
            <customization name='SQL_DRIVER_VER' value='6.16.6.13' />
            <customization name='SQL_IDENTIFIER_QUOTE_CHAR' value='"' />
            <customization name='SQL_MAX_IDENTIFIER_LEN' value='255' />
            <customization name='SQL_NUMERIC_FUNCTIONS' value='16777215' />
            <customization name='SQL_ODBC_INTERFACE_CONFORMANCE' value='1' />
            <customization name='SQL_ODBC_VER' value='03.80.0000' />
            <customization name='SQL_OJ_CAPABILITIES' value='121' />
            <customization name='SQL_QUOTED_IDENTIFIER_CASE' value='4' />
            <customization name='SQL_SCHEMA_TERM' value='' />
            <customization name='SQL_SCHEMA_USAGE' value='0' />
            <customization name='SQL_SPECIAL_CHARACTERS' value='' />
            <customization name='SQL_SQL92_DATETIME_FUNCTIONS' value='0' />
            <customization name='SQL_SQL92_NUMERIC_VALUE_FUNCTIONS' value='0' />
            <customization name='SQL_SQL92_PREDICATES' value='16135' />
            <customization name='SQL_SQL92_RELATIONAL_JOIN_OPERATORS' value='0' />
            <customization name='SQL_SQL92_STRING_FUNCTIONS' value='0' />
            <customization name='SQL_SQL92_VALUE_EXPRESSIONS' value='0' />
            <customization name='SQL_SQL_CONFORMANCE' value='1' />
            <customization name='SQL_STRING_FUNCTIONS' value='16777215' />
            <customization name='SQL_SYSTEM_FUNCTIONS' value='7' />
            <customization name='SQL_TABLE_TERM' value='table' />
            <customization name='SQL_TIMEDATE_ADD_INTERVALS' value='510' />
            <customization name='SQL_TIMEDATE_DIFF_INTERVALS' value='510' />
            <customization name='SQL_TIMEDATE_FUNCTIONS' value='2097151' />
            <customization name='SQL_TXN_CAPABLE' value='1' />
          </customizations>
        </connection-customization>