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, create a Tableau Datasource Customization (.tdc) file in 'Users\[your name]\Documents\My Tableau Repository\Datasources\' — for example, devart-mysql.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='MySQL' />
<driver name='Devart ODBC Driver for MySQL' />
<customizations>
<customization name='CAP_ODBC_BIND_SUPPRESS_WIDE_CHAR' value='yes' />
</customizations>
</connection-customization>
