Data Model
Discovering Schemas
The CData SSIS Components 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 component 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 component.
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.