Efficient way to download large amounts of information Jira Software

Question

Need: Download the information from JIRA to be able to measure the SLA's and then display them on a dashboard.

We worked with Time To SLA to measure the SLAS, we already have it working and the indicators are correct, but we cannot show it in eazy BI since there is no compatibility between both tools in Jira Software.

Currently we extract the data using Google Sheet to download a large amount of information, since directly from JIRA it can only be downloaded 1000 at a time. However, Google Sheet has several interruptions when downloading, so it would not be a useful tool for this request.

Keep in mind that in JIRA we handle approximately 300,000 registrations per month and to measure the SLAs it would be necessary to download the date on which the status changes.

Queries:
Is there a way at Jira Software to extract the data directly from your database?
Is there another more efficient way to download the information?

If you have any kind of support, I would greatly appreciate it.

Carlos Garcia Navarro · Accepted Answer

Hi @Ruth Estefani Carhuas Misari ,

Welcome to the Community! Did you check how to export issues using Jira API? https://community.atlassian.com/t5/Jira-articles/How-to-export-all-issues-from-Jira-via-API/ba-p/2126063

Also, you may be able to accomplish what you're trying to do with Smartsheets integration: https://marketplace.atlassian.com/apps/1215530/jira-connector-by-smartsheet?tab=overview&hosting=cloud

unknown · Accepted Answer

Hi @Ruth Estefani Carhuas Misari

Welcome to the community!!

Nice to greet you, I´m Jose from DEISER, to answer your question I will try to find the best solution to help you.

Firstly on this blog, you can find how to export issues from Jira - > https://blog.deiser.com/en/seven-ways-to-export-jira-issues

On the other hand, probably you can use a marketplace plugin to export more issues at the same time.

In DEISER, we develop different tools for the marketplace, here you can find one of our apps with all documentation and you can try our free trial -> https://marketplace.atlassian.com/apps/1212073/exporter-export-issues-to-excel-csv-pdf?hosting=cloud&tab=overview

If you need more information please reach me directly or to our support team, they are glad to help you too.

Kind regards,

Jose