Exporting data from cloud to on-prem database

Question

For reporting purpose, we are looking at data dump from on-cloud to our on-prem database. First question is if this can be done. Second question is if it can be done, is there a standard way for doing this like data bulk download, prebuilt API or tool, etc. Thanks...

Alexey Matveev · Answer

There is no easy way. Even the Jira Cloud backup does not contain all data from Jira plugins. You should use Rest Api of these plugins.

If you want a ready made solution, have a look at the eazybi plugin:

https://marketplace.atlassian.com/apps/1211051/eazybi-reports-and-charts-for-jira?hosting=server&tab=overview

Sagun Amatya · Answer

Alexey - I am interested in not just issue data but all the data including add-ons tool that I am interested in adding. Is there an easy way to get all that data to my on-prem data warehouse? Thanks...

Alexey Matveev · Answer

Hello,

You can use Jira Cloud Rest Api to dump issue data:

https://developer.atlassian.com/cloud/jira/platform/rest/v3/?utm_source=%2Fcloud%2Fjira%2Fplatform%2Frest%2F&utm_medium=302#api-api-3-search-get