Magento 1 Data ModelCData JDBC Driver for Magento 2019 - Build 19.0.7354
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 are function-like interfaces to Magento. Stored procedures allow you to execute operations to Magento, including downloading and uploading objects.