The CData SSIS Components for Twilio models the Twilio API as relational tables and views. These are defined in schema files, which are simple, text-based configuration files.

The component uses the Twilio API to process supported filters. The component processes other filters client-side within the component.

Tables

The component models the data in tables so that it can be easily queried and updated with standard SQL.

Views

Views are tables that cannot be modified. Typically, data that are read-only and cannot be updated are shown as views.

Stored Procedures

Stored Procedures are function-like interfaces that you invoke with SQL queries. They perform tasks beyond standard create, read, update, and delete (CRUD) operations, such as sending messages, downloading media, managing call recordings, and managing conference participants.