Access Through ODBC

The Microsoft Open Database Connectivity (ODBC) standard defines a C programming language interface that makes it possible for applications 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 Virtual DataPort using the JDBC driver over the ODBC one because the performance is better.

Backward Compatibility of the ODBC Driver

Virtual DataPort 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 Virtual DataPort 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 Virtual DataPort server version 8.0 GA because the driver is more recent than the server. This is an unsupported configuration; some operations could fail.

The Denodo ODBC driver of version 7.0 may be able to connect to Denodo 8.0. However, the compatibility is not guaranteed and it is an unsupported configuration. Note that you cannot install both the ODBC driver of 7.0 and 8.0 on the same computer.