SmartQL - Power BI & Tableau & SQL

for Jira Server 7.2.0 - 8.18.2 and more
54 installs
  • Supported
  • Jira Service Management
  • Jira Software

Explore Jira data using SQL with built-in IDE or connect Tableau, Power BI and other tools using OData & JDBC

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.

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.

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

Vendor privacy policy

Security

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

Resources

Gallery

Chart and table gadgets