The CData FireDAC Components for Azure Data Management models entities in the Azure Data Management API as tables, views, and stored procedures. These are defined in schema files, which are simple, text-based configuration files that make the schemas easy to extend.
Using Collaborative Query Processing
The component offloads as much of the SELECT statement processing as possible to the Azure Data Management APIs and then processes the rest of the query within the component. The following sections document API limitations and requirements. See SupportEnhancedSQL for more information on how the component circumvents API limitations with in-memory client-side processing.
Views are tables that cannot be modified. Typically, read-only data are shown as views.
Stored Procedures are function-like interfaces to the data source. They can be used to search, update, and modify information in the data source.