Increasing the Performance of the Denodo ODBC Driver


This section describes an option that has been deprecated and has been removed in Denodo 7.0. The speed improvement provided by this option is insignificant and after enabling it, ODBC clients only can use the Denodo ODBC driver.

To increase the speed at which the Denodo ODBC driver returns numeric values, do the following:

  1. Log in to the Virtual DataPort Administration Tool as an administrator user.

  2. From the VQL Shell, execute this:

SET 'com.denodo.vdb.vdbinterface.server.odbc.forceBinaryTypes' = 'true';


Only set this property if all the clients that connect to Denodo through the ODBC interface use the Denodo ODBC driver. The connections opened from clients that use a different ODBC driver will crash.

Add feedback