データモデル
CData SSIS Components for Jira はJira API を使いやすいSQL データベースとしてモデル化します。これにより、Jira Cloud アカウントやJira Server インスタンスへの接続が可能になります。データモデルには3つのパートがあります。テーブル、ビュー、およびストアドプロシージャです。
テーブル
テーブル セクションには標準SQL テーブルの詳細が、ビュー セクションには読み取り専用SQL テーブルの一覧が記載されています。これらには、Jira アカウントでのアクセスを想定したサンプルが含まれています。
一般的なテーブルには以下のものが含まれます。
| テーブル | 説明 |
| Issues | Provides full access to Jira issues.Supports creation, updates, deletions, and queries for issue records across all projects. |
| Projects | Provides access to all Jira projects.Supports querying, creating, updating, and deleting project records. |
| IssueTypes | Queries the available Issue Types in Jira, such as Task, Bug, Epic, and so on. |
| Users | Provides access to Jira users.Supports querying user details including account ID, email, and group memberships. |
| Comments | Manages comments added to issues.Supports creating, reading, updating, and deleting issue comments. |
| Attachments | Provides access to issue attachments in Jira.Supports querying, inserting, and deleting file attachments associated with issues. |
| Worklogs | Provides full access to Jira worklogs.Supports creating, updating, deleting, and querying logged work hours on issues. |
| Boards | Enables management of agile boards in Jira.Supports creation, querying, modification, and deletion of boards. |
| Sprints | Manages Jira sprints.Supports creating, modifying, deleting, and querying sprint data from agile boards. |
| Epics | Lists all epics across Jira projects, including epic names, summaries, and keys. |
| ProjectsIssueTypes | Displays issue types configured for each project, including standard and custom issue types. |
| Statuses | Lists all available issue statuses in Jira, including custom and default statuses used in workflows. |
| Workflows | Manages the available workflows in Jira, which define the sequence of statuses and transitions for issues. |
| WorkflowSchemes | Handles the configuration of workflow schemes that assign workflows to issue types across projects. |
| IssueChangelogs | Provides a detailed history of changes made to issues, including field changes, timestamps, and authors. |
| IssueLinks | Displays relationships between issues, such as 'blocks', 'duplicates', or 'relates to'. |
| IssueFixVersions | Returns the list of versions in which specific issues are expected to be resolved. |
| IssueComponents | Lists components assigned to issues, which typically represent parts or modules of a project. |
| CustomFieldContext | Returns a list of contexts for a custom field in Jira. |
| Fields | Retrieves metadata about all fields available in Jira, including both system-defined and custom fields. |
API の制限と要件はテーブルごとに記載されています。
ストアドプロシージャ
ストアドプロシージャ は、SQL クエリを介して呼び出されるアクションです。これらは、課題や添付ファイル、OAuth トークンの管理など、標準的な作成、読み取り、更新、削除（CRUD）操作を超えるタスクを実行します。