How do i extract jira tickets to sql on azure

VR_lg6s0i

I am looking to extract reports of Jira tickets to sql hosted on azure, does anyone have any experience doing this? Any guides would be welcome.

I believe this can be done using the JIRA API and running a function on azure to extract the data as required.

Earl McCutcheon

Hello @VR ,

If you are on Jira Datacenter hosted in Azure  and just looking to have a database disconnected from the production Jira database that you can pull data from copying the database using the native copy functions in Azure would be the way to go:

• https://docs.microsoft.com/en-us/azure/azure-sql/database/database-copy?tabs=azure-powershell

However, This would only be possible if you had direct access to a self hosted Data Center deployment on Azure, and would not apply to Jira Cloud, and this thread is flagged for Jira Cloud So I am not sure if this would apply to your setup.  Also, data cloning from the API could be a possibility and I recomend looking at the following Documentation space to get started on setting up custom tooling, noting that there will be a lot of  overhead in the process:

• https://developer.atlassian.com/cloud/jira/platform/getting-started/

Additionally even for a locally hosted Jira instance  I would still advise against trying to do your own reporting on a dedicated database.  Unless you have the resources to understand the Jira database properly, and convert that into a custom data dictionary for your specific reporting requirements, and maintain the separate data clone every time JIRA is upgraded or a change applied like an add-on being installed there would be a ton of overhead to the process.

If more robust reporting is the goal, I would recomend either Looking into a paid third party Add-on app (as seen in this list) or using one of the free apps from atlassian to connect live Jira data into Excel or Google sheets where you can use those tools reporting capabilities to generate reports as needed.  Check out "Jira Cloud for Google Sheets (Official)"  and "Jira Cloud for Excel (official)"  as alternatives.

Regards,
Earl