SQL+JQL Driver for Jira


Evaluating the app?

It is intended for massive users working in parallel with Jira on their daily work basis and not for massive data,

SQL+JQL is ideal for large Jira instances with complex configurations with a lot of users as it does not overwhelm the Jira administrators with extra app user and permissions configuration. It also allows Jira administrators relying on a pool of trusted users to write SQL queries for the rest of the organization while the Jira permissions are honored under any circumstance with no data privacy leaks among the Jira users.

Essentially, it is a thin layer of standard SQL wrapping Atlassian's public Java APIs for Jira Core, Software, and Service Manager with a specific design to run SQL queries safely in a collaborative environment like Jira and avoiding all the drawbacks of using native SQL to access to the Jira database directly. 

Installing it has an almost imperceptible impact on the Jira user interface and it will be unnoticed by all of the users that will not be aware that anything changed in Jira or has been installed.

Un-instaling the app is also a simple 1-click process as almost no trash is left on Jira (one table with one record only) on the Jira database that has to be manually removed.

The app gives administrators full control to configure the pool of trusted users (belonging to a chosen user group) that can run, write and save queries from the built-in SQL console and/or access remotely via JDBC over HTTP (same port as Jira listens to).

Once the trusted user pool has been set up, the work of the Jira administrator has finished. It's time for trusted users to start the real evaluation of the app's value.

There are several video tutorials available to get an overview of the major features quickly and there is also a lot of documentation. Of course, you can ask us about any doubt or concern,  our support team will try to answer them.


Main benefits

Why SQL+JQL Driver?

  • It is standard SQL with all its benefits: industry-standards, well-defined data model, strong data type support
  • It supports most of Atlassian's public API for Jira Core, Software, and Manager from the user perspective
  • It allows combining any JQL to search from issues from a SQL query
  • It runs in the context of the calling user: every query runs always authenticated in Jira honoring the current user's permissions 
  • Almost zero configuration (only set up trusted user pool is required)
  • Support for standard JDBC over HTTP (no extra port is required to access Jira data with SQL+JQL remotely)
  • Support for public REST JSON and CSV to integrate Jira data with industry popular tools: MS Excel, MS PowerBI, Tableau, etc.
  • Deeply integrated with Jira with support to build custom JQL, custom fields, dashboards, etc. with support for basic, powerful, and friendly analytics (pivot table)
  • Support for exporting Jira data to Excel.
  • It is powered by the popular H2 Java database by reusing its SQL language parser and its high performer engine plus all the built-in H2 SQL functions to manipulate data.
  • It supports Eclipse BIRT to build advanced custom visual reports (free app available on the Atlassian Marketplace)


Short tutorial videos

These videos are a convenient introduction to all the major features of the app.


Remote access via JDBC

Jira becomes a virtual relational database with full support for standard SQL. You can connect remotely via JDBC over the HTTP protocol by using your Jira user's credentials and run Jira native JQL queries. Learn how to in less than 1:30 minutes.




Dashboards: Pivot Table

Run examples. Understand the basics. Add a Pivot Table to a Jira Dashboard.

 


MS Excel

Use SQL+JQL as Web Source to import Jira data from MS Excel for reporting and analytics,

(This video is very close the PowerBI video below, so you might want to watch one of them only)


MS PowerBI

Use SQL+JQL as Web source to import Jira data from MS PowerBI for reporting and analytics

(This video is very close the MS Excel video above, so you might want to watch one of them only)


Custom JQLs

Learn in less than three minutes how to use SQL to create your custom JQL on the fly!

Avoid the opacity of third-party JQL vendors: you decide what your JQL works with scripting (SQL).

Create your own collection of JQL functions reusable by the rest of the organizations with parameters.


Custom Fields

You can create SQL+JQL custom fields.

Learn how to display SQL +JQL results on a real-time, read-only custom field in less than three minutes:


Workflow validators and conditions

Learn how to create a validator (o condition) to control your workflows with SQL+JQL





Customize output with HTML

 Format the output of tables (flat & pivot) with HTML



Interactive GUI  (Emulate: INSERT, UPDATE & DELETE)

Write interactive user interfaces with HTML and AUI, Javascript, and the Jira REST API. Emulate the missing INSERT, UPDATE and DELETE SQL commands with Ajax.

(NOTE: There is a built-in example from version 9.6.1 quite close to this video functionality if you want to explore and run real code)

Enjoy!

The SQL+JQL Team!


Next steps...