Access Through ODBC

The Microsoft Open Database Connectivity (ODBC) standard defines a C programming language interface that makes it possible for applications to to access data from database management systems (DBMSs).

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 8.0u20210209, you can use the ODBC driver included in the same update or the driver included in 8.0 GA.

  • Do not use the ODBC driver included in 8.0u20210209 to connect to a Denodo server version 8.0 GA because the driver is more recent than the server. This is an unsupported configuration; some operations could fail.