Access Through ODBC

ODBC (Microsoft Open DataBase Connectivity) is a standard API specification for using database management systems.

Denodo provides an ODBC driver for Windows and Linux and it also provides the source code to build the driver for other platforms. This driver is based on the ODBC PostgreSQL driver version 09.05.

With this ODBC driver, you can connect to Virtual DataPort from applications that do not support JDBC, such as Excel.

Note

We recommend connecting to the Virtual DataPort server using the JDBC driver over the ODBC because the performance is better.

Backward Compatibility of the ODBC Driver

The Virtual DataPort server is backward compatible with the ODBC driver and other clients, within the same major version. That is, the Denodo ODBC driver of an update can be used to connect to the Virtual DataPort server with the same update or a newer update. For example:

  • To connect to a Denodo server version 7.0 update 20181011, you can use the ODBC driver included in the same update or the driver included in 7.0 20180926, 7.0 20180611 or 7.0 GA.
  • Do not use the ODBC driver included in 7.0 20181011 to connect to a Denodo server version 7.0 update 20180926 because the driver is more recent than the server. This is an unsupported configuration; some operations could fail.