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.
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.
Get started with DataDirect Cloud for instant JDBC access to VDP data sources from cloud applications.
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.
Download a trial of the DataDirect Postgres ODBC driver for Denodo across Windows, Linux, AIX, Solaris, or HP-UX.
Contact us if you have any questions or find me on social media:
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.
Subscribe to get all the news, info and tutorials you need to build better business apps and sites
You have the right to request deletion of your Personal Information at any time.
You can also ask us not to pass your Personal Information to third parties here: Do Not Sell My Info
Let our experts teach you how to use Sitefinity's best-in-class features to deliver compelling digital experiences.