Tables
The driver models the data in Jira as a list of tables in a relational database that can be queried using standard SQL statements.
CData ODBC Driver for Jira Tables
| Name | Description |
| Attachments | Query, insert and delete the available Attachments in Jira. |
| Boards | Query, insert and delete the agile Boards in Jira. |
| Comments | Create, modify, delete and query the available Comment types in Jira. |
| Issues | Create, modify, delete and query Issues in Jira. |
| IssueTypes | Query the available Issue Types in Jira. |
| ProjectComponents | Query, create, modify, and delete the available Components of a project in Jira. |
| ProjectRoleActors | Query the actors who act in a role for specific projects in Jira. |
| Projects | Query, update, insert and delete the available Projects in Jira. |
| ProjectVersions | Query,create, modify and delete the available Versions of a project in Jira. |
| RoleActors | Query the default actors for project roles in Jira. |
| Roles | Query the available roles in Jira. |
| Sprints | Query,create, modify and delete the agile Sprints in Jira. |
| Users | Query the available Users in Jira. |
| Workflows | Query the available Workflows in Jira. |
| Worklogs | Create, modify, delete and query the available Worklogs in Jira. |