The installation process is really painless and easy:
Prerequisites
- Java 8
- 1 Gb RAM extra (minimum)
- Disable "Use gzip compression" on Jira
- Jira Core 7.0.0 and above.
- (Optional): JIRA ServiceDesk 7.2.0 or above.
- (Optional) JIRA Software 7.2.1 or above.
- (Optional) Zephyr
- (OPtional) BigBrassBand Git integration for Jira
- (Optional) Subversion ALM
- Support for more third-party apps is coming
Installation
Install SQL+JQL Driver plugin on your JIRA instance from the Atlassian Marketplace.
That's all!. With a simple click, Jira has become a true relational database server listening to the standard HTTP port in a safe way!
Configuration
Finally, create a pool of trusted users to write, run and save queries for the rest of the organization by granting them access to the built-in SQL console or remotely via JDBC:
Check installation
Run some built-in examples from the built-in console.
If you run into some problem, then please read the Troubleshooting section to verify that the core features work as expected.
The app is very reliable, the easiest and quickest way to resolve access problems is by re-enabling (or even better -reinstalling) tit.
If this does not resolve it then please open an issue in our Jira instance.
Post-install
The app (NOT Jira!) must be re-enabled after any Atlassian's Jira Application (Software and/or Service Desk, etc.) or ant extension (BBB Git, Zephyr, etc) a substantial change in order to re-create all the schemas and the changes take effect.
Uninstall
Not convived to use SQL+JQL?. We are sad to see you say goodbye.
Remove the app from Jira. Optionally, you may want to delete a few plugin's tables created via Active Objects on the Jira database for a full clean-up.