Access Through ODBC

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

Virtual DataPort provides an ODBC interface and an ODBC driver. This ODBC driver is based on the ODBC PostgreSQL driver version 09.03.

By using an ODBC driver, we can use applications query 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 one for two reasons:

  1. The performance of the JDBC driver is better.
  2. To use the Denodo ODBC driver from an application that runs on Linux, you have to compile it. The JDBC driver is ready to work on any platform and architecture.