ODBC Driver for QuickBase

Build 20.0.7587

Data Model

Overview

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

Key Features

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

Tables

Tables are automatically determined from the Quick Base.

Views

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

Stored Procedures

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

Collaborative Query Processing

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