The CData Excel Add-In for Google Calendar models Google Calendar APIs as relational tables, views, and stored procedures. API limitations and requirements are documented in this section; you can use the SupportEnhancedSQL feature, set by default, to circumvent most of these limitations.
The add-in dynamically retrieves table definitions for the calendars accessible to your account. Tables describes the columns for a sample calendar as well as the Calendars table, which can be used to list, create, modify, and delete calendars.
Views offer additional metadata information from Google Calendar to surface other aspects of a calendar.
Stored Procedures are function-like interfaces to the data source.