Was this page helpful?
Yes No
Have a comment? Please leave it here. Thanks for your feedback!
All Tableau Help > Tableau Help > 
Reference > Connector Examples > Other Databases (ODBC) > ODBC/SQL Customizations Reference
Applies to: Tableau Desktop

ODBC/SQL Customizations Reference

You can set the following customizations in the Tableau Datasource Customization (TDC) file to define parts of the ODBC and SQL standards that the ODBC driver supports.

In this article

Documentation resources for SQLGetInfo

SQLGetInfo long-integer values

SQLGetInfo short-integer values

SQLGetInfo string values

Documentation resources for SQLGetInfo

The names of these customizations come from the identifiers used as parameters to SQLGetInfo.

For more information, see the MSDN documentation and the source code header file sqlext.h for the numeric and bit-mask values associated with each customization.

SQLGetInfo long-integer values

SQL_ODBC_INTERFACE_CONFORMANCE Currently unused.
SQL_SQL_CONFORMANCE Integer bitmask. Defines the level which the data source conforms to the SQL standard: '1' for entry-level SQL-92 conformance, '2' for FIPS 127-2 transitional, '4' for Intermediate and '8' for Full conformance.
SQL_CATALOG_USAGE Integer bitmask. Defines the SQL statements in which a catalog identifier can be used.
SQL_SCHEMA_USAGE Integer bitmask. Defines the SQL statements in which a schema identifier can be used.
SQL_AGGREGATE_FUNCTIONS Integer bitmask. Defines which standard SQL aggregation forms are supported.
SQL_NUMERIC_FUNCTIONS Integer bitmask. Defines which SQL scalar numeric functions are supported.
SQL_STRING_FUNCTIONS Integer bitmask. Defines which SQL scalar string functions are supported.
SQL_TIMEDATE_FUNCTIONS Integer bitmask. Defines which SQL scalar date / time functions are supported.
SQL_TIMEDATE_ADD_INTERVALS Integer bitmask. Defines which date / time intervals are supported with the TIMESTAMPADD scalar function.
SQL_TIMEDATE_DIFF_INTERVALS Integer bitmask. Defines which date / time intervals are supported with the TIMESTAMPDIFF scalar function.
SQL_DATETIME_LITERALS Integer bitmask. Defines which SQL-92 literals are supported for representing DATE / TIME constants and INTERVALs.
SQL_SYSTEM_FUNCTIONS Integer bitmask. Defines support for special SQL system scalar functions: IFNULL, DBNAME and USERNAME.
SQL_SQL92_VALUE_EXPRESSIONS Integer bitmask. Defines which logical functions are supported for testing and manipulating values: CASE, CAST and NULLIF.
SQL_SQL92_NUMERIC_VALUE_FUNCTIONS Integer bitmask. Defines which functions can produce a numeric value from non-numeric data, including: EXTRACT (for date / time part extraction), CHAR_LENGTH, CHARACTER_LENGTH and POSITION(.. IN ..).
SQL_SQL92_STRING_FUNCTIONS Integer bitmask. Defines which string manipulation functions are supported.
SQL_SQL92_DATETIME_FUNCTIONS Integer bitmask. Defines which date / time manipulation functions are supported for determining the current date, time or timestamp.
SQL_OJ_CAPABILITIES Integer bitmask. Defines which type of outer joins are supported.
SQL_SQL92_RELATIONAL_JOIN_OPERATORS Integer bitmask. Defines which types of JOIN operators are supported, e.g. INNER, OUTER.
SQL_SQL92_PREDICATES Integer bitmask. Defines which predicates are supported for logical tests of values, e.g. IS NULL, LIKE, IN.
SQL_CONVERT_FUNCTIONS Integer bitmask. Defines which ODBC scalar functions are supported for CASTing or CONVERTing one data type to another.
SQL_CONVERT_TINYINT Integer bitmask. Determines which other data types that this named type can be converted to using the ODBC scalar function CONVERT.
SQL_CONVERT_SMALLINT Integer bitmask. Same as above.
SQL_CONVERT_INTEGER Integer bitmask. Same as above.
SQL_CONVERT_BIGINT Integer bitmask. Same as above.
SQL_CONVERT_REAL Integer bitmask. Same as above.
SQL_CONVERT_FLOAT Integer bitmask. Same as above.
SQL_CONVERT_DOUBLE Integer bitmask. Same as above.
SQL_CONVERT_CHAR Integer bitmask. Same as above.
SQL_CONVERT_VARCHAR Integer bitmask. Same as above.
SQL_CONVERT_LONGVARCHAR Integer bitmask. Same as above.
SQL_CONVERT_DECIMAL Integer bitmask. Same as above.
SQL_CONVERT_NUMERIC Integer bitmask. Same as above.
SQL_CONVERT_BIT Integer bitmask. Same as above.
SQL_CONVERT_GUID Integer bitmask. Same as above.
SQL_CONVERT_BINARY Integer bitmask. Same as above.
SQL_CONVERT_VARBINARY Integer bitmask. Same as above.
SQL_CONVERT_LONGVARBINARY Integer bitmask. Same as above.
SQL_CONVERT_DATE Integer bitmask. Same as above.
SQL_CONVERT_TIME Integer bitmask. Same as above.
SQL_CONVERT_TIMESTAMP Integer bitmask. Same as above.
SQL_CONVERT_INTERVAL_DAY_TIME Integer bitmask. Same as above.

SQLGetInfo short-integer values

SQL_CURSOR_COMMIT_BEHAVIOR Short integer value. “0” if the prepared statements are closed upon commit for the data source.
SQL_MAX_IDENTIFIER_LEN Integer value. Defines the maximum number of characters that can be used in an identifier. Tableau leaves room for one extra character as the string terminator.
SQL_TXN_CAPABLE Short integer value. “0” if the data source does not support the transaction.
SQL_QUOTED_IDENTIFIER_CASE Integer bitmask.

SQLGetInfo string values

SQL_COLUMN_ALIAS Boolean value. "Y" if the data source supports using aliases for columns listed in the SELECT clause.
SQL_IDENTIFIER_QUOTE_CHAR String value. Indicates the character which can be used for quoting identifiers. Because the connection customization is an XML document, any entities must properly be encoded. For example, double-quotes will be '"'. Additionally this character is assumed to work as the opening and closing character around identifiers, so some data sources which require '[]' to enclose identifiers will not be supported.
SQL_CATALOG_NAME_SEPARATOR Character value. Indicates the separator character to use between identifiers when qualifying them with a catalog, schema or table name. This is typically the period character.
SQL_SPECIAL_CHARACTERS String value. Indicates the special characters which are allowed in identifier strings.
SQL_CATALOG_TERM String value. This is the descriptive term for a database catalog, which appears in the Tableau connection dialog for this ODBC data source.
SQL_SCHEMA_TERM String value. This is the descriptive term for a database schema, which appears in the Tableau connection dialog for this ODBC data source.
SQL_TABLE_TERM String value. This is the descriptive term for a database table, which appears in the Tableau connection dialog for this ODBC data source.
SQL_DRIVER_NAME String value. This is the name of the database ODBC driver.
SQL_DRIVER_VER String value. This is the version number of the ODBC driver.
SQL_DRIVER_ODBC_VER String value. This is the version of the ODBC API which the driver supports.
SQL_ODBC_VER String value. This is the version of ODBC which the Windows ODBC Driver Manager supports. This should not need to be customized.
SQL_DBMS_NAME String value. This is the name of the database vendor.
SQL_DBMS_VER String value. This is the version of the database system.
SQL_SERVER_NAME String value. This is the named network address of the database server.
SQL_USER_NAME String value. This is the name of the currently authenticated user.

See also

Other Databases (ODBC) – Describes how to connect to your data using the ODBC connector.

Tableau and ODBC – Provides background information about ODBC, describes how Tableau determines the functionality of an ODBC driver, and lists frequently asked questions.

Customize and Tune ODBC Connections – Describes how to fine tune the ODBC connection information for improved functionality and performance.

Tableau Capability Customizations Reference – Lists customizations you can use to define which Tableau capabilities are supported by the data source.