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

Data Model

CData 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.

Key Features

  • 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.

 
 
Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 19.0.7354.0