nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Extract all Jira issues to a data warehouse

Giovanni Winkels

Hi all,

Since there is a Jira Connector in Azure Data Factory v2, I am trying to extract all the issues(open, resolved, etc.) to a data warehouse.

Is there a possibility to get all the issues into one table in SQL. I tried to join several Jira tables regarding issues to each other but I keep getting the wrong number of issues.

I.E.:

Select Issues_key, Issues_Fields_Summary, Issues_Fields_Priority_Name from "Agile"."Agile_Board_Sprint_Issue"
union
select Issues_Key, Issues_Fields_Summary, Issues_Fields_Priority_Name from "Agile"."Agile_Board_Backlog_Issues"

etc.

Thanks in advance,

Giovanni

Accepted answers

All comments

Nic Brough -Adaptavist-

Heh. No.

Extracting the full issue data for one issue could be hundreds of joins on SQL. The database is the worst possible way to try to ask Jira for data in most cases!

Consider scraping it via REST instead - you can ask for issues (or a set of issues) and get a nice clean simple JSON representation of each issue in one standard format, easy to process into another database or system.

Giovanni Winkels

Hi,

Thanks for your response.

I don't need the full issue data, for every issue in Jira I need the following columns: Issue_Key, Fields_Summary, Priority_Name, Assignee_key/name, Fields_created and the reporter_name.

This information can all be found in just one table. The problem is that issues are spread over multiple Jira tables like backlog issues and sprint issues.

Nic Brough -Adaptavist-

No, that's not one table, you need at least three joins for those from just the plain issue data.

Seriously, go do this with REST, it's safer, faster, better and most importantly, easier.

Giovanni Winkels

Hi,

To be fair, I have no idea how REST works in ADFv2. I have created a linked service which is the new Jira connector. In this linked service I can't write JSON.

Do I need to use another linked service to accomplish this or can this be done by using the Jira connector as a linked service.

Regards,

Giovanni

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud