Application Note for QuNect ODBC for Quick Base

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 Quick Base' />
          <driver name='QuNect ODBC for Quick Base' />
          <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 Quick Base' />
            <customization name='SQL_DBMS_VER' value='6.18.7.32' />
            <customization name='SQL_DRIVER_ODBC_VER' value='03.52' />
            <customization name='SQL_DRIVER_VER' value='6.18.7.32' />
            <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.52.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>