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:

SAAS/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.

image1

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:

image2

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:

@SAsInSumit

www.linkedin.com/in/meetsumit

Sumit Sakar

Sumit Sarkar

Technology researcher, thought leader and speaker working to enable enterprises to rapidly adopt new technologies that are adaptive, connected and cognitive. Sumit has been working in the data access infrastructure field for over 10 years servicing web/mobile developers, data engineers and data scientists. His primary areas of focus include cross platform app development, serverless architectures, and hybrid enterprise data management that supports open standards such as ODBC, JDBC, ADO.NET, GraphQL, OData/REST. He has presented dozens of technology sessions at conferences such as Dreamforce, Oracle OpenWorld, Strata Hadoop World, API World, Microstrategy World, MongoDB World, etc.

Comments
Comments are disabled in preview mode.
Topics
Latest Stories
in Your Inbox

Subscribe to get all the news, info and tutorials you need to build better business apps and sites

More From Progress
2020 Progress Data Connectivity Report
2020 Progress Data Connectivity Report
Read More
 
232x131_resourceimage
Getting Ahead of the Hybrid Data Curve
Read More
 
autonomousrest
Creating Quick, Codeless Connectivity with Autonomous REST Connector
Read More