Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Export Jira issues to an external database in real time

Laura Vallejo April 28, 2022

I would like to use Jira issues information in an external application. Is there any way to export issues to an external database in real time or once a day, or something like this?

 

I am using "External Data for Jira Fields" (https://marketplace.atlassian.com/apps/1219994/external-data-for-jira-fields?hosting=cloud&tab=versions) plugin to collect information from an external database. I need also to move information outside.

 

Thank you very much!

1 answer

1 accepted

1 vote
Answer accepted
Andy Rusnak
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
April 29, 2022

Hi Laura,

If I am understanding your questions correctly, you are looking to export data out of Jira and store it in an external database directly? Or is being exported from Jira and then ingested into a different application?

There isn't a way to do an automated timed export of fields out of Jira natively that I am aware of.  Since there isn't a prebuilt integration here, there is going to need to be some sort of middle component to allow the two systems to talk one another. 

If you are setting this up to be a scheduled job (for example at specific times during the day it would run), you could likely leverage an external script that would use the Jira REST API to extract the fields you would want and then use that script to facilitate inserting it into the external database. So this would basically create a 'middle service' that would be external to both Jira and the other system and facilitate the exchange of data.

The Atlassian Partner network may also be able to provide assistance in building a custom integration between these systems as well.  There also be some Marketplace apps that might be able help get the data out.  This looks like one example that might fit that use case: Advanced Export .  But I am not sure if this would be able to be scheduled to execute.  So you still may need a custom script here to call the export job.  

I am understanding your request correctly here? If not I would be happy to discuss further.

Best,
Andy

Suggest an answer

Log in or Sign up to answer