CData JDBC Driver for Smaregi 2019 - Online Help
Questions / Feedback?

Data Model

CData JDBC Driver for Smaregi 2019 - Build 19.0.7236


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

Key Features

  • The driver models Smaregi entities like products, customers, and shippings as relational tables, allowing you to write SQL to query and modify Smaregi data.
  • Live connectivity to these objects means any changes to your Smaregi account are immediately reflected when using the driver.


Tables describes the available tables. Table are statically defined to model Products, Customers, Shippings, and more.


Views describes the available views. Views are statically defined to model Stores, ShippingDetails and more. Views may not be modified, but can be used to supplement queries to the tables.

Collaborative Query Processing

The driver offloads as much of the SELECT statement processing as possible to Smaregi 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) 2019 CData Software, Inc. - All rights reserved.
Build 19.0.7236.0