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

Magento 1 Data Model

CData JDBC Driver for Magento 2019 - Build 19.0.7354

The driver models entities in the Magento 1.x APIs as Tables, Views, and Stored Procedures. This section describes how to execute SQL queries to the available API objects.

Accessing Unique Entity Attributes

Most Table and View schemas are defined in schema files, which are simple, text-based configuration files. However, the Products table returns additional columns based on the object's attributes. For example, clothing products will also have Gender, Size, and Sleeve_Length attributes in addition to the standard columns.


Tables describes the available tables. Tables are statically defined to model Customers, Inventory, ProductCategories, and more.

To discover these columns, the driver can retrieve and scan a specified number of objects. You can configure the scan with the TypeDetectionScheme and RowScanDepth properties.


Views are available for read-only access to data from Magento, including Orders and OrderItems.

Stored Procedures

Stored Procedures are function-like interfaces to Magento. Stored procedures allow you to execute operations to Magento, including downloading and uploading objects.

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