2,553
Customers have installed this app in at least 2,553 active instances.
2,553
Customers have installed this app in at least 2,553 active instances.
    by Marketplace Expert SLTop Vendor
    Marketplace Expert SL is a Top Vendor.  Top Vendors have high standards for app quality, reliability, and support.

    Learn more

    for Jira Server 7.0.0 - 8.6.1 and Jira Data Center 7.0.0 - 8.6.1
    Unsupported
    Jira Service Desk
    This app is compatible with Jira Service Desk.
    Supported
    Marketplace Expert SL supports this app.

    Get support

    Jira Service Desk
    This app is compatible with Jira Service Desk.
    Supported
    Marketplace Expert SL supports this app.

    Get support

    Jira Service Desk
    This app is compatible with Jira Service Desk.
    Get it nowFree app

    The unrivaled app for Jira reporting & analytics fully committed with industry-standards

    The unrivaled app for Jira reporting & analytics fully committed with industry-standards

    The unrivaled app for Jira reporting & analytics fully committed with industry-standards

    SQL+JQL console right within Jira

    Create a bunch of JQL functions not able before

    Tons of happier users accessing to relevant data

    Write, save, edit and RUN your SQL+JQL queries right within Jira.

    Feel the power of mixing SQL and JQL in a single query!!

    Fall in love with it!

    Join the future of reporting in Jira!

    Avoid the opacity of most third-party JQLs.

    Write your own on the fly!

    You control every detail and they run just as you need!

    Create your custom Dashboards to report any Jira Core, Software and Service Desk users' data with a powerful gadgets: Pivot table with drill down to the details or our flat table.

    SQL+JQL console right within Jira

    Create a bunch of JQL functions not able before

    Tons of happier users accessing to relevant data

    Write, save, edit and RUN your SQL+JQL queries right within Jira.

    Feel the power of mixing SQL and JQL in a single query!!

    Fall in love with it!

    Join the future of reporting in Jira!

    Avoid the opacity of most third-party JQLs.

    Write your own on the fly!

    You control every detail and they run just as you need!

    Create your custom Dashboards to report any Jira Core, Software and Service Desk users' data with a powerful gadgets: Pivot table with drill down to the details or our flat table.

    More details

    The #1 app that resolves reporting and analytics for Jira fully committed with industry-standards.

    Get the best of SQL and JQL languages working together with no limits.

    SQL that runs in the Jira user's security sandbox and has the same permissions than JQL

    Real-time fully honoring Jira data security and privacy whereas it resolves all the drawbacks of using SQL to read Jira users' data.

    Access to Jira data not possible before.

    All you need for analytics and reporting in Jira.

    An incredible power on your Jira available with one click only and no configuration.

    Connect Jira data to third-party analytics and reporting tools (like MS Excel, Power BI, ...)

    Built-in friendly console to write and run your own queries right within Jira.

    Pivot and flat table gadgets for Jira Dashboards and Confluence pages.

    Build on-the-fly your own JQL filters with SQL.

    Available free extensions on the Marketplace for custom fields, advanced data visualizations with Eclipse BIRT, etc.

    ...and much more!

    More details

    The #1 app that resolves reporting and analytics for Jira fully committed with industry-standards.

    Get the best of SQL and JQL languages working together with no limits.

    SQL that runs in the Jira user's security sandbox and has the same permissions than JQL

    Real-time fully honoring Jira data security and privacy whereas it resolves all the drawbacks of using SQL to read Jira users' data.

    Access to Jira data not possible before.

    All you need for analytics and reporting in Jira.

    An incredible power on your Jira available with one click only and no configuration.

    Connect Jira data to third-party analytics and reporting tools (like MS Excel, Power BI, ...)

    Built-in friendly console to write and run your own queries right within Jira.

    Pivot and flat table gadgets for Jira Dashboards and Confluence pages.

    Build on-the-fly your own JQL filters with SQL.

    Available free extensions on the Marketplace for custom fields, advanced data visualizations with Eclipse BIRT, etc.

    ...and much more!

    Reviews for cloud

    (18)
    Sign in to write a review
    by Dave Paulson on 2017-07-29
    What a great tool with even better support. I'm now able to report on JIRA data that's been largely inaccessible up until now. Coupling SfJ with BIRT I'm able to run lightning fast queries and format reports just the way I need. And I'm serious when I say the support is even better than the product. I had a very slow SQL query that's now running in about 2 seconds flat thanks to their help.
    Was this review helpful?YesNo
    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 3 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

    Reviews for server

    (18)
    Sign in to write a review
    by Michel Barros on 2020-01-09
    Fantastic APP, it does pretty well exactly what it supposed to do. Also, you guys have a very good and responsive support. CONGRATS! :)
    Was this review helpful?YesNo
    by Vladimir Jacko on 2019-12-12
    Thanks for continuously improving this powerful tool for reporting of inaccessible Jira data.
    Was this review helpful?YesNo
    by Felix Uhl on 2019-03-15
    Very useful and powerful tool! The support absolutely blew me away. Not only was a solution found within a few hours after me sending a mail to them, but they also followed up and provided a workaround that I could implement more quickly, and answered all my follow-up questions within less than an hour. The world would be a better place if support was always this good.
    Was this review helpful?YesNo
    by Paul Malone on 2018-01-31
    A great tool! And great support. The tool is a game changer for JIRA data reports. We are using JIRA for many business process automation use cases and this tool gives us reporting that runs in the context of the calling user. Lastly, the company went above an beyond helping us get the tool working through our proxy servers.
    Was this review helpful?YesNo
    by Dave Paulson on 2017-07-29
    What a great tool with even better support. I'm now able to report on JIRA data that's been largely inaccessible up until now. Coupling SfJ with BIRT I'm able to run lightning fast queries and format reports just the way I need. And I'm serious when I say the support is even better than the product. I had a very slow SQL query that's now running in about 2 seconds flat thanks to their help.
    Was this review helpful?YesNo

    Reviews for Data Center

    (18)
    Sign in to write a review
    by Dave Paulson on 2017-07-29
    What a great tool with even better support. I'm now able to report on JIRA data that's been largely inaccessible up until now. Coupling SfJ with BIRT I'm able to run lightning fast queries and format reports just the way I need. And I'm serious when I say the support is even better than the product. I had a very slow SQL query that's now running in about 2 seconds flat thanks to their help.
    Was this review helpful?YesNo
    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 3 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

    Cloud Pricing

    Server Pricing

    Data Center Pricing

    Marketplace Expert SL provides support for this app.

    Marketplace Expert SL provides support for this app.

    Vendor support resources

    Documentation

    Find out how this app works.

    Vendor support resources

    Documentation

    Find out how this app works.

    Versions

    Version 7.15.2 Jira Server 7.0.0 - 8.6.1 Released 2020-01-21

    Summary

    Support for AUI 8.5.1

    Details

    The app uses AUI 8 for a more modern look & feel and visual consistency across all the views.

    Please read the changelog for more details.

    Versions

    Version 7.15.2 Jira Data Center 7.0.0 - 8.6.1 Released 2020-01-21

    Summary

    Support for AUI 8.5.1

    Details

    The app uses AUI 8 for a more modern look & feel and visual consistency across all the views.

    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 apps or Find new add-ons from the left-hand side of the page.
    4. Locate SQL+JQL Driver: Transform JQL into SQL via search. Results include app versions compatible with your Jira instance.
    5. Click Install to download and install your app.
    6. You're all set! Click Close in the Installed and ready to go dialog.

    To find older SQL+JQL Driver: Transform JQL into SQL versions compatible with your instance, you can look through our version history page.

    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 apps or Find new add-ons from the left-hand side of the page.
    4. Locate SQL+JQL Driver: Transform JQL into SQL via search. Results include app versions compatible with your Jira instance.
    5. Click Install to download and install your app.
    6. You're all set! Click Close in the Installed and ready to go dialog.

    To find older SQL+JQL Driver: Transform JQL into SQL versions compatible with your instance, you can look through our version history page.

    Similar apps