Denodo Platform is based on a client-server architecture, where clients issue statements to the server written in VQL (Virtual Query Language), a SQL-like language used to query and define data views. Client applications can access Denodo Platform in several ways:
- Access Through Arrow Flight-SQL (since Denodo Platform 9)
- Using the JDBC interface (Java Database Connectivity). You can download a JDBC driver that client applications can use for this purpose.
- Using the ODBC interface (Open Database Connectivity). You can download an ODBC driver for ODBC client applications.
- Using an ADO.NET Data Provider.
- Using the SOAP and REST Web service interfaces. For using these endpoints you don't need a driver, just connect to the endpoint deployed in Denodo Platform.
Here you can find JDBC / ODBC drivers for Denodo Platform 7.0 version and greater. Remember to select the appropriate driver for your Denodo Platform installation (major version + update).
Virtual DataPort implements the Arrow Flight SQL Protocol, allowing connections from clients interacting with this protocol independently of its underlying programming language.
Arrow Flight SQL DriversThe Virtual DataPort server is backward compatible with the JDBC driver, within the same major version. That is, you can use the JDBC driver of an update to connect to a Virtual DataPort server that has the same or a newer update installed.
JDBC DriversThe Virtual DataPort server is backward compatible with the ODBC driver, within the same major version. That is, you can use the Denodo ODBC driver of an update to connect to the Virtual DataPort server with the same update or a newer update.
ODBC DriversADO.Net data providers are software components that allow their users to develop applications that are independent of the database they want to use.
ADO.NET Drivers