Performance tests reveal that the Progress DataDirect Sequelink JDBC-ODBC adapter is up to 310% faster than the Sun JDBC-ODBC bridge.
The DataDirect Sequelink JDBC-ODBC adapter serves as the trusted replacement for the JDBC-ODBC bridge. Even Oracle Data Integration recommends DataDirect SequeLink, after deprecating the JDBC-ODBC bridge in JDK 8. This adapter is extremely useful when you need connectivity to legacy data sources or when organizations need JDBC connectivity and only ODBC drivers are available.
Conversely, the DataDirect SequeLink ODBC-JDBC adapter serves as the adapter for scenarios where ODBC access is required, and only JDBC drivers exist, such as Apache Solr, Apache Phoenix or Neo4j.
As organizations turn to DataDirect for a JDBC-ODBC bridge replacement, we wanted to provide some performance indications so you can consider a replacement before moving to JDK 8. Our developer evangelist, Saikrishna Teja Bobba, ran the following tests.
To evaluate the performance of these drivers, I have used the following setup.
Plot of Time taken (in milliseconds) vs Number of records that are pulled through using JDBC-ODBC bridge drivers
(Lower is Better)
From these numbers you can see that DataDirect Sequelink JDBC-ODBC adapter is 3X times faster than the Sun JDBC-ODBC drivers. Along with Oracle recommending us as a replacement to the Sun JDBC-ODBC bridge, we add production ready quality and improved performance for your application as part of this transition.
We tested these JDBC-ODBC bridges with data pull loads of 300K, 600K and 1 million records. For each load, the test was performed three times and an average value was calculated. This testing mechanism was configured in Apache Jmeter and the average latency values were recorded from there.
The reason we used the Native MySQL ODBC driver was to have a fair competition between the drivers. We didn’t want people to think that our Sequelink JDBC-ODBC bridge driver had an advantage because we used our in-house MySQL drivers.
If you're wondering whether our DataDirect MySQL drivers are in fact faster than Native MySQL drivers—the answer is yes. You can read this blog where we published the results of a comparison between the DataDirect MySQL driver and the Native MySQL driver.
The main purpose of this performance test was to calculate how fast these JDBC-ODBC bridges could communicate JDBC calls to the ODBC API and get the data. To put it simply, we are only interested in calculating the overhead when using these bridges. We are not interested in how fast these data sources can serve the results.
Learn more and start a trial of the DataDirect Sequelink JDBC-ODBC adapter.
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.
Subscribe to get all the news, info and tutorials you need to build better business apps and sites
Copyright © 2019 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.