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.