Data ModelCData Excel Add-In for Office 365 2019 - Build 19.0.7354
The add-in models the Office 365 API as relational tables. Any changes to the remote data are immediately reflected in your queries; the table definitions are dynamically retrieved. When you connect, the add-in connects to Office 365 and gets the list of tables and the metadata for the tables by calling the appropriate Web services.
API limitations and requirements are documented in this section; you can use the SupportEnhancedSQL feature, set by default, to circumvent most of these limitations.
Tables shows definitions from a sample Office 365 site. The actual data model will be obtained dynamically based on your user credentials and Office 365 site.
Stored Procedures are function-like interfaces to Office365. They can be used to search, update, and modify information in Office365.