Data Model
Discovering Schemas
The CData Excel Add-In for Zoho Creator dynamically obtains the Zoho Creator Schemas. Reconnect to pick any metadata changes, such as added or removed columns or changes in data type.
Key Features
- The add-in models Zoho Creator entities like documents, folders, and groups as relational views, allowing you to write SQL to query Zoho Creator data.
- Stored procedures allow you to execute operations to Zoho Creator
- Live connectivity to these objects means any changes to your Zoho Creator account are immediately reflected when using the add-in.
Tables
Tables and Views will obtained dynamically from Zoho Creator.Stored Procedures
Stored Procedures are function-like interfaces to Zoho Creator. Stored procedures allow you to execute operations to Zoho Creator, including downloading documents and moving envelopes.