Ability to export data from JIRA to a SQL Server Data warehouse

[Romy Meyers]

I am searching for a plug in or process for exporting JIRA Svc Mgmt data to a SQL Server data warehouse that we utilize for metrics and reporting.

There does not appear to be a plug in like other apps such as PowerBI, etc. I did find one tool called Skyvia but no real instructions on setting up the connectors and exporting the data and scheduling. 

Has anyone used this tool and can you provide details on how to configure? 

Is there another tool perhaps that others may be using?

Any assistance is greatly appreciated. 

[Romy Meyers · Accepted solution]

Has anyone tried this: 

https://hevodata.com/integrations/source/jira/

[Romy Meyers · Accepted solution]

Has anyone tried this: https://hevodata.com/integrations/source/jira/

[Benjamin · Accepted solution]

HI @Romy Meyers ,

This Jira Cloud marketplace connector may help you with the problem you are facing:

https://marketplace.atlassian.com/apps/1221074/database-exporter-for-jira-cloud?tab=overview&hosting=cloud

This will allow to export the data and send it over to your desired DB.

-Ben

[Romy Meyers]

thanks Ben! I will give it a try!

[Romy Meyers]

i see that this only allows export to postgres and not selective databases UGH

but thx

[Benjamin]

HI @Romy Meyers ,

Would have been great if it was extended to other types of DB. Perhaps you can use a Power BI connector to extract the data for Analytics. Maybe a worthwhile approach:

https://marketplace.atlassian.com/apps/1224059/microsoft-power-bi-connector-for-jira?tab=overview&hosting=cloud

-Ben

[Romy Meyers]

thanks @Benjamin - yeah i tried that. However, would prefer to keep all data extracts consistent across all of our systems - feeding into a SQL Server DB warehouse that any reporting tool can utilize or be refreshed on schedule. 

[Romy Meyers]

thank you again though! much appreciated