Troubleshooting ODBC Connection in Tableau
The default Tableau settings limit the number of rows to be retrieved through an ODBC connection to 1,000. To overcome this limitation, create a Tableau Datasource Customization (
.tdc) file in '
Users\[your name]\Documents\My Tableau Repository\Datasources\' — for example,
devart-oracle.tdc, and add the following capabilities to the file:
<?xml version='1.0' encoding='utf-8' ?>
<connection-customization class='genericodbc' enabled='true' version='1.0'>
<vendor name='oracle' />
<driver name='Devart ODBC Driver for Oracle' />
<customizations>
<customization name='CAP_QUERY_TOPSTYLE_ROWNUM' value='no' />
<customization name='CAP_QUERY_TOP_N' value='no' />
<customization name='CAP_QUERY_TOPSTYLE_LIMIT' value='no' />
<customization name='CAP_QUERY_TOPSTYLE_TOP' value='yes' />
<customization name='CAP_SELECT_TOP_INTO' value='no' />
</customizations>
</connection-customization>
Troubleshooting ODBC Connection in Tableau on macOS
The iODBC driver manager incorrectly handles the SQL_WCHAR and SQL_WVARCHAR ODBC data types. To work with these data types in Tableau, define an additional capability:
<?xml version='1.0' encoding='utf-8' ?>
<connection-customization class='genericodbc' enabled='true' version='1.0'>
<vendor name='Oracle' />
<driver name='Devart ODBC Driver for Oracle' />
<customizations>
<customization name='CAP_ODBC_BIND_SUPPRESS_WIDE_CHAR' value='yes' />
</customizations>
</connection-customization>
