New Denodo VDP JDBC Data Sources and VDP ODBC Driver

New Denodo VDP JDBC Data Sources and VDP ODBC Driver

November 02, 2015 0 Comments

Denodo shops are rapidly expanding their data virtualization options with DataDirect across ODBC and JDBC data connectivity.  With JDBC, Denodo shops are instantly expanding their virtualization footprints in a hybrid cloud/on-premise world using DataDirect Cloud JDBC connectivity with Virtual DataPort data sources. With ODBC, shops are interested in improved application compatibility and performance using the commercial DataDirect Postgres ODBC driver as the VDP ODBC client. 

Expand Virtual DataPort (VDP) JDBC Data Sources with Denodo

Denodo professionals have traditionally considered JDBC connectivity for relational databases. However, DataDirect Cloud is a Connectivity Platform as a Service (cPaaS) that extends seamless JDBC connectivity to a wide range of data sources beyond relational, including those in the cloud:


This is done by creating VDP JDBC data sources using a single DataDirect Cloud JDBC client, and used in lieu of manually creating data sources for REST/SOAP web services (“CREATE DATASOURCE WS”) in Denodo. The DataDirect Cloud service handles SaaS API upgrades transparently for the JDBC client.


DataDirect Cloud also offers JDBC connectivity to TCP data sources that require access securely through a firewall without exposing a TCP port (i.e. SQL or NoSQL over HTTPS). These sources include hosted relational, big data, or nosql data sources.

You can find a complete JDBC source list here.

Ready to Get Started with Denodo and DataDirect JDBC Connectivity?

Get started with DataDirect Cloud for instant JDBC access to VDP data sources from cloud applications.

Upgrade ODBC Experience with Denodo on Front End

The communication protocol from SQL based applications to the Denodo Platform is based on the PostgreSQL protocol. Most shops are running the open source PostgreSQL ODBC driver, which is a great community option. However, certain workloads require a commercial solution and DataDirect builds the fastest Postgres ODBC connector in the world.

Below are some numbers from our performance lab. Our lab runs tests 24/7 to ensure we've got the fastest drivers on the market, and we’re seeing gains across throughput, CPU usage and memory utilization improvements by up to 10,000% across multiple users for large multi-user reports. These are the kind of reports we would expect from applications such as SAP Business Objects, IBM Cognos, OBIEE, Microstrategy, Information Builders, Qlik or Tableau:


The summary above illustrates the DataDirect advantage for throughput across different application workloads that are popular with Denodo ODBC connectivity.

Ready to Get Started with Denodo and DataDirect ODBC Connectivity?

Download a trial of the DataDirect Postgres ODBC driver for Denodo across Windows, Linux, AIX, Solaris, or HP-UX.

Let’s connect:

Contact us if you have any questions or find me on social media:


Sumit Sakar

Sumit Sarkar

Sumit Sarkar is a Chief Data Evangelist at Progress, with over 10 years experience working in the data connectivity field. The world's leading consultant on open data standards connectivity with cloud data, Sumit's interests include performance tuning of the data access layer for which he has developed a patent pending technology for its analysis; business intelligence and data warehousing for SaaS platforms; and data connectivity for aPaaS environments, with a focus on standards such as ODBC, JDBC, ADO.NET and ODATA. He is an IBM Certified Consultant for IBM Cognos Business Intelligence and TDWI member. He has presented sessions on data connectivity at various conferences including Dreamforce, Oracle OpenWorld, Strata Hadoop, MongoDB World and SAP Analytics and Business Objects Conference, among many others. 

Comments are disabled in preview mode.
Latest Stories in
Your Inbox
More From Progress
OData: The Fastest Way to RESTify Your Databases
OData: The Fastest Way to RESTify Your Databases
Download Whitepaper
The Business Value of Kinvey
Download Whitepaper
Finding App ROI Through Time And Money
Watch Webinar