JIRA DB - How can I externally connect to JIRA DB?

Hi - I am relatively new to JIRA. In the past I have used HP QC.

 

Can someone please help me with the following questions on JIRA DB:

- What type of DB does JIRA use?

- Is it possible to connect to this DB via an external tool - such as Sqlserver or even MS Excel (via a database connection)?

 

My aim to establish a read-only connection to JIRA DB to draw some analytics.

 

Thanks,

JT

2 answers

0 vote

The database behind it could be anything - it will run on any database that supports a jdbc connection, but you will find almost all installations will be on PostGres, MySQL/Maria, Oracle or MS SQL Server, as those are the only supported databases.

You can connect to it like any other database, but, don't.

That is a fantastically bad idea - database access to JIRA is the single worst approach to reporting from it.

The database is not designed for reporting at all.  To take a simple example, "read all the data from an issue" could require joins with 40 different tables, many of them 2-3 layers deep and many of them done multiple times.

You run the risk of running queries which will put such a drag on the server, it affects performance.

Please, use the REST API to get data, or get one of the proper reporting add-ons, the ones that intrinsically understand the JIRA database and have a proper data model for it.

0 vote
Thomas Schlegel Community Champion Aug 02, 2017

Hi JT,

you can find the supported databases here:

https://confluence.atlassian.com/adminjiraserver071/supported-platforms-802592168.html

Of course, you can read data out of the Jira-database from other clients too, but in general, it is not easy to create reasonable reports from the plain jira database. You need a deep understanding of the relations in the Jira database. I would also advice to create reports on a copy of your database, so you don't edit or delete some data accidentally... 

There are several reporting plugins for Jira that can help you. Search for "reporting" on the Atlassian marketplace.

Suggest an answer

Log in or Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Posted 7 hours ago in Jira

We want to know what Jira Service Desk apps you're using!

Hi Community! My name is Amir and I’m on the Jira Service Desk product marketing team at Atlassian. Our team would love to understand how you’re leveraging our ecosystem for Jira Service Desk. Wha...

25 views 0 4
Join discussion

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you