Create
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Products
See all
Community resources
Top groups
Explore all groups
Community resources
Learn
Community resources
Events
Community resources

How can I export all my JIRA issue and worklog data?

Graham Meaden
Graham Meaden June 15, 2015

I want to export all my data into a database for use in an analytics and reporting tool.  What is the easiest way?

Is there a published schema? 

Answer
Watch
Like Be the first to like this
155 views

1 answer

0 votes
Nic Brough -Adaptavist-
Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Become a leader
June 15, 2015

The JIRA data is quite complex and a lot of the relationships are logical.

If you use the provided UI and external calls as designed, you can get sensible information out of it.  Reading the database to do this is pretty much a joke, because you have to recreate all the logical relationships.

You would be better off skipping "export into a database" and using the REST interface to ask sane questions.  Or better, do the reporting in JIRA.

Reply

Suggest an answer

Log in or Sign up to answer
Jira
Jira Software
TAGS
AUG Leaders

Atlassian Community Events

    See all events