Jira Connector Overview

Atlassian Jira is a project management tool that helps teams track their tasks and projects.

The Datacoral Jira connector collects data from a Jira account and enables data flow from a Jira workspace into a data warehouse, such as Redshift or Snowflake.

Features & Capabilities

  • Backfill: Full historical sync of your entire data
  • Data Extraction Modes: snapshot, incremental with pagination
  • Data Load Modes: replace, append and merge
  • Tables and Columns selection: The ability to select individual schemas, tables and columns for replication in the Datacoral's UI.
  • Data-layout: changing the data type of your columns
  • Customizations: Update the configurations easily using the UI
  • Scheduling: Highly flexible scheduling system

Supported Loadunits

The Jira connector automatically collects the following loadunits from the Jira API and makes them available in your warehouse for analysis.

LoadunitSource LinkAPI End Point
board_issueIssues for BoardGET/rest/agile/1.0/board/{boardId}/issue
boardBoardsGET /rest/agile/1.0/board/{boardId}
componentJira Components-internal-
epicEpics for BoardGET/rest/agile/1.0/epic/{epicIdOrKey}
fieldJira Fields-internal-
issueIssueGET /rest/agile/1.0/board/{boardId}/issue
issuehistorychanges to Jira issues-internal-
issuehistoryitemfetches all items in a row of the issuehistory table-internal-
projectProjectGET /rest/agile/1.0/board/{boardId}/project
sprintSprints for BoardGET /rest/agile/1.0/sprint/{sprintId}
statusall Jira StatusesGET/rest/servicedeskapi/request/{issueIdOrKey}/status
statuscategoryJira Status Categories-internal-
userJira usersGET/rest/servicedeskapi/organization/{organizationId}/user

Connector output

Output of this connector is stored in S3 and the data warehouse you chose.

AWS S3 : Data stored in AWS S3 is partitioned by date and time


Data Warehouse : Schema name will be same as <connector-name>. Tables produced by the connector are:

- schema.board
- schema.board_issue
- schema.component
- schema.epic
- schema.field
- schema.issue
- schema.issuehistory
- schema.issuehistoryitem
- schema.project
- schema.sprint
- schema.status
- schema.statuscategory
- schema.user

Next Steps

Additional Information

Got a question?

Please contact Datacoral's Support Team, we'd be more than happy to answer any of your questions.