Jira Database Driver

[Tim Foster]

I want to be able to connect to our cloud instance of the Jira database. I know there are 3rd party tools such as CData that do this, and these work really well, but at $650pm it's a bit on the expensive side.

It's clearly just a SQL based database sitting underneath, so I'd like to know if there is anyway I can connect to this, authenticated obviously, so that I can leverage some of the functionality that I can do in SQL but can't do in JQL.

It's obviously possible, as this must be how 3rd party tools work. 

[Aron Gombas _Midori_]

There is no direct access to the database on Atlassian Cloud!

I am not even sure if Atlassian persists every piece of information to a single relational database. I'd think that it is more distributed to multiple different storage (including relational, blob store, key-value pairs, etc.).

[Tim Foster]

There are tools such as cData and Devart that provide access. cData is fine but very expensive. Devart is better priced, but it seems they do not currently support the custom fields in Jira which is kind of the point.

I am able to run queries from Excel that will give me the basic Jira data using either of these tools, but cData is a very heavy price point and Devart doesn't allow me to access the custom fields which I need.

For the purposes of what I'm truing to achieve, blob data isn't important. I want to feed multiple sources, (our leave system, Slack etc) into a source that will allow me to plan based on dates that are in Jira (custom fields) and dates that are in other sources. I currently do this by manually extracting the aggregated numbers. What I want to do is remove the manual aspect and feed the data. 

[Aron Gombas _Midori_]

It is very hard for me to believe that it works. Are you sure that you are using Jira Cloud???

Isn't this the case that you are using Jira Data Center but that runs on a virtual machine (like AWS EC2)? If so, then this is not Jira Cloud, but Jira Data Center.

[Tim Foster]

Nope, it's 100% Jira Cloud. I have the trial of the cDAta connecting working perfectly in Excel (including custom fields) and I am executing my own SQL statements through the Devart odbc driver

[Aron Gombas _Midori_]

😲

[Florian Bonniec]

I'm surprised too, not sure if you can rely on this type of tool.

[Florian Bonniec]

Hi @Tim Foster 

I'm not sure it's something that can be done easily and over a long period of time but it seems that there is a free app that allow you to 'copie' cloud data app into your own database.

Database Exporter for Jira Cloud | Atlassian Marketplace

I never tried it.

Regards

[Tim Foster]

Thanks Florian, I've looked at this before. It requires duplication of the data to a second Db though which I want to avoid. If the source of truth is Jira, I don;t want a secondary source that will be out of date until the next refresh

[Florian Bonniec]

I do not think there is any other way to access JIRA database directly. I'm surprised this app even exist. You will have to fetch the information using the rest api.

[Tim Foster]

The API may be the option if I can't do it with SQL statements.