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='yes' /> <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_ALLOW_DUPLICATES' value='yes' /> <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_USAGE' value='7' /> <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_GUID' value='0' /> <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_DRIVER_ODBC_VER' value='03.52' /> <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_USAGE' value='31' /> <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_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>