A JDBC Driver for Infinite Data

Today, we are announcing the General Availability of SQL Query’s JDBC Driver.

This allows you to take advantage of the power of serverless analytics and data transformation with the effectively limitless storage capacity of IBM Cloud Object Storage.

Through the IBM SQL Query service, IBM Cloud Object Storage is well equipped to directly serve SQL jobs on open data formats, be it for data transformation or be it for analytic queries. With the just-released JDBC Driver, it is now possible to run SQL jobs directly on object storage data from many standard applications, such as for instance BI tools like Tableau. In addition, you can build your JDBC applications for instance in Java.

How to use the JDBC Driver

Using the JDBC Driver is very straight forward—just download the jar file of the latest driver version and install it into your application. Then, configure the according JDBC URL and an IAM API Key for your IBM Cloud account user or service ID. That’s it.

All communication through the Driver to IBM Cloud to submit and run the SQL job, read the data from the desired cloud object storage buckets, and persist results of SQL ETL jobs to a defined target on object storage is done in a single-sign-on fashion with the IAM API Key.

The JDBC Driver is fully integrated with the hive metastore of IBM SQL Query. So all table and view definitions are properly exposed through the JDBC Driver so that BI applications like Tableau or relational database tools like DBeaver display the available input data sets like for any other RDBMS.

Learn more

Further details for downloading and using the JDBC Driver can be found here.

Torsten Steinbach

Distinguished Engineer & CTO, Big Data in Cloud

IBM acquires StreamSets, a leading real-time data integration company

3 min read - We are thrilled to announce that IBM has acquired StreamSets, a real-time data integration company specializing in streaming structured, unstructured and semistructured data across hybrid multicloud environments. Acquired from Software AG along with webMethods, this strategic acquisition expands IBM's already robust data integration capabilities, helping to solidify our position as a leader in the data integration market and enhancing IBM Data Fabric’s delivery of secure, high-quality data for artificial intelligence (AI). According to a Forrester study conducted on behalf of…

Fine-tune your data lineage tracking with descriptive lineage

4 min read - Data lineage is the discipline of understanding how data flows through your organization: where it comes from, where it goes, and what happens to it along the way. Often used in support of regulatory compliance, data governance and technical impact analysis, data lineage answers these questions and more. Whenever anyone talks about data lineage and how to achieve it, the spotlight tends to shine on automation. This is expected, as automating the process of calculating and establishing lineage is crucial to…

Reimagine data sharing with IBM Data Product Hub

3 min read - We are excited to announce the launch of IBM® Data Product Hub, a modern data sharing solution designed to accelerate data-driven outcomes across your organization. Today, we're making this product generally available to our clients across the world, following its announcement at the IBM Think conference in May 2024. Data sharing has become the lifeblood of modern organizations, fueling growth and driving innovation. But traditional approaches to data sharing can often be a bottleneck constricting the seamless sharing of data.…

Today, we are announcing the General Availability of SQL Query’s JDBC Driver.

How to use the JDBC Driver

Learn more

More from Analytics

IBM acquires StreamSets, a leading real-time data integration company

Fine-tune your data lineage tracking with descriptive lineage

Reimagine data sharing with IBM Data Product Hub

IBM Newsletters