Tables
The connector models the data in Jira as a list of tables in a relational database that can be queried using standard SQL statements.
CData Power BI Connector for Jira Tables
| Name | Description |
| Attachments | Provides access to issue attachments in Jira. Supports querying, inserting, and deleting file attachments associated with issues. |
| Boards | Manages the agile boards in Jira. |
| Comments | Manages comments added to issues. Supports creating, reading, updating, and deleting issue comments. |
| Groups | Lists user groups configured in the Jira instance, including group names and descriptions. |
| IssueCustomFieldOptions | Creates, modifies, deletes, and queries the configured issue custom field options in Jira. |
| Issues | Provides full access to Jira issues. Supports creation, updates, deletions, and queries for issue records across all projects. |
| IssueTypes | Returns the available issue types in Jira. |
| PermissionGrants | Displays all permission grants defined in permission schemes, including scope and associated roles or groups. |
| ProjectComponents | Manages components within Jira projects. Supports creating, updating, deleting, and querying project components. |
| ProjectRoleActors | Manages role assignments within projects. Retrieves and updates users and groups assigned to project roles. |
| Projects | Provides access to all Jira projects. Supports querying, creating, updating, and deleting project records. |
| ProjectVersions | Provides access to project version management. Supports querying, creating, updating, and deleting versions. |
| RoleActors | Manages default role actors, who are automatically assigned to roles when new projects are created. |
| Roles | Lists all roles configured in Jira, such as 'Service Desk Team' or 'Project Manager'. |
| Sprints | Manages Jira sprints. Supports creating, modifying, deleting, and querying sprint data from agile boards. |
| Statuses | Creates, updates, deletes, and queries Statuses in Jira. On Cloud, uses the Status API which supports full CRUD. SELECT without filters returns only GLOBAL-scoped statuses; PROJECT-scoped statuses must be queried by Id or Name. Requires Administer Projects and Administer Jira permissions on Cloud. On Server, queries the read-only legacy endpoint; INSERT, UPDATE, and DELETE are not supported. |
| Users | Creates, modifies, deletes, and queries the available users in Jira. |
| Watchers | Manages the available issue watchers in Jira. Supports querying, inserting, and deleting watchers. |
| Workflows | Manages the available workflows in Jira, which define the sequence of statuses and transitions for issues. |
| Worklogs | Provides full access to Jira worklogs. Supports creating, updating, deleting, and querying logged work hours on issues. |