Data ModelCData 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.
- 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.