Skip to:

SmartQL - Power BI & Tableau & SQL

works with Jira Server 7.2.0 - 8.21.1 and more

OVERALL RATINGS

We no longer offer sales and support for server apps. You can stay connected by exploring the migration options to either the cloud or Data Center version of this app.

Explore migration program

Key highlights of the appExplore Jira data using SQL with built-in IDE or connect Tableau, Power BI and other tools using OData & JDBC

hero

Use SQL & JQL together with built-in SQL IDE

Discover Jira data with built-in SQL engine and IDE. Use SQL & JQL together. With full respect to Jira permission system.

Connect Tableau, Power BI, etc with OData support

Connect Tableau, Power BI or any other tools that supports OData protocol. Create custom SQL views in Smart QL and expose them through OData to your BI tools.

Connect even more tools with JDBC support

With our dedicated JDBC driver you can connect your SQL tools and explore Jira data. Again, with full respect to Jira permission system.

Supporting media

More details

Essential information and links:

This app creates virtual SQL database with row level support for Jira permissions (no data leaks among your users). On top of this database you have three ways to play with your Jira data:

  • Built-in IDE like SQL console. You can search data straight in Jira, create persisted views and share them to other users. You can even create gadgets like tables and charts and place them onto dashboards.
  • JDBC with a dedicated driver. You can connect Jasper Reports, Squirrel, HeidiSQL, DBeaver or many more.
  • OData API to be use with Tableau, Power BI and other BI tools.

Some built in functions are provided for handling JIRA specific data. You can even place JQL inside your SQL queries.

Resources

Privacy and Security

Privacy policy

  • Atlassian's privacy policy is not applicable to the use of this app. Please refer to the privacy policy provided by this app's partner.

    Partner privacy policy

Security program

  • This app is not part of the Marketplace Bug Bounty program.

Version information

We no longer offer sales and support for server apps. You can still explore the earlier versions but these may not offer the necessary support.

Explore all server versions

Learn and explore

  • What’s Marketplace
  • App installation
  • About Atlassian
  • Atlassian resources
  • Search and ranking
  • Atlassian events
  • Atlassian foundation

Follow