Jira

Jira ETL connector for data replication

Snapshot

Features

Details

Release Status

Beta

Source API Version

v3

Table Selection

Yes

Column Selection

Yes

Edit Integration

Yes

Replication Type Selection

No

Authentication Parameters

Jira account login email Jira account password

Replication Type

Full Replication

Replication Key

NA

Suggested Replication Frequency: 24 hrs

Tables/APIs Supported

Projects

ProjectCategory

ProjectType

Resolution

ProjectRoles

Issues

Integrate Jira with Daton

  1. Signin to Daton

  2. Select Jira from Integrations page

  3. Provide Integration Name, Replication Frequency, and History. Integration name would be used in creating tables for the integration and cannot be changed later

  4. You will be redirected to Jira login for authorizing Daton to extract data periodically

  5. Post successful authentication, you will be prompted to choose from the list of available tables

  6. Then select all required fields for each table

  7. Submit the integration

Workflow

  1. Integrations would be in Pending state initially and will be moved to Active state as soon as the first job loads data successfully on to the configured warehouse

  2. Users would be able to edit/pause/re-activate/delete integration anytime

  3. Users can view job status and process logs from the integration details page by clicking on the integration name from the active list

Jira Data

Projects

Purpose: Returns projects visible to the user.

Source API Documentation https://developer.atlassian.com/cloud/jira/platform/rest/v3/#api-rest-api-3-project-search-get

Replication: Full Replication

Replication Key: NA

Fields

Name

Target Datatype

self

STRING

id

STRING

key

STRING

name

STRING

projectTypeKey

STRING

simplified

BOOLEAN

style

STRING

isPrivate

BOOLEAN

ProjectCategory

Purpose: Returns all project categories.

Source API Documentation https://developer.atlassian.com/cloud/jira/platform/rest/v3/#api-rest-api-3-projectCategory-get

Replication: Full Replication

Replication Key: NA

Fields

Name

Target Datatype

self

STRING

id

STRING

name

STRING

description

STRING

ProjectType

Purpose: Returns all project categories.

Source API Documentation https://developer.atlassian.com/cloud/jira/platform/rest/v3/#api-rest-api-3-project-type-get

Replication: Full Replication

Replication Key: NA

Fields

Name

Target Datatype

key

STRING

formattedKey

STRING

descriptionI18nKey

STRING

color

STRING

Resolution

Purpose: Returns a list of all issue resolution values.

Source API Documentation https://developer.atlassian.com/cloud/jira/platform/rest/v3/#api-rest-api-3-resolution-get

Replication: Full Replication

Replication Key: NA

Fields

Name

Target Datatype

self

STRING

id

STRING

description

STRING

name

STRING

ProjectRoles

Purpose: Project roles are a flexible way to to associate users and groups with projects. Jira Cloud, the list of project roles is shared globally with all projects, but each project can have a different set of actors associated with it. Returns all project roles and the details for each role. Note that the list of project roles is common to all projects.

Source API Documentation https://developers.Jira.com/Jira-api-reference/reference#list-companies

Replication: Full Replication

Replication Key: NA

Fields

Name

Target Datatype

self

STRING

name

STRING

id

INTEGER

description

STRING

Issues

Purpose: Returns a list of all issues.

Source API Documentation https://developer.atlassian.com/cloud/jira/platform/rest/v3/#api-rest-api-3-search-get

Replication: Full Replication

Replication Key: NA

Fields

Name

Target Datatype

id

STRING

key

STRING

fields

RECORD