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