Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 80 Next »

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! (smile)


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:

Permissions


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.



  • No labels