ODBC Driver for Oracle

Troubleshooting in Tableau - ODBC Driver for Oracle

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' />
          <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' />

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:

<customization name='CAP_ODBC_BIND_SUPPRESS_WIDE_CHAR' value='yes' />
© 2015-2022 Devart. All Rights Reserved. Request Support ODBC Forum Provide Feedback