Connecting to JIRA via a JDBC Driver

[freddie.burgess]

I can "Export Issues" via the UI without any issues, but I am attempting to connect to JIRA using the CData JDBC driver.

Testing the Connection Fails:

jdbc:jira:User=john.doe@company.com;Password=***********;Url=https://company.atlassian.net;

Error: You are not authorized for this operation

I need to access via JDBC to the same data produced by the Jira.csv file, when select “Export Excel CSV (All Fields)”, I suspect that this data resides in the jiradb.jiraissue table.

Is this a permissions issue?

Thanks

[Nic Brough -Adaptavist-]

Not permissions, just the connection.

I'm glad to say Cloud does not allow any direct access to the database behind Jira.  You'll have to do whatever you're trying to do with sane methods of access - UI or the REST API

[freddie.burgess]

Do you know if there are any tools available that perform the "Export Issues" --> “Export Excel CSV (All Fields)” as a scheduled automated task to deposit the Jira.csv file on the filesystem?

[Nic Brough -Adaptavist-]

It is possible with Scriptrunner on a Server install of Jira. 

Apology/Disclaimer: I work for Adaptavist, so, of course, it's part of my job to sell Scriptrunner. 

There may be other tools that can do this in the marketplace, but I do not know if there are.  Because I've got SR "on tap", I have not needed to look. 

I do know there are tools that can produce far better exports than the Jira native stuff that SR would just call.  I don't know if they could be automated this way.

Without other tools, SR could be used to build a filter, run through all the issues it returns and belt out a csv file, but I do not think this is a good solution.

However, that is very vague.  What problem are you trying to solve by having regular exports to CSV?  There's a good chance we could suggest a better solution, if we knew what the underlying problem or reporting hole is?

[freddie.burgess]

Preparing a demo for a client, who would like to automate the step in jira that exports tickets in csv/excel format to a file locally, all of the remaining steps are managed by Nifi, I'll look into your product.