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-

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.