Deliver Awesome UI with the most complete toolboxes for .NET, Web and Mobile development
Automate UI, load and performance testing for web, desktop and mobile
Rapidly develop, manage and deploy business apps, delivered as SaaS in the cloud
Build, protect and deploy apps across any platform and mobile device
Automate decision processes with a no-code business rules engine
A complete cloud platform for an app or your entire digital business
Deploy automated machine learning to accurately predict machine failures with technology optimized for Industrial IoT.
Optimize data integration with high-performance connectivity
Connect to any cloud or on-premises data source using a standard interface
Build engaging multi-channel web and digital experiences with intuitive web content management
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:
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.
Copyright © 2017 Progress Software Corporation and/or its subsidiaries or affiliates.
All Rights Reserved.
Progress, Telerik, and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S. and/or other countries. See Trademarks for appropriate markings.