Increasing the Performance of 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';

Important

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.