Data ModelCData JDBC Driver for Magento 2019 - Build 19.0.7354
The CData JDBC Driver for Magento 2019 models your account as relational databases through two APIs, the Magento 1.x API and the Magento 2.x API. The Data Models described in this chapter provide examples of what your Magento environment might look like. The actual data model will be obtained dynamically based on your Magento account.
- The driver models Magento Products, Customers, Inventory, and more as relational tables, allowing you to write SQL to query Magento data.
- Stored procedures allow you to execute operations to Magento, including downloading and uploading objects.
- Live connectivity to these objects means any changes to your Magento account are immediately reflected when using the driver.
Collaborative Query Processing
The driver offloads as much of the SELECT statement processing as possible to Magento 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.
Magento 1 Data Model
See Magento 1 Data Model for the entities available when connecting to Magento 1 instances.
Magento 2 Data Model
See Magento 2 Data Model for the entities available when connecting to Magento 2 instances.