JDBC connectivity to Apache Cassandra exponentially increases throughput, decreases CPU usage and uses less memory. Here’s what to expect for a connector.
If you are planning on doing an overnight or batch process, then it’s fair to say that a generic driver would be sufficient for basic needs. However, if you want high performance out of Cassandra and your data, the DataDirect JDBC driver for Cassandra takes your connectivity to the next level.
While it is easy to think that a top tier data connector would be hard to set up and configure, that's far from the truth. Our JDBC connector is and out-of-the-box solution that enables both business users and OEM/ISV partners to easily embed the driver. Similar products do not have out-of-the-box functionality and are much more complicated to set up.
Business intelligence applications require certain features in order to work properly. Some of these include support for batch processing, JDBC subqueries, sorting/filtering binary data and TUPLE & UDT data types. Many JDBC connectors do not include these features or are limited to only a few. Our Cassandra JDBC connector includes all of them right from the start.
When dealing with JDBC connectivity, there are two ways to generate reliable schema. The less accurate method is data sampling. The most accurate method, which leads to the best insights, is the use of database metadata. Most companies in this space create JDBC connectors that generate schema through data sampling. We take no shortcuts and generate ours via database metadata for the most accurate results possible.
If you are interested in taking your Cassandra connectivity to the next level, pick up a free trial today! Your connector will be enterprise capable, predictable and easy to implement. In other words, it will…
We value you and we hope we can help you meet your data connectivity goals. Feel free to reach out to 1-800-477-6473 if you have any questions and download a free trial if you want to give it a test run yourself!
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 © 2018 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.