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¶
You can connect to Virtual DataPort version 9 with the ODBC driver of the version 8.0.
You can connect to Virtual DataPort version 8.0 with the ODBC driver of the version 9.
Note
The backward and forward compatibility of the drivers makes the process of upgrading to 9 smoother. However, once you complete the upgrade to 9 and retire the 8.0 servers, we strongly advice to use just the drivers of the version 9. Very likely, we will add improvements to the drivers of the latest version but not for previous versions.
The Denodo ODBC driver of version 7.0 may be able to connect to Denodo 9 and to 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.
See more about this topic in the page Backward Compatibility Between the Virtual DataPort Server and Its Clients.