ODBC Driver for QuickBase

Build 20.0.7654

Data Model

Overview

This section shows the available API objects and provides more information on executing SQL to QuickBase APIs.

Key Features

  • The driver models QuickBase entities like documents, folders, and groups as relational views, allowing you to write SQL to query QuickBase data.
  • Stored procedures allow you to execute operations to QuickBase
  • Live connectivity to these objects means any changes to your QuickBase account are immediately reflected when using the driver.

Tables

Tables are automatically determined from the QuickBase.

Views

Views will be listed for table reports if IncludeTableReports is set to true.

Stored Procedures

Stored Procedures are function-like interfaces to QuickBase. Stored procedures allow you to execute operations to QuickBase, including downloading documents and moving envelopes.

Collaborative Query Processing

The driver offloads as much of the SELECT statement processing as possible to QuickBase 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