Efficient way to download large amounts of information Jira Software

Ruth Estefani Carhuas Misari February 20, 2023

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.

3 answers

2 accepted

1 vote
Answer accepted
Carlos Garcia Navarro
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
February 20, 2023

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

0 votes
Answer accepted
Deleted user February 21, 2023

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 

0 votes
elita_kalane
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 22, 2023

Hello @Ruth Estefani Carhuas Misari 

Thanks for raising this topic! 


​eazyBI currently doesn't have default integration with Time to SLA app, but it is in our backlog of possible integrations.

There is a workaround solution how to import data from Time to SLA app into eazyBI Jira Issues data cube. Please learn more about that here -https://confluence.snapbytes.com/time-to-sla/knowledge-base/faq/how-can-i-integrate-time-to-sla-with-eazybi

​If you have any additional questions about how to build reports after data is imported, please don't hesitate to reach out to support@eazybi.com

Best wishes,

Elita from support@eazybi.com

Zane eazyBI Support
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 23, 2024

Hi @Ruth Estefani Carhuas Misari


We have recently released eazyBI version 7.1 and introduced the new integration with the Time To SLA app. The integration is also available on the Cloud.

Please see the documentation for more details: https://docs.eazybi.com/eazybi/data-import/data-from-jira-apps/time-to-sla.

Best,
Zane / suppot@eazyBI.com

Suggest an answer

Log in or Sign up to answer