Seeking Advice on Data Export Options from JIRA to Elasticsearch

[Cartoon Patthalakon]

Hello everyone,

Our organization is currently utilizing the JIRA Premium tier, and we're eager to perform analytics on all the data within JIRA. Unfortunately, we don't have access to Atlassian Analytics under our current subscription, and upgrading to the Enterprise tier is not within our budget at this time.

We do have access to other analytic platforms, specifically Elasticsearch, and we would like to explore options for loading our JIRA data into Elasticsearch for analysis.

I’m reaching out to see if anyone in the community can share their experiences or advice on:

1. What are the best methods for exporting data from JIRA?
2. Are there any effective ways to create a data pipeline between JIRA and Elasticsearch?

Any guidance or insights would be greatly appreciated!

Thank you! 

[Jeny Stoeva · Accepted solution]

Hi @Cartoon Patthalakon , 

Jira supports both a public REST API and CSV export. You can use either to get the data from your Jira project(s).
If you need live data access then use the API, if you want to do periodic analytics you can use CSVs. 

Once you have the data you will need to:

• Transform the data into a format suitable for Elasticsearch.
• Index the data into Elasticsearch for analysis.

If you don't know how to do it, you can ask e.g. ChatGPT or another LLM for details on the implementation. 

I am not sure the result would be worth the effort since I have seen many teams analyse Jira data but never any tangible outcomes from it.

Good luck :)