ODBC Driver for IBM Cloud Object Storage

Build 20.0.7654

Data Model

This section describes how the driver models the IBM Cloud Object Storage API as relational Views and Stored Procedures.

Key Features

  • The driver models IBM Cloud Object Storage buckets, bucket information, and objects as relational views, allowing you to write SQL to query IBM Cloud Object Storage data.
  • Stored procedures allow you to execute operations to IBM Cloud Object Storage, including downloading and uploading objects.
  • Live connectivity to these objects means any changes to your IBM Cloud Object Storage account are immediately reflected when using the driver.

Views

Pre-defined Views are available for read only access to data from IBM Cloud Object Storage, including Buckets, Services, and Objects.

Stored Procedures

Stored procedures allow you to execute operations to IBM Cloud Object Storage, including downloading and uploading objects.

System Tables

System Tables contains information about the objects and resources belonging to your database.

Collaborative Query Processing

The driver offloads as much of the SELECT statement processing as possible to IBM Cloud Object Storage and then processes the rest of the query in memory. API limitations and requirements are also documented in this section.

See SupportEnhancedSQL for more information on how the driver circumvents API limitations with in-memory client-side processing.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654