Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,300,859
Community Members
 
Community Events
165
Community Groups

Best way to connect to the JIRA database and pull data so that we can show on a management dashboard

We want to be able to pull the JIRA requests into a SQL database to display requests for Managers and what is in their current queue.  What is the best way to do that?

3 answers

0 votes
John Funk Community Leader Mar 03, 2022

Hi @Jeremy Doyle  - Did you ever get this solved?

Hi,

As mentioned already, users do not have access to the Jira Cloud database. I can suggest trying out the eazyBI app for Jira. It provides the flexibility to cover most of your reporting needs without direct access to the Jira database.

 

Kindly,

Janis, eazyBI support

0 votes

Welcome to the Community!

You can't use SQL on a Cloud system, so there's actually no question here.

Even if you could, the Jira database is simply not intended for reporting, and reading it with SQL is the very worst possible way to do any reporting on Jira data.

The best thing you can do is build your reports in a Jira dashboard, or use its dashboard reporting functions in Confluence (Jira dashboards are great for people familiar with Jira and not wanting any extraneous stuff around their charts, but Confluence pages are better for management reporting, as you can include brief explanations and detail ad-hoc rather than ask non-Jira users to have to understand exactly how Jira works)

There are other options - reporting apps can extend the Jira dashboards, give you more reporting (both inside Jira and in Confluence) and some can provide their own separate dashboarding functions!

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira Work Management

Join us for a live demo of Jira Work Management

Interested in learning more about Jira Work Management? Have questions you want to get answered? Join us for our upcoming live demo where we’ll take you through the essentials of Jira Work Manageme...

1,741 views 4 12
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you