Magento 2 Data ModelCData JDBC Driver for Magento 2019 - Build 19.0.7354
The CData JDBC Driver for Magento 2019 models entities in the Magento 2.x APIs as Tables and Stored Procedures. The following sections provide information on executing SQL to the available API objects.
Dynamic Schema Discovery
You can use the driver to access all of the entities in your Magento account. The driver models the Magento 2 APIs as dynamic tables. Tables shows the sample table definitions that are included in the Magento development environment.
Any changes you make to the table definitions in Magento, such as adding a custom field or changing a data type, are reflected when you reconnect. When you connect, the driver generates table schemas based on metadata requests to the appropriate web services.
Tables describes the available tables. Tables are statically defined to model Customers, Inventory, Stores, and more.
Stored Procedures are function-like interfaces to the data source. They can be used to search, update, and modify information in the data source.