Connecting to JIRA via a JDBC Driver

Question

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

freddie.burgess · Answer

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.

Nic Brough -Adaptavist- · Answer

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 · Answer

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?