The CData JDBC Driver for Trello models Trello objects as relational views. A Trello object has relationships to other objects; in the views, these relationships are expressed through foreign keys. The following sections show the available API objects and provide more information on executing SQL to Trello APIs.
- The driver models Trello Boards, Lists, Labels, and more as relational views, allowing you to write SQL to query Trello data.
- Stored procedures allow you to execute operations to Trello, including downloading and uploading objects.
- Live connectivity to these objects means any changes to your Trello account are immediately reflected when using the driver.
Collaborative Query Processing
The driver offloads as much of the SELECT statement processing as possible to Trello and then processes the rest of the query in memory. API limitations and requirements are also documented in this section.
See SupportEnhancedSQL for more information on how the driver circumvents API limitations with in-memory client-side processing.