793
Customers have installed this add-on in at least 793 active instances.
    by Marketplace Expertfor JIRA Server 7.0.0 - 7.4.1 and more versions
    Versions available for JIRA Server 6.1 - 6.4.14
    Unsupported
    JIRA Service Desk
    This add-on is compatible with JIRA Service Desk.
    Supported
    Marketplace Expert supports this add-on.

    Get support

    Data Center
    This add-on is compatible with the clustering and high-availability capabilities of our products.
    JIRA Service Desk
    This add-on is compatible with JIRA Service Desk.
    Get it nowFree add-on

    Convert any JIRA JQL query into standard SQL in a straightforward way... and do much more than with JQL alone

    Convert any JIRA JQL query into standard SQL in a straightforward way... and do much more than with JQL alone

    Seamlessly conversion of JQL into standard SQL

    JIRA transformed into a Relational Database Server

    100% compliance with JIRA data security & privacy

    All the power of JQL and standard SQL working together without any restriction... Can you think on anything more powerful for reporting on JIRA?

    Transform JIRA into a read-only relational database server listening to the standard HTTP/S port and use standard JDBC to remotely access to your JIRA data and perform JQL as SQL... from your favorite reporting tool

    It is fully compatible with the JIRA users' account and permissions. Every SQL query runs under the privileged JIRA user's context. The plugin fully reuses the JIRA user base without requiring any user management task

    More details

    The industry's reporting tools ignore JQL. There is no support for JQL outside the Atlassian's ecosystem. So you cannot reuse the reporting tools at your company and you have to waste efforts learning custom 3rd party add-ons or use the REST API provided by Atlassian for reporting which brings a messy data model, requires coding, etc. It is a great step back.

    SQL for JIRA Drive resolves the lack of support of industry standards for reporting on JIRA by converting JQL into standard ANSI-92 SQL in a straightforward way and by allowing to connect to the JIRA API by emulating a virtual database with support for standard JDBC over HTTP/S and authenticatication with you JIRA user's credentials fully respecting the JIRA permissions to access data.

    Perform JQL as SQL from tons of third party tools at your company and integrate JIRA data with your corporate ALM seamlessly.

    Move your company toward standards. almost 800 companies are using SQL for JIRA for reporting and data integration!

    User reviews

    (12)
    Sign in to write a review
    by Sebastian Pohl on 2017-05-12
    Great addon for additional statistics and summaries. Jira and the Agile reports don't give me the statistics and summaries I need. Using SQL for Jira and the Birt reports I was able to create my own charts in the Jira dashboard. Support is also fast and great!
    Was this review helpful?YesNo
    by ernesto_laing@avivacanada.com on 2017-02-22
    Is "Insert" and "Update" are removed? For data safety only "Select" statements should be enabled
    0 out of 1 found this review helpful
    Was this review helpful?YesNo
    by Aaron Palazon on 2016-09-26
    It's great! Thank you! It resolve a lot of things for me. I don't know if I am making some mistakes or whathever but i can't find some information like worklogAuthor (the name, not the id) and the date the user put in the issue when log the work instead of the created worklog. Thank you another time!! :)
    1 out of 1 found this review helpful
    Was this review helpful?YesNo
    by Prajwal Tirpude on 2016-05-03
    Very Powerful since the jql is supported inside SQL queries which makes it awesome
    1 out of 1 found this review helpful
    Was this review helpful?YesNo
    by Agustin Martin on 2016-03-28
    Very powerful addon indeed! I've spent months searching for a way of reporting the number of times an issue was reopened during a certain period of time. I didn't like currently available solutions based on too complex plugins, or cumbersome custom fields with triggers. However with SQL for JIRA creating such a query is a breeze! Thank you!
    1 out of 1 found this review helpful
    Was this review helpful?YesNo

    Pricing

    Marketplace Expert provides support for this add-on.

    Vendor support resources

    Documentation

    Find out how this add-on works.

    See existing Q&A in Atlassian CommunityAsk a question in the Atlassian Community

    Atlassian-hosted discussions connect you to other customers who use this add-on.

    Versions

    Version 3.3.1-jira-7 JIRA Server 7.0.0 - 7.4.1 Released 2017-07-17

    Summary

    JIRA 7: Maintenance relase

    Details

    Please read the changelog for more details

    Installation

    1. Log into your JIRA instance as an admin.
    2. Click the admin dropdown and choose Add-ons. The Manage add-ons screen loads.
    3. Click Find new add-ons from the left-hand side of the page.
    4. Locate SQL for JIRA Driver - Convert JQL to SQL via search. Results include add-on versions compatible with your JIRA instance.
    5. Click Install to download and install your add-on.
    6. You're all set! Click Close in the Installed and ready to go dialog.

    To find older SQL for JIRA Driver - Convert JQL to SQL versions compatible with your instance, you can look through our version history page.

    Similar add-ons