Is there a way to expose a subset of JIRA data to customers so that they can run their own reports?

Question

Our customers demand many different fields of information in our release notes, and they don't all want the information sorted the same way. Delivering spreadsheets is clunky, so I'd like to give our customers the option to run their own reporting so they can generate the documents they want. Is there a plug-in that would enable us to expose certain bits of JIRA data for reporting purposes? What are all the options? Also, we don't want to give our customers VPN access.

Contact Kintosoft · Answer

SQL for JIRA provides standard SQL for reporting. All the SQL for JIRA queries are safe as they are resolved against the JIRA API according to the users and issues permissions and SQL is a very popular language for reporting and easy to use.

Renjith Pillai · Answer

Just wondering, why not share a simple filter with customized columns that they need? You may also have a shared dashboard with aggregated data meant for the customers?

Another extensive option is to use https://marketplace.atlassian.com/plugins/com.eazybi.jira.plugins.eazybi-jira for advanced reporting.

You may also some hosted BI solution like Jasper reports using the REST data source of JIRA.