Jira
Jira ETL connector for data replication
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 |
- 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
- 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
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 3yr ago