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.
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
Last modified 2yr ago
Copy link