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-nexusdb.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='nexusdb' />
<driver name='Devart ODBC Driver for NexusDB' />
<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>