Excel Add-In for QuickBooks

Build 21.0.7930

Data Model

The CData Excel Add-In for QuickBooks models entities in the QuickBooks API as tables, views, and stored procedures. There are three parts to the Data Model: Tables, Views, and Stored Procedures. These are defined in schema files, which are simple, text-based configuration files.

API limitations and requirements are documented in this section; you can use the SupportEnhancedSQL feature, set by default, to circumvent most of these limitations.


The CData Excel Add-In for QuickBooks models the data in Tables so that it can be easily queried and updated.

NOTE: In case of Bulk insert operation, our driver supports multiple values only for the aggregate columns whereas for the other columns only single value is supported.


Views are tables that cannot be modified. Typically, read-only data are shown as views.

Stored Procedures

Stored Procedures are function-like interfaces to the data source. They can be used to search, update, and modify information in the data source.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930