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

    Learn more

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

    Get support

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

    Get support

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

    Transform Jira into a real relational database server powered by the Atlassian's API

    Transform Jira into a real relational database server powered by the Atlassian's API

    Transform Jira into a real relational database server powered by the Atlassian's API

    Combine JQL & SQL for industry-standard reporting

    Secure & private: no data leaks

    Jira Core, Software, Service Desk

    Use JQL to search for issues in standard SQL queries.

    Access to Jira issue fields and a lot of data not available from JQL.

    Use aggregation functions: SUM, COUNT, etc. on your JQL results to build more powerful queries

    The same SQL+JQL query returns different results depending on the 'currentUser'. This is a core feature independent of the calling tool.

    Database security at record (instead of table) level respecting JIra permissions.

    It transforms the Jira Core, Software & Service Desk Atlassian's Java APIs into a read-only tables.

    Support for JDBC over HTTP for remote reporting & third party tool integration.

    Combine JQL & SQL for industry-standard reporting

    Secure & private: no data leaks

    Jira Core, Software, Service Desk

    Use JQL to search for issues in standard SQL queries.

    Access to Jira issue fields and a lot of data not available from JQL.

    Use aggregation functions: SUM, COUNT, etc. on your JQL results to build more powerful queries

    The same SQL+JQL query returns different results depending on the 'currentUser'. This is a core feature independent of the calling tool.

    Database security at record (instead of table) level respecting JIra permissions.

    It transforms the Jira Core, Software & Service Desk Atlassian's Java APIs into a read-only tables.

    Support for JDBC over HTTP for remote reporting & third party tool integration.

    More details

    Don't use the Jira database for reporting as it has a lot of drawbacks like performance at scale, data privacy, and security, etc.

    However, it's still possible to use SQL for reporting with our virtual database: it is built on top of the Atlassian's public Jira API and resolves all those drawbacks at time.

    Our database runs on the Jira memory. It has no data. Listens to the HTTP(S) port. Supports standard SQL... and JQL... and JDBC!. Fully honors Jira permissions in real time. The queries are much easier to write as the data model is a direct representation of the Jira API, and they are much easier to maintain too as they are independent of the Jira legacy database vendor: the queries will continue working with no changes if the database is migrated to another vendor or the data model modified by Atlassian.

    It is a so much fine work that many users have really difficulties to understand they are not accessing the Jira database in any way!

    One minute tutorial

    More details

    Don't use the Jira database for reporting as it has a lot of drawbacks like performance at scale, data privacy, and security, etc.

    However, it's still possible to use SQL for reporting with our virtual database: it is built on top of the Atlassian's public Jira API and resolves all those drawbacks at time.

    Our database runs on the Jira memory. It has no data. Listens to the HTTP(S) port. Supports standard SQL... and JQL... and JDBC!. Fully honors Jira permissions in real time. The queries are much easier to write as the data model is a direct representation of the Jira API, and they are much easier to maintain too as they are independent of the Jira legacy database vendor: the queries will continue working with no changes if the database is migrated to another vendor or the data model modified by Atlassian.

    It is a so much fine work that many users have really difficulties to understand they are not accessing the Jira database in any way!

    One minute tutorial

    Reviews for cloud

    (17)
    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 2 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

    (17)
    Sign in to write a review
    by Dmitriy Kalabin on 2019-05-31
    plugin don't install..
    0 out of 2 found this review helpful
    Was this review helpful?YesNo
    Marketplace Expert

    ...and is this a problem of our app or of your Jira instance?

    Where can we rate your Jira administrator?

    ;-)

    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
    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

    Reviews for Data Center

    (17)
    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 2 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 provides support for this app.

    Marketplace Expert provides support for this app.

    Vendor support resources

    Documentation

    Find out how this app 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 app.

    Vendor support resources

    Documentation

    Find out how this app 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 app.

    Versions

    Version 7.9.0 Jira Server 7.0.0 - 8.2.2 Released 2019-05-01

    Summary

    Support for custom workflow validators and conditions

    Details

    Now, it is possible to write custom workflow

    • validators to abort issue transitions and
    • conditions to hide transitions

    depending on Jiira data by using SQL+JQL.

    Read more at: https://kintosoft.atlassian.net/wiki/x/NYCXIg

    Versions

    Version 7.9.0 Jira Data Center 7.0.0 - 8.2.2 Released 2019-05-01

    Summary

    Support for custom workflow validators and conditions

    Details

    Now, it is possible to write custom workflow

    • validators to abort issue transitions and
    • conditions to hide transitions

    depending on Jiira data by using SQL+JQL.

    Read more at: https://kintosoft.atlassian.net/wiki/x/NYCXIg

    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