Reporting against a copy of the JIRA database

[Margaret Boisvert]

My company is interested in being able to report against JIRA data but we don't want to slow down the production instance.  We have a standby database that is kept up to date via replication and we would like to be able to report against that data.  We would also like to bring in additional data sources.

Does anyone have any idea if that is possible?

[Nic Brough -Adaptavist- · Accepted solution]

Reporting off a Jira database is usually a nightmare.

You're going to have to maintain a data dictionary for it, which requires a good understanding of the structure of the data.  It's built as a data store, not a database and certainly not a reporting database, so queries that you think should be "simple" really are not.  And on every addition of an add-on or upgrade, you may have to revise swathes of it!  The standard recommendations are to not do this - use the stuff built into Jira, use Apps that understand the database and upgrades for you, or extract data over REST (it's a much more intuitive shape and changes a lot less)

But, yes you can report off it, and you're absolutely right to use replication - you really don't want to be crippling the production database with some horrible queries you might end up running for reporting.

[Margaret Boisvert]

Are any tools like Dataplane able to do this type of thing?

Or is it possible to run a version of JIRA that points to that standby database and makes the REST Services available?  or we could use a plug in there?

[Nic Brough -Adaptavist-]

That's one of the Add-ons I'd go to when looking at adding reporting to Jira.