No, you don't. Seriously, that is NOT going to "make reports easy".
To perform a full search for JIRA issues matching something, you could have to join the main issue table up to 30 times, and via multi-layered joins. Even a search for a simple custom field is 3 or 4 joins, depending on the type.
SQL is the worst way to do it.
Have a look in the marketplace for reporting add-ons. And maybe tell us what report(s) you are looking for as we might be able to point you at something better.
You'll want one that understands the JIRA database properly. There's quite a few around, but I'd lean towards EazyBI and Arsenale's Dataplane. They're very different beasts, so it's worth a look at both to compare them for your needs, and any others you find in the marketplace.
No. Absolutely not.
Access is not a proper database and it's pretty much impossible to use it as a back-end for JIRA. Even if you could get it to work (you won't), you are totally unsupported and won't be able to upgrade it.
If you mean you want to keep JIRA on a proper supported database and then try to use Access for reporting, you'll still be trying to use SQL to read JIRA, which we've already discussed as being a terrible thing to do and never "easy".
I asked this, because someone here has made some queries in access and this is the way that we report LogWorked and the add-on we use for time tracking is : https://marketplace.atlassian.com/plugins/org.everit.jira.timetracker.plugin/server/overview
Your user will have to download copies of the work logged data to mangle in Access.
By far the best way to do that is to use the REST API to pull out the data they want, then write something to change it into the shape you need.Or use the functions in the add-on you have?
No. Projects, issues, fields, workflows, time logs, comments, etc - everything that is related to "issue tracking" is done in JIRA
When the main product can't meet your specific needs because it's a generalised application, then you start looking at add-ons
Hey Community mates! Claire here from the Software Product Marketing team. We all know software development changes rapidly, and it's often tough to keep up. But from our research, we've found the h...
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!
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