<connection-customization class='genericodbc' enabled='true' version='8.3'>
<vendor name='OpenAccess' />
<driver name='DataDirect OpenAccess SDK 8.0' />
<customization name='CAP_CREATE_TEMP_TABLES' value='no' />
<customization name='CAP_ISOLATION_LEVEL_READ_COMMITTED' value='no' />
1. Install OpenAccess server and ODBC client for your environment.
2. For Tableau Desktop , copy the provided TDC file (odbc-openaccess.tdc) at following location
C:\Users\<username>\Documents\My Tableau Repository\Datasources
3. Restart the Tableau (close and reopen to apply the changes).
4. In Tableau Desktop, create a new connection to OpenAccess DataSource.
5. Open the Tableau Desktop log file ( Default location at C:\Users\<user>\Documents\My Tableau Repository\Logs\log.txt), and look for a record similar to the example below to verify that this customization file was applied to your new connection.
This confirms that Tableau will use the customizations provided in the TDC file when working with the OpenAccess data source.
1. Open the provided TDC file and edit the following properties:
<customization name='SQL_DBMS_NAME' value='OpenAccess' />
<customization name='SQL_DBMS_VER' value='08.00' />
<customization name='SQL_DRIVER_VER' value='8.0.0.0017' />
· Vendor Name – Database Vendor Name of the ODBC Driver. This should match the value returned by driver for SQLGetInfo(“SQL_DBMS_NAME”). Change it to the value returned by IP getDSInfo(SQL_DBMS_NAME).
· Driver name – ODBC Driver Name. This is the Driver name which is also displayed in the ODBC Administrator tool as shown below.
· SQL_DRIVER_VER—ODBC Driver Version Information which is also displayed in the ODBC Administrator tool. It can also be get from SQLGetInfo Call “SQL_DRIVER_VER”
· SQL_DBMS_NAME - Same as Vendor Name
· SQL_DBMS_VER – Database version Information. This should match the value returned by driver for SQLGetInfo( Call “SQL_DBMS_VER”). Change it to the value returned by IP getDSInfo(SQL_DBMS_VER).
2. Save the TDC file as odbc-mydb.tdc and follow the same steps mentioned for OpenAccess ODBC driver.
Note: Refer to the following Tableau article to learn more on how to customize and tune ODBC connections
You can now enjoy improved functionality and performance when using Tableau!!