September 30, 2020 By jason-mcalpin < 1 min read

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.

More from Analytics

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.…

In preview now: IBM watsonx BI Assistant is your AI-powered business analyst and advisor

3 min read - The business intelligence (BI) software market is projected to surge to USD 27.9 billion by 2027, yet only 30% of employees use these tools for decision-making. This gap between investment and usage highlights a significant missed opportunity. The primary hurdle in adopting BI tools is their complexity. Traditional BI tools, while powerful, are often too complex and slow for effective decision-making. Business decision-makers need insights tailored to their specific business contexts, not complex dashboards that are difficult to navigate. Organizations…

IBM unveils Data Product Hub to enable organization-wide data sharing and discovery

2 min read - Today, IBM announces Data Product Hub, a data sharing solution which will be generally available in June 2024 to help accelerate enterprises’ data-driven outcomes by streamlining data sharing between internal data producers and data consumers. Often, organizations want to derive value from their data but are hindered by it being inaccessible, sprawled across different sources and tools, and hard to interpret and consume. Current approaches to managing data requests require manual data transformation and delivery, which can be time-consuming and…

IBM Newsletters

Get our newsletters and topic updates that deliver the latest thought leadership and insights on emerging trends.
Subscribe now More newsletters