JIRA Cloud data to a Database

Ernesto Donate October 30, 2024

Hello Everyone, 

Currently, we retrieve our JIRA data using Tableau through a Web Data Connector. However, long term our goal is to get a subset of our JIRA data into a database we we can connect our reporting tools to it. How can we go about doing this? Is it possible to connect directly to JIRA tables using a tool like Aqua Data Studio? 

It would be great to hear how anyone in the community has accomplished creating their own JIRA data source.

Thank You!

2 answers

2 votes
Aaron Pavez _ServiceRocket_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
October 30, 2024

Hi @Ernesto Donate

 How can we go about doing this? Is it possible to connect directly to JIRA tables using a tool like Aqua Data Studio? 

Jira cloud? No, you can't. The database is not accessible. However, you can do it through a plugin. Here is a list of plugins to export the DB:

https://marketplace.atlassian.com/search?query=database

Regards

Matt Doar _Adaptavist_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 30, 2024

And set Hosting to Cloud

Like # people like this
Ernesto Donate November 1, 2024

Thanks @Aaron Pavez _ServiceRocket_ , @Matt Doar _Adaptavist_ ! Do any of you have experience using any of those plugins or have any recommendation?

 

0 votes
MobilityStream
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 7, 2024

Hi @Ernesto Donate ,

 

Many of our clients face the same issue after migrating to Jira Cloud, they lose direct access to Jira data. Some of them started using Snowflake and Databricks as their cloud-based data stores. Snowflake for example is easy to set up and can be queried with SQL. With our paid apps from the Atlassian Marketplace (Snowflake for JiraDatabricks for Jira) Jira data can easily be exported. Please check it out, if you don't mind using Snowflake or Databricks.

 

Kind regards,

The Mobility Team

 

 

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events