nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Romy Meyers_17gioh

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.

Accepted answers

Benjamin_tmh9yg

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_17gioh

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

Romy Meyers_17gioh

Has anyone tried this:

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

All comments

Benjamin_tmh9yg

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_17gioh

thanks Ben! I will give it a try!

Romy Meyers_17gioh

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

but thx

Benjamin_tmh9yg

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_17gioh

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

Romy Meyers_17gioh

Has anyone tried this:

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-service-management-cloud

jira-service-management