JDBC Driver for Magento

Build 21.0.8137

Data Model

The CData JDBC Driver for Magento models your account as relational databases through 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.

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8137